List:General Discussion« Previous MessageNext Message »
From:<scheuer Date:April 27 2005 11:32am
Subject:Empty select
View as plain text  
From: root
To: mysql@stripped
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'

Thread
Empty selectscheuer27 Apr