From: root
To: mysql@lists.mysql.com
Subject: [Empty select]
>Description:
<There are records in the table (select count(*) returns 1), but
select * returns empty recordset>
>How-To-Repeat:
<
DROP TABLE IF EXISTS ugo;
CREATE TABLE ugo (
AKCE_1 char(1) default '',
AUT_KOD char(10) default '',
BONUS_CR char(1) default '',
BR_BODOVA decimal(6,2) default '0.00',
BR_BODOVA2 decimal(6,2) default '0.00',
BR_RATA int(11) default '0',
BR_UG char(10) default '',
BR_UG2 char(10) default ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1250;
insert into ugo ( BONUS_CR, BR_BODOVA, BR_BODOVA2)
values ( 'a' , 0, 0);
select count(*) from ugo;
#returns 1
select * from ugo;
#returns nothing !
>
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID>
>Originator: root
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ critical ]>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug ] >
>Release: mysql-5.0.4-beta-standard (MySQL Community Edition - Standard
>(GPL))
>Server: /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.4-beta, 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 5.0.4-beta-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 1 hour 21 min 55 sec
Threads: 4 Questions: 9563 Slow queries: 0 Opens: 0 Flush tables: 1 Open
tables: 64 Queries per second avg: 0.105
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux lipa.zepter.cz 2.6.9-1.667 #1 Tue Nov 2 14:41:25 EST 2004 i686
i686 i386 GNU/Linux
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/i386-redhat-linux/3.4.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checking --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-java-awt=gtk --host=i386-redhat-linux
Thread model: posix
gcc version 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce'
CXX='gcc' CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS=''
ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Apr 18 14:11 /lib/libc.so.6 -> libc-2.3.3.so
-rwxr-xr-x 1 root root 1504728 Oct 28 01:00 /lib/libc-2.3.3.so
-rw-r--r-- 1 root root 2404716 Oct 28 00:46 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 Oct 28 00:08 /usr/lib/libc.so
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--with-comment=MySQL Community Edition - Standard (GPL)'
'--with-server-suffix=-standard' '--without-embedded-server'
'--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl'
'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin'
'--libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--enable-thread-safe-client' '--with-readline' 'CC=gcc' 'CFLAGS=-O2 -mcpu=i486
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti ' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
