-
-
Notifications
You must be signed in to change notification settings - Fork 584
Closed
dolthub/go-mysql-server
#2437Labels
bugSomething isn't workingSomething isn't workingcorrectnessWe don't return the same result as MySQLWe don't return the same result as MySQLsqlIssue with SQLIssue with SQL
Description
For some reason, dolt's foreign key constraints don't work when columns are capitalized.
This doesn't happen in MySQL
create table t (i int primary key, j int);
alter table t add foreign key (j) references t(i);
insert into t values (1, 1); -- passes
insert into t values (2, 3); -- should error, and doescreate table t (i int primary key, J int);
alter table t add foreign key (J) references t(i);
insert into t values (1, 1); -- passes
insert into t values (2, 3); -- should error, but doesn'tMetadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't workingcorrectnessWe don't return the same result as MySQLWe don't return the same result as MySQLsqlIssue with SQLIssue with SQL