*** ERROR[1053] Unique index TRAFODION.MYTEST.A12TAB2_993451655_1997 could not be created because the specified column(s) contain duplicate data.
*** ERROR[1029] Object TRAFODION.MYTEST.A12TAB2_993451655_1997 could not be created.
*** ERROR[8839] Transaction was aborted.
--- SQL operation failed with errors.
>>showddl a12tab2;
CREATE TABLE TRAFODION.MYTEST.A12TAB2
(
INT1 INT NO DEFAULT NOT NULL NOT DROPPABLE
, VCH2 VARCHAR(3) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT NULL
)
STORE BY (INT1 ASC)
;
--- SQL operation complete.
>>select * from a12tab2;
Verified on the v0415 build installed on a workstation. This problem is now fixed:
>>create schema mytest;
--- SQL operation complete.
>>set schema mytest;
--- SQL operation complete.
>>
>>create table a12tab2 (int1 int not null, vch2 varchar(3)) store by ( int1 );
--- SQL operation complete.
>>
>>insert into a12tab2 values (1, '111'), (2, '222');
--- 2 row(s) inserted.
>>select * from a12tab2 order by int1;
INT1 VCH2
----------- ----
1 111
2 222
--- 2 row(s) selected.
>>
>>alter table a12tab2 add c3 int primary key asc;
*** ERROR[8110] Duplicate rows detected.
*** ERROR[1053] Unique index TRAFODION. MYTEST. A12TAB2_ 865741655_ 1997 could not be created because the specified column(s) contain duplicate data.
*** ERROR[1029] Object TRAFODION. MYTEST. A12TAB2_ 865741655_ 1997 could not be created.
*** ERROR[8839] Transaction was aborted.
--- SQL operation failed with errors.
>>alter table a12tab2 add c4 char(4) primary key desc;
*** ERROR[8110] Duplicate rows detected.
*** ERROR[1053] Unique index TRAFODION. MYTEST. A12TAB2_ 214151655_ 1997 could not be created because the specified column(s) contain duplicate data.
*** ERROR[1029] Object TRAFODION. MYTEST. A12TAB2_ 214151655_ 1997 could not be created.
*** ERROR[8839] Transaction was aborted.
--- SQL operation failed with errors.
>>alter table a12tab2 add c5 decimal(4,2) primary key ascending;
*** ERROR[8110] Duplicate rows detected.
*** ERROR[1053] Unique index TRAFODION. MYTEST. A12TAB2_ 887251655_ 1997 could not be created because the specified column(s) contain duplicate data.
*** ERROR[1029] Object TRAFODION. MYTEST. A12TAB2_ 887251655_ 1997 could not be created.
*** ERROR[8839] Transaction was aborted.
--- SQL operation failed with errors.
>>alter table a12tab2 add column c6 smallint primary key droppable;
*** ERROR[8110] Duplicate rows detected.
*** ERROR[1053] Unique index TRAFODION. MYTEST. A12TAB2_ 993451655_ 1997 could not be created because the specified column(s) contain duplicate data.
*** ERROR[1029] Object TRAFODION. MYTEST. A12TAB2_ 993451655_ 1997 could not be created.
*** ERROR[8839] Transaction was aborted.
--- SQL operation failed with errors.
>>showddl a12tab2;
CREATE TABLE TRAFODION. MYTEST. A12TAB2
(
INT1 INT NO DEFAULT NOT NULL NOT DROPPABLE
, VCH2 VARCHAR(3) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT NULL
)
STORE BY (INT1 ASC)
;
--- SQL operation complete.
>>select * from a12tab2;
INT1 VCH2
----------- ----
1 111
2 222
--- 2 row(s) selected.
>>
>>drop schema mytest cascade;
--- SQL operation complete.