Bug #48743 | Incomplete data (date) set while querying InnoDB table | ||
---|---|---|---|
Submitted: | 12 Nov 2009 20:43 | Modified: | 13 Nov 2009 21:14 |
Reporter: | Suresh Shanmughom | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
Version: | 5.1.39, 5.1.40 | OS: | Linux (Incomplete data (date) set while querying InnoDB table) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Incomplete data (date) set while querying InnoDB table |
[12 Nov 2009 20:43]
Suresh Shanmughom
[12 Nov 2009 21:06]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat with server built from current source. Please wait next release: miguel@quetzal3:~/dbs$ 5.0/bin/mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.42-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE TABLE `bugtest` ( -> `dt` date NOT NULL, -> PRIMARY KEY (`dt`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.01 sec) mysql> show create table bugtest\G *************************** 1. row *************************** Table: bugtest Create Table: CREATE TABLE `bugtest` ( `dt` date NOT NULL, PRIMARY KEY (`dt`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec) mysql> insert into bugtest values ('20091025'),('20091026'),('20091027'); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from bugtest; +------------+ | dt | +------------+ | 2009-10-25 | | 2009-10-26 | | 2009-10-27 | +------------+ 3 rows in set (0.00 sec) mysql> select * from bugtest where dt >= '20091025'; +------------+ | dt | +------------+ | 2009-10-25 | | 2009-10-26 | | 2009-10-27 | +------------+ 3 rows in set (0.00 sec) mysql> select * from bugtest where dt >= '2009-10-25'; +------------+ | dt | +------------+ | 2009-10-25 | | 2009-10-26 | | 2009-10-27 | +------------+ 3 rows in set (0.00 sec) mysql> select version(); +--------------+ | version() | +--------------+ | 5.1.42-debug | +--------------+ 1 row in set (0.00 sec) mysql>
[12 Nov 2009 21:21]
MySQL Verification Team
duplicate of bug #47925
[13 Nov 2009 21:14]
Suresh Shanmughom
Thanks for the prompt reply.