Debian Codegraph @

mysql-test/suite/engines/funcs/r/up_nullcheck.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(id TINYINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
3 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
4 SELECT * FROM t1 ORDER BY id;
5 id data
6 1 MySQL
7 2 ROCKS
8 3 Texas
9 4 kyle
10 UPDATE t1 SET id=id+4 WHERE id=1;
11 SELECT * FROM t1 ORDER BY id;
12 id data
13 2 ROCKS
14 3 Texas
15 4 kyle
16 5 MySQL
17 DROP TABLE t1;
18 CREATE TABLE t1(id SMALLINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
19 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
20 SELECT * FROM t1 ORDER BY id;
21 id data
22 1 MySQL
23 2 ROCKS
24 3 Texas
25 4 kyle
26 UPDATE t1 SET id=id+4 WHERE id=1;
27 SELECT * FROM t1 ORDER BY id;
28 id data
29 2 ROCKS
30 3 Texas
31 4 kyle
32 5 MySQL
33 DROP TABLE t1;
34 CREATE TABLE t1(id MEDIUMINT 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 id data
38 1 MySQL
39 2 ROCKS
40 3 Texas
41 4 kyle
42 UPDATE t1 SET id=id+4 WHERE id=1;
43 SELECT * FROM t1 ORDER BY id;
44 id data
45 2 ROCKS
46 3 Texas
47 4 kyle
48 5 MySQL
49 DROP TABLE t1;
50 CREATE TABLE t1(id INT NOT NULL, data CHAR(16), PRIMARY KEY(id));
51 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
52 SELECT * FROM t1 ORDER BY id;
53 id data
54 1 MySQL
55 2 ROCKS
56 3 Texas
57 4 kyle
58 UPDATE t1 SET id=id+4 WHERE id=1;
59 SELECT * FROM t1 ORDER BY id;
60 id data
61 2 ROCKS
62 3 Texas
63 4 kyle
64 5 MySQL
65 DROP TABLE t1;
66 CREATE TABLE t1(id INTEGER NOT NULL, data CHAR(16), PRIMARY KEY(id));
67 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
68 SELECT * FROM t1 ORDER BY id;
69 id data
70 1 MySQL
71 2 ROCKS
72 3 Texas
73 4 kyle
74 UPDATE t1 SET id=id+4 WHERE id=1;
75 SELECT * FROM t1 ORDER BY id;
76 id data
77 2 ROCKS
78 3 Texas
79 4 kyle
80 5 MySQL
81 DROP TABLE t1;
82 CREATE TABLE t1(id BIGINT NOT NULL, data CHAR(16), PRIMARY KEY(id));
83 INSERT INTO t1 VALUES (1,'MySQL'),(2,'ROCKS'),(3,'Texas'),(4,'kyle');
84 SELECT * FROM t1 ORDER BY id;
85 id data
86 1 MySQL
87 2 ROCKS
88 3 Texas
89 4 kyle
90 UPDATE t1 SET id=id+4 WHERE id=1;
91 SELECT * FROM t1 ORDER BY id;
92 id data
93 2 ROCKS
94 3 Texas
95 4 kyle
96 5 MySQL
97 DROP TABLE t1;