255
255
DROP TABLE t1, t2;
257
257
--echo # End of 5.0 tests
260
--echo # MDEV-4895 Valgrind warnings (Conditional jump or move depends on uninitialised value) in Field_datetime::get_date on GREATEST(..) IS NULL
263
CREATE TABLE t1 (dt DATETIME NOT NULL);
264
INSERT INTO t1 VALUES (NOW()),(NOW());
267
SELECT * FROM t1 WHERE concat( dt, '2012-12-21 12:12:12' ) IS NULL;
268
SELECT * FROM t1 WHERE concat( dt, '2012-12-21 12:12:12' ) IS NULL;
271
CREATE TABLE t1 (dt INT NOT NULL);
272
INSERT INTO t1 VALUES (1),(2);
274
SELECT * FROM t1 WHERE concat( dt, '1' ) IS NULL;
275
SELECT * FROM t1 WHERE concat( dt, '1' ) IS NULL;
278
CREATE TABLE t1 (dt INT NOT NULL);
279
INSERT INTO t1 VALUES (1),(2);
282
SELECT * FROM t1 WHERE NOT (concat( dt, '1' ) IS NOT NULL);
283
SELECT * FROM t1 WHERE NOT (concat( dt, '1' ) IS NOT NULL);
288
--echo # Bug mdev-5132: crash when exeicuting a join query
289
--echo # with IS NULL and IS NOT NULL in where
292
CREATE TABLE t1 (a DATE, b INT, c INT, KEY(a), KEY(b), KEY(c)) ENGINE=MyISAM;
293
CREATE TABLE t2 (d DATE) ENGINE=MyISAM;
295
SELECT * FROM t1,t2 WHERE 1 IS NOT NULL AND t1.b IS NULL;