Hi guys, there's a bug report about no precise information to solve a problem:

http://bugs.mysql.com/bug.php?id=73757

test case:

create table t11 (f1 integer primary key) engine innodb;
alter table t11 add constraint c1 foreign key (f1) references t1(f1);

/* Erro SQL (1005): Can't create table `teste`.`#sql-3f90_25c30`
(errno: 150 "Foreign key constraint is incorrectly formed") */



should be better explain that reference table t1 don't exists or
something like it

should i report at jira, or just mysql bug database is ok?




-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to