Bug #1160 order of columns selected in select statement changes number of rows returned

Description:
the order of the columns in the select statement changes the number of records returned.

select pools.ID, pools.NAME, types.NAME, DATE_FORMAT(types.SDATE, $LDF), cats.NAME, cats.SUB1, types.MULTISDATE from types, cats, pools where types.MULTISDATE IS NOT NULL and types.CATID=cats.ID and pools.TYP
ESID=types.ID

returns 1 record

select pools.ID, pools.NAME, types.MULTISDATE, types.NAME, DATE_FORMAT(types.SDATE, $LDF), cats.NAME, cats.SUB1 from types, cats, pools where types.MULTISDATE IS NOT NULL and types.CATID=cats.ID and pools.TYP
ESID=types.ID

returns 2 records

repair was run on all three tables and the same result

How to repeat:
see above in description

Not a bug. False alarm. I was opening another statement handle elsewhere in the program and it was mucking up the results.

Could you provide us with the schema and data of the tables involved
(types, cats, pools)? You can dump both with "mysqldump --opt". If
the resulting data zipped is under 500kb, you can upload it to the 
"Files" section of this bug, otherwise you can e-mail it to me at
tfr@mysql.com.

Thanks.

Thank you for your prompt response.

There was no bug however. It was a false alarm.

The was a program error which caused it to appear that there was a bug (while in a while loop fetching results, I called a function which opened another  statement, execute and fetch).

Thank you.

OK, thanks for the update. Closed.