You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
That kind of statement
------------------------
INSERT INTO TABLE1 (TABLE1_ID, TABLE2_ID, NAME, TYPE0, TYPE1, TYPE2, TYPE3, TYPE4, TYPE5) VALUES ((GEN_ID(SEK_TABLE1, 1)), ( select TABLE2_ID from TABLE2 where NAME = 'some string'), 'some string', NULL, 'W' , 0, 1, 1, 8);
-----------------
create error:
----------------
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
internal gds software consistency check (cannot restore singleton select data (284), file: rse.cpp line: 3426).
-----------------------
Substatement :
select TABLE2_ID from TABLE2 where NAME = 'some string'
gives as result only one ID - about 1000 ( 'some string' in COLUMN NAME is unique, and it exist).
Substatement for GEN_ID also givs normal result something about 1000.
---------------------
That statement works fine on FB 2.1.1, and 2.0.3, and 2.0.4.
The text was updated successfully, but these errors were encountered:
Submitted by: Stanisław Gurgacz (sgurgacz1)
Duplicates CORE2291
That kind of statement
------------------------
INSERT INTO TABLE1 (TABLE1_ID, TABLE2_ID, NAME, TYPE0, TYPE1, TYPE2, TYPE3, TYPE4, TYPE5) VALUES ((GEN_ID(SEK_TABLE1, 1)), ( select TABLE2_ID from TABLE2 where NAME = 'some string'), 'some string', NULL, 'W' , 0, 1, 1, 8);
-----------------
create error:
----------------
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
internal gds software consistency check (cannot restore singleton select data (284), file: rse.cpp line: 3426).
-----------------------
Substatement :
select TABLE2_ID from TABLE2 where NAME = 'some string'
gives as result only one ID - about 1000 ( 'some string' in COLUMN NAME is unique, and it exist).
Substatement for GEN_ID also givs normal result something about 1000.
---------------------
That statement works fine on FB 2.1.1, and 2.0.3, and 2.0.4.
The text was updated successfully, but these errors were encountered: