>Description:
See "How-To-Repeat"
>How-To-Repeat:
vrm@food:~$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 236 to server version: 3.23.47
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use bugtest
Database changed
mysql> create table bug (id int not null auto_increment primary key,d datetime not
null);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into bug values(0,curdate());
Query OK, 1 row affected (0.01 sec)
mysql> insert into bug values(0,curdate());
Query OK, 1 row affected (0.00 sec)
mysql> insert into bug values(0,curdate());
Query OK, 1 row affected (0.00 sec)
exit mysql and log in again:
vrm@food:~$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 241 to server version: 3.23.47
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use bugtest
Database changed
mysql> select id from bug where isnull(to_days(d));
+----+
| id |
+----+
| 1 |
| 2 |
| 3 |
+----+
3 rows in set (0.00 sec)
This is wrong, because the to_days() expression results in '0', not NULL.
mysql> select id from bug where isnull(to_days(d));
Empty set (0.00 sec)
This is OK.
All further execution of this query results in the latter, correct results _in this
connection_.
Whenever you reconnect the first query results in the demonstrated bad result.
In version 3.23.49 this is reproducible, but you have to restart mysqld instead of
simply reconnecting.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Segesdi Karoly
>Organization:
>MySQL support: none
>Synopsis: too complex to describe in one line
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.47 (Slackware binary package from http://linuxpackages.net/
>)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.47
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 27 min 10 sec
Threads: 2 Questions: 2095 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables:
31 Queries per second avg: 1.285
>Environment:
System: Linux food 2.2.20RAID #3 Tue Mar 5 19:49:07 CET 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O6 -mpentiumpro -fomit-frame-pointer' CXX='gcc'
CXXFLAGS='-O6 -mpentiumpro -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Feb 9 05:21 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x 1 root root 4783716 May 26 2001 /lib/libc-2.2.3.so
-rw-r--r-- 1 root root 24721042 May 26 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 May 26 2001 /usr/lib/libc.so
Configure command: ./configure --enable-assembler --with-mysqld-ldflags=-all-static
--enable-shared --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-extra-charsets=complex
--without-debug --without-docs --without-bench --with-mysqld-user=mysql
---------------------------------------------------------------------
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
