maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Roberto!

On Aug 29, Roberto Spadim wrote:
> 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?

Better report it in Jira too, it guarantees that we will have the fix
when we merge.

Regards,
Sergei