Compare Table Data bug: not using column name to compare

[Ameen]

Hello
Compare table data page has a bug , when the source and the destination tables have the same columns but in different order, the error (column-name have different data type appears) please compare by name not by position, for example tab1.col1 is date, while tab2.col1 is number....
plsql developer version 16

 

[Ameen]

In other situation when tables have structure like this :
source table:
ID 1
CODE LANG_ID
VALIDATE_IN_LOV Y
DESCR Langauge Code
USER_UPDATABLE Y


destination table:
ID 1
CODE LANG_ID
VALIDATE_IN_LOV Y
USER_UPDATABLE Y
DESCR Langauge Code

by comparing the too tables it generates the following UPDATE statement:
UPDATE table_name T SET DESCR = 'Language Code', USER_UPDATABLE = 'Y'
WHERE ID = 1;
COMMIT;

but the too tables have the same data, but here it didn't generate (different type error) because both columns are varchar2, but the comparison is totally wrong.

Hope to be fixed as soon as possible .

thank you.

 

[Marco Kalter]

We'll investigate.