MySQL Bugs: #12910: Unable to compare two resultsets

Bug #12910	Unable to compare two resultsets
Submitted:	31 Aug 2005 14:56	Modified:	19 Sep 2005 15:00
Reporter:	Fred Testard	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.14	OS:	Windows (Win XP)
Assigned to:		CPU Architecture:	Any

Description:
Launching the "compare resultsets" function in the Query menu  returns the error message "Only two resultsets can be compared. Use the [Split Tab] function in the grid's menu to get a second grid" even when there is 2 resultsets.
(same problem in version 1.1.13, but used to work in version 1.1.9).

Other issue that may be linked : when splitting tab, the popup menu allows "remove resultset" in the new resultset, but once a query results are displayed the "Remove resultsets" becomes gray in the same menu. 

How to repeat:
- Query a table, split tab horizontally, query another table.
- launch "compare resultsets" => error message

Suggested fix:
I'd be glad to know.

Thanks for your bug report.  I was able to reporduce this bug using 1.1.15

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Could you please provide the create statement for the table you're trying to compare and select statement you use to get the resultset. Basically comparison is possible between tables of identical structure when resultset rows (can) have PKs. 

Thanks

I have tried with this and reproduced the problem. (I compare the table '_compare' with itself).

CREATE TABLE `_compare` (
  `pk` int(10) unsigned NOT NULL auto_increment,
  `value` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`pk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `_compare` (`pk`,`value`) VALUES
 (1,'toto'),
 (2,'tata');

I was able to reproduce this error in 1.1.14.  Whether I split the tab horizontally or vertically, when I run "select * from test_table" twice to populate both halves, then click "Query -> Compare ResultSets" I receive the "Only two result sets can be compared.  Use the [Split Tab] function in the grid's pop up menu to get a second grid." error every time at the bottom of the frame.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html