Hi, in two last releases is probably bug.
Im trying to add new foreign key, after save button all changes are discarded (nothing happened). See short video: https://bit.ly/318x02o
Before these releases its worked fine.
Probably the SQL is executed fine, but the table designer just not displays the new foreign key?
Check with such a query:
SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mydatabase' AND TABLE_NAME='mytable' AND REFERENCED_TABLE_NAME IS NOT NULL;
I just booted the MySQL 5.6.47 here, and I could successfully create a foreign key:
ALTER TABLE `fkey` ADD CONSTRAINT `FK_fkey_pk` FOREIGN KEY (`Column 1`) REFERENCES `pk` (`Column 1`) ON UPDATE CASCADE ON DELETE SET NULL;
The above query on IS.REFERENTIAL_CONSTRAINTS shows me the key:
The table editor also shows that key:
Please login to leave a reply, or register at first.