Andrew Schmidt writes:
> >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
>
>
Hi!
Thank you for a repeatable bug report.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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