CHECK CONSTRAINTS and MySQL version 8.0.20

tonymarston's profile image tonymarston posted 4 years ago in Feature discussion Permalink

As of MySQL version 8.0.17 the use of the UNSIGNED attribute for float, double and decimal columns has been deprecated in favour of CHECK CONSTRAINTS. Although I can create such constraints they do not appear in the "CREATE code" tab nor when I export the table's structure. When I run the SHOW CREATE TABLE command in the SQL window this DOES show all these check constraints.

Why don't the CREATE TABLE scripts shown by HeidiSQL contain the same information from the SHOW CREATE TABLE command?

Please login to leave a reply, or register at first.