Remi Catherinot wrote:
>
> >Description:
> I have a table that stores only dates, no other fields. Whenever the date value
>is set to '0001-06-01', even if the row appears in my SELECT queries, no UPDATE,
>DELETE or REPLACE can alter that row.
> I've tested it with other date as well, like '0001-04-12', the same problem
>appears.
> as far as i know, the limit is exactly 0099-12-31:
> 0099-12-31 : still bug
> 0100-01-01 : went fine
>
> >How-To-Repeat:
> here is the table structure:
> CREATE TABLE daily_report_cut_off_date (
> cut_off_date date DEFAULT '0000-00-00' NOT NULL,
> PRIMARY KEY (cut_off_date)
> );
> and I run those queries:
> INSERT INTO daily_report_cut_off_date (cut_off_date) VALUES ('0001-06-01');
> UPDATE daily_report_cut_off_date SET cut_off_date='2001-01-01' WHERE
>cut_off_date='0001-06-01';
should use "where cut_off_date like '0001-06-01';"
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 0 Changed: 0 Warnings: 0
>
> DELETE FROM daily_report_cut_off_date WHERE cut_off_date='0001-06-01';
> Query OK, 0 rows affected (0.00 sec)
same, = -> like.
>
> the row is still there, untouched
>
> >Fix:
> no workaround :(
>
> >Submitter-Id: remi catherinot
> >Originator: remi catherinot
> >Organization:
> Webmotion Inc,
> >MySQL support: none
> >Synopsis:
> >Severity: serious
> >Priority: high
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.36 (Source distribution)
>
> >Environment:
>
> System: Linux ramses.dev.lan 2.2.19pre13 #2 SMP Wed Apr 11 15:15:06 EDT 2001 i686
>unknown
> Architecture: i686
>
> Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
> gcc version 2.95.2 20000220 (Debian GNU/Linux)
> Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++'
>CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti'
> LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 14 Jun 26 04:02 /lib/libc.so.5 ->
>libc.so.5.4.46
> -rw-r--r-- 1 root root 586720 Feb 8 1999 /lib/libc.so.5.4.46
> lrwxrwxrwx 1 root root 13 Jun 26 04:02 /lib/libc.so.6 ->
>libc-2.1.3.so
> -rwxr-xr-x 1 root root 887712 Mar 25 17:35 /lib/libc-2.1.3.so
> -rw-r--r-- 1 root root 2089576 Mar 25 17:36 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Mar 25 17:36 /usr/lib/libc.so
> lrwxrwxrwx 1 root root 10 Jun 26 04:40 /usr/lib/libc-client.a ->
>c-client.a
> lrwxrwxrwx 1 root root 19 Jun 26 04:40 /usr/lib/libc-client.so ->
>libc-client.so.2000
> -rw-r--r-- 1 root root 710412 Feb 28 13:43 /usr/lib/libc-client.so.2000
> -rw-r--r-- 1 root root 665216 Apr 24 2000 /usr/lib/libc-client.so.4.7
> Configure command: ./configure --prefix=/usr --exec-prefix=/usr
>--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
>--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
>--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
>--with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid
>--without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock
>--with-mysqld-user=mysql --without-bench --with-extra-charsets=all
> Perl: This is perl, version 5.005_03 built for i386-linux
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
