Seems like a bug in 4.1.1-alpha using datetime as index.
mysql> create table foo (d datetime, index (d));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into foo values ('2003-12-15 00:00:00');
Query OK, 1 row affected (0.01 sec)
mysql> select * from foo where d like '2003%';
Empty set (0.00 sec)
mysql> select * from foo;
+---------------------+
| d |
+---------------------+
| 2003-12-15 00:00:00 |
+---------------------+
1 row in set (0.00 sec)
--
Tatsuhiko Miyagawa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
