← Back to team overview

maria-developers team mailing list archive

no information about references - mysql bug 73757

 

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


Follow ups