Product Documentation

V11.5 Release Notes

Previous Topic

Next Topic

Alter Table on table with identity field failed with error -17749

The following SQL statements caused error -17749:

create table hot(f1 integer, f2 smallint, f3 bigint, f4 integer, f5 NUMERIC(32,4), f6 VARCHAR(1000), f7 VARCHAR(256), f8 VARCHAR(5000), f9 integer);

insert into hot values(1,1,1,1,1,REPEAT('a',1000),REPEAT('b', 256), REPEAT('c',5000), 77);

commit;

ALTER TABLE hot ADD f10 INTEGER IDENTITY(1,1);

ALTER TABLE hot DROP COLUMN f1;

error(-17749): CT - bad parameter value

The logic has been modified to correct this. In addition, the checking for default values has been improved.

TOCIndex