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;
--- 1 row(s) selected. >> >>drop table mytab cascade;
--- SQL operation complete. >>drop schema my_sch2 cascade;
--- SQL operation complete. >>
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 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 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.
>>