Oracle virtual columns definition comparison

[Leon Meerson]

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]

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