Toad World® Forums

Compareing views create wrong script

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?

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

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

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