MySQL Bugs: #45356: Query returned no resultset when there are data in a table

Bug #45356	Query returned no resultset when there are data in a table
Submitted:	5 Jun 2009 20:17	Modified:	10 Jun 2009 9:20
Reporter:	Q Kan	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.17 32-bit	OS:	Windows (64-bit XP Professional )
Assigned to:		CPU Architecture:	Any

Description:
Setup:
- I have a table, say TableA, that has 36 columns.  One of the column is set to be the primary key, say Pkey.
- The table has no data.
- Using MySQL Query Browser, I inserted a record into the table.  Only 3 columns in that record have a value, and the rest are default to NULL.

Result:
-When running the query "select * from TableA" in MySQL Query Browser, nothing is returned!
-When running a query "select PKey from TableA", the value of PKey is returned.
-When running a query to select the other two columns that have a value, the Query Browser returns a resultset.
-When running a query to select some other columns that have a NULL value, the Query Browser returns a resultset.

How to repeat:
Please see description.

Thank you for the bug report. Sorry but I couldn't with my own table and data, please provide the dump file with table and data. Thanks in advance.

Hello Miguel Solorzano:

I have already deleted both the schema and the table.  When I tried to duplicate it, I could not.

I will try to duplicate it again at a later time.  If I find anything, I will add comment to this post.

I wonder if the problem was caused by something else in that computer, as a few weeks ago, the computer could not display anything on the monitor.  It was as if the monitor was off.  I connected that computer with a different monitor that works; again, nothing was showing in the monitor.  Turned out it was an automated software update that caused the problem.

Thanks again,

Q Kan

Hello Kan,

it really looks like that your problem wasn't MySQL related. I will close this bug report now. When you have a reproducable test case feel free to re-open this bug report and add the sql dump.

Ive been getting "Query returned no resultset"., only for one table not all the time.

Query browser version 1.1.20
Server version: 5.1.45-community MySql
Windows XP