Views not equal in different schemas

Description

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.

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

3

Activity

Show:

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

Fixed

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created June 5, 2015 at 4:20 PM
Updated June 19, 2015 at 3:56 PM
Resolved June 19, 2015 at 3:56 PM