[Maria-developers] 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
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
ok https://mariadb.atlassian.net/browse/MDEV-6697 done :) 2014-09-04 13:45 GMT-03:00 Sergei Golubchik <serg@mariadb.org>:
Hi, Roberto!
Hi guys, there's a bug report about no precise information to solve a
On Aug 29, Roberto Spadim wrote: 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
participants (2)
-
Roberto Spadim -
Sergei Golubchik