359
359
--echo End of 5.0 tests
362
--echo # Bug #55779: select does not work properly in mysql server
363
--echo # Version "5.1.42 SUSE MySQL RPM"
366
CREATE TABLE t1 (a TIMESTAMP, KEY (a));
368
INSERT INTO t1 VALUES ('2000-01-01 00:00:00'), ('2000-01-01 00:00:00'),
369
('2000-01-01 00:00:01'), ('2000-01-01 00:00:01');
371
SELECT a FROM t1 WHERE a >= 20000101000000;
372
SELECT a FROM t1 WHERE a >= '20000101000000';
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';
423
--echo End of 5.1 tests