Forward engineered generated column inserts error 3105
Hi I'm trying to use MySQL Workbench .23 to insert a row into a table that has a generated column but keep getting an error about the value entered is not allowed.
I've tried null, \func, DEFAULT and even empty string and the SQL script instead of leaving that field out puts a value in the field.
How do I get Workbench to stop generating a value for that virtual field and or what value should I put since null doesn't work.
It is a virtual column and not a stored one.
Thanks
Subject
Views
Written By
Posted
Forward engineered generated column inserts error 3105
373
March 25, 2021 12:35PM
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.