Debian Codegraph @

mysql-test/suite/galera/r/galera_zero_length_column.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY , f2 VARCHAR(0)) ENGINE=InnoDB;
5 CREATE TABLE t2 (f1 VARCHAR(0)) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (1, NULL);
7 INSERT INTO t1 VALUES (2, '');
8 INSERT INTO t2 VALUES (NULL);
9 INSERT INTO t2 VALUES ('');
10 connection node_2;
11 SELECT COUNT(*) = 2 FROM t1;
12 COUNT(*) = 2
13 1
14 SELECT f2 IS NULL FROM t1 WHERE f1 = 1;
15 f2 IS NULL
16 1
17 SELECT f2 = '' FROM t1 WHERE f1 = 2;
18 f2 = ''
19 1
20 SELECT COUNT(*) = 2 FROM t2;
21 COUNT(*) = 2
22 1
23 SELECT f1 IS NULL FROM t2 WHERE f1 IS NULL;
24 f1 IS NULL
25 1
26 SELECT f1 = '' FROM t2 WHERE f1 IS NOT NULL;
27 f1 = ''
28 1
29 UPDATE t1 SET f2 = '' WHERE f1 = 1;
30 UPDATE t1 SET f2 = NULL WHERE f1 = 2;
31 UPDATE t2 SET f1 = '' WHERE f1 IS NULL;
32 connection node_1;
33 SELECT f2 = '' FROM t1 WHERE f1 = 1;
34 f2 = ''
35 1
36 SELECT f2 IS NULL FROM t1 WHERE f1 = 2;
37 f2 IS NULL
38 1
39 SELECT COUNT(*) = 2 FROM t2 WHERE f1 = '';
40 COUNT(*) = 2
41 1
42 DROP TABLE t1;
43 DROP TABLE t2;