>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';
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)
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
