MySQL Forums
Forum List  »  MySQL Workbench

Re: Generated column NOT NULL
Posted by: Ken Gillett
Date: June 21, 2019 05:33AM

Curiouser and curiouser. When the column has been created without 'NOT NULL' due to the aforementioned WB bug and then accessing the actual server, changing that column to 'NOT NUL'L then similarly fails. The SQL code that WB generates to alter the table does NOT include the 'NOT NULL' constraint.

I have tried this repeatedly but the result is always the same, WB will NOT write SQL that sets a generated column to 'NOT NULL', whether that is during a model sync or is being attempted on the server itself.

The 'get around' is to edit the SQL that WB creates and add the 'NOT NULL' where it should be and the column is then created/altered correctly and actually is set as 'NOT NULL'.

Since MySQL Server is happy with this, again it confirms this as another WB bug.

Options: ReplyQuote


Subject
Views
Written By
Posted
1289
June 16, 2019 10:05AM
Re: Generated column NOT NULL
598
June 21, 2019 05:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.