← 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:


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
Eng. Automação e Controle

Follow ups