Re: Cannot create table - cryptic error
Syntax for a virtual column is ...
col_name data_type [GENERATED ALWAYS] AS (expression)
[VIRTUAL | STORED] [NOT NULL | NULL]
[UNIQUE [KEY]] [[PRIMARY] KEY]
[COMMENT 'string']
(https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html)
WB is writing DDL for a uid as a virtual column with no expression (ie "...AS ()..." This thread probably needs to go to the WB forum, but just to confirm that, how did you tell WB to make the uid column virtual?
Edited 1 time(s). Last edit at 12/04/2018 10:24PM by Peter Brawley.
Subject
Written By
Posted
December 03, 2018 05:49PM
December 03, 2018 10:00PM
December 04, 2018 12:24PM
December 04, 2018 01:50PM
December 04, 2018 06:40PM
Re: Cannot create table - cryptic error
December 04, 2018 10:18PM
December 04, 2018 10:35PM
December 04, 2018 11:26PM
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.