diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-05-15 01:01:26 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-05-15 01:01:26 +0300 |
| commit | 258718ad24b18abc7ddd189efec54eb732c2a4b6 (patch) | |
| tree | 3dc97e13fe4695f7d461248693b9267cf1bcc638 /mysql-test/t | |
| parent | d7181839db6d77cc87eb0db8ac6ac158ee41b4d2 (diff) | |
| download | mariadb-git-258718ad24b18abc7ddd189efec54eb732c2a4b6.tar.gz | |
Fixed bug in datetime range optimization
Docs/manual.texi:
Changelog
mysql-test/r/type_datetime.result:
Test of datetime optimization
mysql-test/t/type_datetime.test:
Test of datetime optimization
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/type_datetime.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/type_datetime.test b/mysql-test/t/type_datetime.test index 1e7bd11bab1..626dedad547 100644 --- a/mysql-test/t/type_datetime.test +++ b/mysql-test/t/type_datetime.test @@ -30,3 +30,23 @@ CREATE TABLE t1 (a datetime not null); insert into t1 values (0); select * from t1 where a is null; drop table t1; + +# +# Test of datetime optimization +# + +CREATE TABLE `t1` ( + `date` datetime NOT NULL default '0000-00-00 00:00:00', + `numfacture` int(6) unsigned NOT NULL default '0', + `expedition` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`numfacture`), + KEY `date` (`date`), + KEY `expedition` (`expedition`) +) TYPE=MyISAM; + +INSERT INTO t1 (expedition) VALUES ('0001-00-00 00:00:00'); +SELECT * FROM t1 WHERE expedition='0001-00-00 00:00:00'; +INSERT INTO t1 (numfacture,expedition) VALUES ('1212','0001-00-00 00:00:00'); +SELECT * FROM t1 WHERE expedition='0001-00-00 00:00:00'; +EXPLAIN SELECT * FROM t1 WHERE expedition='0001-00-00 00:00:00'; +drop table t1; |