Debian Codegraph @

mysql-test/suite/engines/funcs/t/up_nullcheck.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(id TINYINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
5 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
6 SELECT * FROM t1 ORDER BY id;
7 UPDATE t1 SET id=id+4 WHERE id=1;
8 SELECT * FROM t1 ORDER BY id;
9 DROP TABLE t1;
10 CREATE TABLE t1(id SMALLINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
11 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
12 SELECT * FROM t1 ORDER BY id;
13 UPDATE t1 SET id=id+4 WHERE id=1;
14 SELECT * FROM t1 ORDER BY id;
15 DROP TABLE t1;
16 CREATE TABLE t1(id MEDIUMINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
17 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
18 SELECT * FROM t1 ORDER BY id;
19 UPDATE t1 SET id=id+4 WHERE id=1;
20 SELECT * FROM t1 ORDER BY id;
21 DROP TABLE t1;
22 CREATE TABLE t1(id INT NOT NULL, data CHAR(16), PRIMARY KEY(id));
23 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
24 SELECT * FROM t1 ORDER BY id;
25 UPDATE t1 SET id=id+4 WHERE id=1;
26 SELECT * FROM t1 ORDER BY id;
27 DROP TABLE t1;
28 CREATE TABLE t1(id INTEGER NOT NULL, data CHAR(16), PRIMARY KEY(id));
29 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
30 SELECT * FROM t1 ORDER BY id;
31 UPDATE t1 SET id=id+4 WHERE id=1;
32 SELECT * FROM t1 ORDER BY id;
33 DROP TABLE t1;
34 CREATE TABLE t1(id BIGINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
35 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
36 SELECT * FROM t1 ORDER BY id;
37 UPDATE t1 SET id=id+4 WHERE id=1;
38 SELECT * FROM t1 ORDER BY id;
39 DROP TABLE t1;
40