Compareing views create wrong script

Toad for Oracle
1

With the new schema Compare in Toad 12.11.0.95, scripts are created for views with aliases and inner joins, there are missing the alias list.

Example:

Generated diff scrip:

CREATE OR REPLACE VIEW V_POS
BEQUEATH DEFINER
AS
SELECT wp.REF,wp.ref_we,we.REF_LAGER,we.REF_MAND,a.REF_SUB_MAND
from INCOMING_POS wp inner join INCOMING we on (we.REF=wp.REF_WE) inner join ARTICLE a on (a.REF=wp.REF_AR)

Correct:

CREATE OR REPLACE VIEW V_PCD_WE_POS
(REF,REF_WE,REF_LAGER,REF_MAND,REF_SUB_MAND,REF_BEST_POS)
BEQUEATH DEFINER
AS
SELECT wp.REF,wp.REF_WE,we.REF_LAGER,we.REF_MAND,a.REF_SUB_MAND
from INCOMING_POS wp inner join INCOMING we on (we.REF=wp.REF_WE) inner join ARTICLE a on (a.REF=wp.REF_AR)

Is this an error or is there an option to choose?

2

Hi,
From mine point, and that what you shown, those are not the same views.
I saw several bugs in newest Toad version in schema compare…
Brg
Damir

3

Looks like the view column option was missed in the new schema compare. I’ll add it.

4

It’s not something set in the GUI, by the way…it should “just work”.