MySQL Bugs: #5169: qb not handlin union

Bug #5169	qb not handlin union
Submitted:	23 Aug 2004 15:08	Modified:	15 Nov 2004 9:52
Reporter:	Andreas Götz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.0.5	OS:	Windows (WinXP SP2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
qb seems unable to return union'ed results, same statement is working fine with cmd-line client

How to repeat:
SELECT imgurl FROM videodata UNION SELECT imgurl FROM actors

result: "The used SELECT statement have a different number of columns"

1nd issue (sorry for combining):

the Copy Message Text context menu for the error messages doesn't work, either.

Suggested fix:
1) fix union sql
2) fix context menu

mmhm. not sure this is a bug after all- I've found that one column was varchar(255) while the other was tinytext. Still- command line client is able to do this??

I wasn't able to repeat this bug using QB 1.0.5

Can you try executing the following query and tell me if it works or not:

SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10);

Thanks !

Jorge,

SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10);

works fine. Not sure if you had seen my last posting- both columns had different types which I didn't notice immediately (TINYTEXT and VARCHAR(255)). The question is probably more why this can be run in commandline client...

Not sure why bug is waiting on feedback- did not receive answer to last comment?

Thanks for the report. A seperate detection of the UNION keyword has been added. The resultset should now been returned as expected. This fix has been in the QB 1.1.0 release.