Bug #46487 Foreign keys: crash with referential_constraints selection
Submitted: 30 Jul 2009 20:49 Modified: 30 Jul 2009 20:59
Reporter: Peter Gulutzan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:6.1.0-alpha-debug OS:Linux (SUSE 11.1 64-bit)
Assigned to: Dmitry Lenev CPU Architecture:Any

[30 Jul 2009 20:49] Peter Gulutzan 
Description:
I'm using mysql-6.1-fk-stage.
I start the server with mysqld --foreign-key-all-engines=1.

I create a primary-key table.
I create a table with a reference to the primary-key table.
I select from information_schema.referential_constraints.
Crash.

How to repeat:
create table t1 (s1 int primary key) engine=innodb;
create table t2 (s1 int references t1(s1)) engine=innodb;
select * from information_schema.referential_constraints\G
[30 Jul 2009 20:59] Peter Gulutzan 
Whoops, it's more subtle than what I described,
it won't crash after a new install.

I'll put this to "can't repeat" but will try to re-open
if I can repeat after a new install.
[30 Jul 2009 22:27] MySQL Verification Team 
I couln't repeat too on Ubuntu 9.04 64-bit too.
[31 Jul 2009 14:11] Peter Gulutzan 
Dmitri Lenev has explained: there was a change of FRM format.
Not a problem.