377
--echo # Bug#50774: failed to get the correct resultset when timestamp values
378
--echo # are appended with .0
380
CREATE TABLE t1 ( a TIMESTAMP, KEY ( a ) );
382
INSERT INTO t1 VALUES( '2010-02-01 09:31:01' );
383
INSERT INTO t1 VALUES( '2010-02-01 09:31:02' );
384
INSERT INTO t1 VALUES( '2010-02-01 09:31:03' );
385
INSERT INTO t1 VALUES( '2010-02-01 09:31:04' );
387
SELECT * FROM t1 WHERE a >= '2010-02-01 09:31:02.0';
388
SELECT * FROM t1 WHERE '2010-02-01 09:31:02.0' <= a;
389
SELECT * FROM t1 WHERE a <= '2010-02-01 09:31:02.0';
390
SELECT * FROM t1 WHERE '2010-02-01 09:31:02.0' >= a;
392
--replace_column 1 x 2 x 3 x 5 x 6 x 7 x 8 x 9 x 10 x
394
SELECT * FROM t1 WHERE a >= '2010-02-01 09:31:02.0';
395
SELECT * FROM t1 WHERE a >= '2010-02-01 09:31:02.0';
397
CREATE TABLE t2 ( a TIMESTAMP, KEY ( a DESC ) );
399
INSERT INTO t2 VALUES( '2010-02-01 09:31:01' );
400
INSERT INTO t2 VALUES( '2010-02-01 09:31:02' );
401
INSERT INTO t2 VALUES( '2010-02-01 09:31:03' );
402
INSERT INTO t2 VALUES( '2010-02-01 09:31:04' );
403
INSERT INTO t2 VALUES( '2010-02-01 09:31:05' );
404
INSERT INTO t2 VALUES( '2010-02-01 09:31:06' );
405
INSERT INTO t2 VALUES( '2010-02-01 09:31:07' );
406
INSERT INTO t2 VALUES( '2010-02-01 09:31:08' );
407
INSERT INTO t2 VALUES( '2010-02-01 09:31:09' );
408
INSERT INTO t2 VALUES( '2010-02-01 09:31:10' );
409
INSERT INTO t2 VALUES( '2010-02-01 09:31:11' );
411
--echo # The bug would cause the range optimizer's comparison to use an open
412
--echo # interval here. This reveals itself only in the number of reads
415
--replace_column 1 x 2 x 3 x 5 x 6 x 7 x 8 x 9 x 10 x
417
SELECT * FROM t2 WHERE a < '2010-02-01 09:31:02.0';
418
SELECT * FROM t2 WHERE a < '2010-02-01 09:31:02.0';
419
SHOW STATUS LIKE 'Handler_read_next';
376
423
--echo End of 5.1 tests