MySQL Bugs: #21202: Query Browser has a problem with number of columns

Bug #21202	Query Browser has a problem with number of columns
Submitted:	21 Jul 2006 3:06	Modified:	21 Jul 2006 21:27
Reporter:	Joseph Morgan	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.17	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any
Tags:	query browser, too many columns

Description:
I have a SQL that Query Browser reports "Query returned no resultset".  If I remove any column (doesn't matter which one) from the select, it works fine.  Here is the SQL:

select customerevent.id AS id,
       customer.id AS customerID,
       customer.lastName AS customerLastName,
       customer.firstName AS customerFirstName,
       customer.address1 AS customerAddress1,
       customer.address2 AS customerAddress2,
       customer.city AS customerCity,
       customer.state AS customerState,
       customer.postalCode AS customerPostalCode,
       customer.phone1 AS customerHomePhone,
       customer.phone2 AS customerMobilePhone,
       customer.phone3 AS customerOtherPhone,
       customer.email AS customerEmail,
       customer.userName AS customerUserName,
       customer.password AS customerPassword,
       event.id AS eventID,
       event.name AS eventName,
       event.address1 AS eventAddress1,
       event.address2 AS eventAddress2,
       event.city AS eventCity,
       event.state AS eventState,
       event.postalCode AS eventPostalCode,
       event.description AS eventDescription,
       event.beginDate AS eventBeginDate,
       event.beginTime AS eventBeginTime,
       event.endDate AS eventEndDate,
       event.endTime AS eventEndTime,
       event.pending AS eventPending
from customer left join customerevent on customer.id = customerevent.customerID
              left join event on customerevent.eventID = event.id;

How to repeat:
If I take out any one column from the select, it works. If I add the column back in, anywhere, it reports no results.

It works against MySQL from a Java program.

Thank you for the report.

Please, provide output of SHOW CREATE TABLE customer, SHOW CREATE TABLE customerevent, SHOW CREATE TABLE event statements

CREATE TABLE `customer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `lastName` varchar(64) NOT NULL default '',
  `firstName` varchar(64) NOT NULL default '',
  `address1` varchar(255) NOT NULL default '',
  `address2` varchar(255) default '',
  `city` varchar(128) NOT NULL default '0',
  `state` char(2) NOT NULL default '0',
  `postalCode` varchar(10) NOT NULL default '0',
  `phone1` varchar(15) NOT NULL default '',
  `phone2` varchar(15) default '',
  `phone3` varchar(15) default '',
  `email` varchar(128) NOT NULL default '',
  `userName` varchar(32) default '',
  `password` varchar(32) default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `event` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `address1` varchar(255) NOT NULL default '',
  `address2` varchar(255) default '',
  `city` varchar(128) NOT NULL default '0',
  `state` char(2) NOT NULL default '0',
  `postalCode` varchar(10) default '0',
  `description` text,
  `beginDate` date NOT NULL default '0000-00-00',
  `endDate` date default '0000-00-00',
  `beginTime` time default '00:00:00',
  `endTime` time default '00:00:00',
  `pending` char(1) NOT NULL default 'Y',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `customerevent` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `customerID` int(10) unsigned NOT NULL default '0',
  `eventID` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `ceCustomerID` (`customerID`),
  KEY `ceEventID` (`eventID`),
  CONSTRAINT `FK_CustomerID` FOREIGN KEY (`customerID`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_EventID` FOREIGN KEY (`eventID`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1

I can not repeat it using test data in MySQL Query Browser 1.1.20 and MySQL Query Browser 1.2.1 beta.

Current version of MySQL Query Browser you can download at

  http://www.mysql.com/downloads/