Oracle virtual columns definition comparison

13 views
Skip to first unread message

Leon Meerson

unread,
Jun 4, 2019, 11:55:14 AM6/4/19
to DB Solo
Looks like the virtual column definition is not compared properly.
These two tables come up as identical in schema compare.

Running DB Solo 5.2.3, Oracle 11.0.4

Schema A:

CREATE TABLE T (
  X VARCHAR2(32 CHAR),
  Y VARCHAR2(32 CHAR),
  Z AS (X || Y)
  );

Schema B:

CREATE TABLE T (
  X VARCHAR2(32 CHAR),
  Y VARCHAR2(32 CHAR),
  Z AS (Y || X)
  );

Is it a known issue?

DB Solo Admin

unread,
Jun 4, 2019, 9:35:50 PM6/4/19
to DB Solo
With the 5.2.4 version I see the following difference reported

Default values do not match.
Destination : "Y"||"X"
Source : "X"||"Y"

It's not 100% correct but you should at least see the difference detected?

marko
Reply all
Reply to author
Forward
0 new messages