2 messages in com.mysql.lists.bugsWrong number of rows returned in sele...
FromSent OnAttachments
Ari Bernstein12 Jun 2001 12:05 
Michael Widenius12 Jun 2001 15:00 
Subject:Wrong number of rows returned in select statement
From:Michael Widenius (mon@mysql.com)
Date:06/12/2001 03:00:32 PM
List:com.mysql.lists.bugs

Hi!

"Ari" == Ari Bernstein <ar@arimail.com> writes:

Ari> Description: Ari> An identical select query with identical data returns 174 rows using MySql Ari> but only 6 with Oracle, DB2, and Sqlserver. A similar and logically Ari> identical query returns only 6 rows with MySql. Environment is Ari> mysql-3.23.33 binary on Windows 98 SE.

Ari> How-To-Repeat:

Ari> The following query returns 174 rows with MySql but 6 with oracle, db2, Ari> sqlserver:

<cut>

Ari> I would include the 174 result rows from the query but the list mailer Ari> daemon seems to reject messages greater than 30k.

<cut>

If you could upload the tables in the query to:

ftp://support.mysql.com/pub/mysql/secret

we will try to fix this.

Regards, Monty