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


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE t1 (f1 INT DEFAULT NULL, UNIQUE KEY i1 (f1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (NULL);
INSERT INTO t1 VALUES (NULL);
SELECT COUNT(*) = 2 FROM t1;
COUNT(*) = 2
1
SELECT f1 IS NULL FROM t1;
f1 IS NULL
1
1
DROP TABLE t1;