MySQL Bugs: #20467: Spurious errors reported while executing script

Bug #20467	Spurious errors reported while executing script
Submitted:	14 Jun 2006 18:05	Modified:	16 Nov 2006 13:02
Reporter:	Tonci Grgin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.20	OS:	Windows (Win XP SP2)
Assigned to:	Tatiana Azundris Nuernberg	CPU Architecture:	Any
Tags:	Source Editors

Description:
I ran into this while working on bug report 20366.

How to repeat:
Start MySQL Query Browser, connect to server, open New script window and paste script bellow:

drop database if exists cannotREme;
drop database if exists testdb;
create database testdb;

use testdb;
CREATE TABLE `forRefDB` (
  `siteId` int(10) unsigned NOT NULL,
  `uid` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`uid`,`siteId`)
) ENGINE=InnoDB ;

create database cannotREme;
use cannotREme;
CREATE TABLE `forRefTable` (
  `id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB ;
  
CREATE TABLE `mainTable` (
  `uid` int(10) unsigned NOT NULL,
  `siteId` int(10) unsigned NOT NULL,
  `refId` int(10) unsigned NOT NULL,
  KEY `refId` (`refId`),
  KEY `siteId` (`siteId`),
  KEY `uid` (`uid`,`siteId`),
  CONSTRAINT `mainTable_ibfk_1` FOREIGN KEY (`refId`) REFERENCES `forRefTable`
(`id`),
  CONSTRAINT `mainTable_ibfk_2` FOREIGN KEY (`uid`, `siteId`) REFERENCES
`testdb`.`forRefDB` (`uid`, `siteId`)
) ENGINE=InnoDB ;

You'll get errors as in attached image. I should mention that neither of databases were present on my MySQL 5.0.23-debug BK server residing on Suse 10.

Suggested fix:
?

Image showing error

Attachment: 20467.jpg (image/jpeg, text), 93.96 KiB.

Script executed correctly.

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

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