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);
insert into ugo ( BONUS_CR, BR_BODOVA, BR_BODOVA2) values ( 'b' , 0, 0);
select count(*) from ugo;
#returns 2
select * from ugo;
#returns nothing !
Submitter-Id:
Originator: [EMAIL PROTECTED]
Organization:
MySQL support: none
Synopsis:
Severity: critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-5.0.4-beta-standard
Server version 5.0.4-beta-standard
System: Windows 98
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
