Verified. this is a bug!!!!
empty table or 1 record returns expected result, insert one more record and
the result of now() is empty.
mysql> select now(), count(*) from t where a in (2);
| now() | count(*) |
| 2001-04-21 08:12:03 | 0 |
1 row in set (0.00 sec)
mysql> insert into t (a) values (1);
mysql> select now(), count(*) from t where a in (2);
| now() | count(*) |
| | 0 |
1 row in set (0.01 sec)
verified on version 3.23.32-debug (w2k) binary.
----- Original Message -----
From: "Andrew Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 11:31 PM
Subject: bug report
> >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
> [EMAIL PROTECTED]
> 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
>
>
> ---------------------------------------------------------------------
> 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