Next bug in comparison

[Kuba]

There is another bug in compare processor.

Try to create in DB1 such table:

create table TEST
(
  A VARCHAR2(10) not null,
  B INTEGER not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes
create unique index U_X on TEST (B)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

and in DB2:

create table TEST
(
  A VARCHAR2(10) not null,
  C INTEGER not null,
  B INTEGER not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes
create unique index U_X on TEST (B)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

Try to compare DB1 with DB2. You'll get:

--  Changed table test  --
--------------------------
-- Add/modify columns
alter table TEST rename column B to C;

Then try to compare DB2 with DB1. You'll get:

----------------------------
--  No differences found  --
----------------------------

 

[Marco Kalter]

This is indeed not correct. We'll fix it.