Views not equal in different schemas
Description
Environment
Darwin glz-macbookpro 14.3.0 Darwin Kernel Version 14.3.0: Mon Mar 23 11:59:05 PDT 2015; root:xnu-2782.20.48~5/RELEASE_X86_64 x86_64
java version "1.6.0_65"
Java(TM) SE Runtime Environment (build 1.6.0_65-b14-466.1-11M4716)
Java HotSpot(TM) 64-Bit Server VM (build 20.65-b04-466.1, mixed mode)
Liquibase Version: 3.3.5
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Attachments
Activity
Nathan Voxland June 19, 2015 at 3:56 PM
Tests pass for me in the 3.4.0 code
Goran Lowkrantz June 5, 2015 at 4:21 PM
Diff Results:
Reference Database: AVIEW2 @ jdbc:oracle:thin:@mjolner.hq.ismobile.com:1521:mjolner (Default Schema: AVIEW2)
Comparison Database: AVIEW1 @ jdbc:oracle:thin:@mjolner.hq.ismobile.com:1521:mjolner (Default Schema: AVIEW1)
Product Name: EQUAL
Product Version: EQUAL
Missing Catalog(s): NONE
Unexpected Catalog(s): NONE
Changed Catalog(s):
AVIEW2
name changed from 'AVIEW2' to 'AVIEW1'
Missing Column(s): NONE
Unexpected Column(s): NONE
Changed Column(s): NONE
Missing Foreign Key(s): NONE
Unexpected Foreign Key(s): NONE
Changed Foreign Key(s): NONE
Missing Index(s): NONE
Unexpected Index(s): NONE
Changed Index(s): NONE
Missing Primary Key(s): NONE
Unexpected Primary Key(s): NONE
Changed Primary Key(s): NONE
Missing Schema(s): NONE
Unexpected Schema(s): NONE
Changed Schema(s):
AVIEW2.AVIEW2
name changed from 'AVIEW2' to 'AVIEW1'
Missing Sequence(s): NONE
Unexpected Sequence(s): NONE
Changed Sequence(s): NONE
Missing Stored Procedure(s): NONE
Unexpected Stored Procedure(s): NONE
Changed Stored Procedure(s): NONE
Missing Table(s): NONE
Unexpected Table(s): NONE
Changed Table(s): NONE
Missing Unique Constraint(s): NONE
Unexpected Unique Constraint(s): NONE
Changed Unique Constraint(s): NONE
Missing View(s): NONE
Unexpected View(s): NONE
Changed View(s):
C_ASGTS (C_ASGTS.WIID,C_ASGTS.COLORREF,C_ASGTS.DOCUMENT_ID,C_ASGTS.ASSFLOW,C_ASGTS.CTSTAMP,C_ASGTS.COMPANY_ID,C_ASGTS.ACTUID,C_ASGTS.DISPATCHED,C_ASGTS.STARTTIME,C_ASGTS.RESUID,C_ASGTS.INSTOP,C_ASGTS.STATUS,C_ASGTS.STOP,C_ASGTS.WRITELOCK,C_ASGTS.TIMESTAMP,C_ASGTS.REASSIGN,C_ASGTS.ASGT_ACTIVE)
schema changed from 'AVIEW2.AVIEW2' to 'AVIEW1.AVIEW1'
C_ASGTSTST (C_ASGTSTST.WIID,C_ASGTSTST.COLORREF,C_ASGTSTST.DOCUMENT_ID,C_ASGTSTST.ASSFLOW,C_ASGTSTST.CTSTAMP,C_ASGTSTST.COMPANY_ID,C_ASGTSTST.ACTUID,C_ASGTSTST.DISPATCHED,C_ASGTSTST.STARTTIME,C_ASGTSTST.RESUID,C_ASGTSTST.INSTOP,C_ASGTSTST.STATUS,C_ASGTSTST.STOP,C_ASGTSTST.WRITELOCK,C_ASGTSTST.TIMESTAMP,C_ASGTSTST.REASSIGN,C_ASGTSTST.ASGT_ACTIVE)
schema changed from 'AVIEW2.AVIEW2' to 'AVIEW1.AVIEW1'
C_ASGTSTST2 (C_ASGTSTST2.WIID,C_ASGTSTST2.COLORREF,C_ASGTSTST2.DOCUMENT_ID,C_ASGTSTST2.ASSFLOW,C_ASGTSTST2.CTSTAMP,C_ASGTSTST2.COMPANY_ID,C_ASGTSTST2.ACTUID,C_ASGTSTST2.DISPATCHED,C_ASGTSTST2.STARTTIME,C_ASGTSTST2.RESUID,C_ASGTSTST2.INSTOP,C_ASGTSTST2.STATUS,C_ASGTSTST2.STOP,C_ASGTSTST2.WRITELOCK,C_ASGTSTST2.TIMESTAMP,C_ASGTSTST2.REASSIGN,C_ASGTSTST2.ASGT_ACTIVE)
schema changed from 'AVIEW2.AVIEW2' to 'AVIEW1.AVIEW1'
Liquibase 'diff' Successful
Running the test script attached generates one table and thee views from it, testing all createView syntaxes. This was done with two Oracle users.
Running a diff against the two users results in all views flagged as changed. This was tesed with default values of --outputDefaultSchema and --outputDefaultCatalog and with both set to false with the same result.
Given that the table si not seen as different, more should the views.