Schema compare. Triggers differ (although equal) when comparing a schema on Oracle 18 against Oracle 10.2

Toad for Oracle - Beta
1

When comparing two schemas (one on an ORacle 18 server, the other on a 10.2 server), all triggers are listed as different.
In the Differs By column, validity is listed for all of them.

I have checked which SQL statements are executed.
On the 18 server it is this:

Select object_name, object_id, status, editionable
from  sys.USER_OBJECTS
where 1=1
and object_type = 'TRIGGER'
order by 1;

This lists VALID for all triggers.

On the 10 server it is this:

Select object_name, object_id, status, null as editionable
from  sys.USER_OBJECTS
where 1=1
and status = 'INVALID'
and object_type = 'TRIGGER'
order by 1;

This does not return any rows because no Trigger is INVALID.

Is there any way around this?

2

Re: Validity - unfortunately, that's a bug and I see no workaround. :frowning:

I'll have it fixed for Monday's beta.

3

I will test this with the new beta.

However, I'm not sure what you mean by the second part of your answer :wink:

4

I'm not sure what you mean by the second part of your answer

oops, when I read this: In the Differs By column, validity is listed for all of them.
I misread it, thinking that Differs by showed both columns and validity. I edited my post to remove the second part of my answer.

This should be fixed in today's beta.