← Back to team overview

maria-developers team mailing list archive

Re: no information about references - mysql bug 73757

 

ok https://mariadb.atlassian.net/browse/MDEV-6697
done :)


2014-09-04 13:45 GMT-03:00 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
>



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

References