>Description:
tough one to describe. the step by step example shows all
basicly once a table gets more than 1 row and doing a select with no
result will yield a blank date... gah please see the example =)
>How-To-Repeat:
create database tmpdb;
use tmpdb;
create table test (foo int);
insert into test values (1);
select NOW(), count(*) from test where foo in (2);
+---------------------+----------+
| NOW() | count(*) |
+---------------------+----------+
| 2001-04-20 17:21:29 | 0 |
+---------------------+----------+
insert into test values (1);
select NOW(), count(*) from test where foo in (2);
+-------+----------+
| NOW() | count(*) |
+-------+----------+
| | 0 |
+-------+----------+
notice the date field is blank.
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID>
>Originator: Andrew Schmidt
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.23.37 (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: FreeBSD wrk-112.tor1.targetnet.pvt 4.2-STABLE-20010112-JPSNAP
FreeBSD 4.
2-STABLE-20010112-JPSNAP #0: Thu Jan 11 20:06:54 GMT 2001
root@stripped
reebsd.org:/usr/src/sys/compile/GENERIC i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/
bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1169222 Jan 11 14:28 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Jan 19 13:01 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 559420 Jan 11 14:28 /usr/lib/libc.so.4
Configure command:
./configure --localstatedir=/usr/local/var/db/mysql --withou
t-perl --without-debug --without-readline --without-bench --enable-assembler
--e
nable-thread-safe-client
Perl: This is perl, version 5.005_03 built for i386-freebsd
