Comment 3 for bug 1413767

Revision history for this message
Weishiun Tsai (wei-shiun-tsai) wrote :

Verified on the v0210 build installed on a workstation. This problem has been fixed:

>>create schema my_sch1;

--- SQL operation complete.
>>set schema my_sch1;

--- SQL operation complete.
>>
>>create table mytab (
+>a LARGEINT GENERATED ALWAYS AS IDENTITY NOT NULL NOT DROPPABLE,
+>b int);

--- SQL operation complete.
>>
>>insert into mytab values (DEFAULT, 1);

--- 1 row(s) inserted.
>>select * from mytab;

A B
-------------------- -----------

                   1 1

--- 1 row(s) selected.
>>
>>drop schema my_sch1 cascade;

--- SQL operation complete.
>>get tables;

--- SQL operation complete.
>>
>>create schema my_sch2;

--- SQL operation complete.
>>set schema my_sch2;

--- SQL operation complete.
>>
>>create table mytab (
+>a LARGEINT GENERATED ALWAYS AS IDENTITY NOT NULL NOT DROPPABLE,
+>b int);

--- SQL operation complete.
>>
>>insert into mytab values (DEFAULT, 1);

--- 1 row(s) inserted.
>>select * from mytab;

A B
-------------------- -----------

                   1 1

--- 1 row(s) selected.
>>
>>drop table mytab cascade;

--- SQL operation complete.
>>get tables;

--- SQL operation complete.
>>drop schema my_sch2 cascade;

--- SQL operation complete.
>>get tables;

--- SQL operation complete.
>>