FK keys - cannot add - BUG

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

MySQL 5.6.

Before these releases its worked fine.

Im trying to create FK with plain SQL

ALTER TABLE pp_forum_post ADD CONSTRAINT fk_forum FOREIGN KEY (pp_forum_id) REFERENCES pp_forum(id) ON DELETE RESTRICT ON UPDATE CASCADE

with same result :/

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 dont think so. If it worked, another attempt to add the same FK would end with some MySQL error, right?

Your query returns empty set :/

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:

Hi ansgar, im really sorry, its my f**** fault, tables were created in MyISAM mode not InnoDB.

I completely overlooked it and looked for the problem elsewhere, sorry again :(