Oops, I didn't mean "datetime as index", but "like with datetime" is
broken in 4.1.1.
On Tue, 16 Dec 2003 03:12:20 +0900
Tatsuhiko Miyagawa <[EMAIL PROTECTED]> wrote:
> 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]
>
--
Tatsuhiko Miyagawa <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
