BUG!!!!
This has been an issue with Oracle tools for some time.
A table with a Generated column has a bug which inserts an extra right parentheses in its definition. Can be seen in Source Control as well as Schema Compare.
ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1)) NOT NULL,
tool generates:
ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1))) NOT NULL,
Anonymous
shared this idea
-
Julia Hayward
commented
(Note: has been fixed, possibly for some time)
-
AdminEddie
(Admin, Redgate)
commented
Hi
Can you please report this error to the Redgate Product Support Team? Please use either the Support Portal [https://productsupport.red-gate.com/hc/en-us] and click the 'Submit a request' button or email [support@red-gate.com].
A support ticket will be created for you and one of our engineers can investigate the problem for you.
-
Anonymous
commented
You can improve it by fixing the bug.