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
SQL> recreate table t(id int, x int);
SQL> commit;
SQL> insert into t values(1, 100);
SQL> commit;
SQL> insert into t(id, x) values(2, 200) returning rdb$db_key;
DB_KEY
8100000002000000
SQL> delete from t where id=1 returning rdb$db_key;
DB_KEY
8100000001000000
SQL> update t set x=-x where id=2 returning rdb$db_key;
Statement failed, SQLSTATE = 42702
Dynamic SQL Error
-SQL error code = -204
-Ambiguous field name between table T and table T and table T
-RDB$DB_KEY
SQL> update t set x=-x where id=2 returning T.rdb$db_key; --------------- note alias "T." left side 'rdb$db_key' pseudo-column
DB_KEY
8100000002000000
SQL> update t set x=-x where id=2 returning rdb$record_version;
Statement failed, SQLSTATE = 42702
Dynamic SQL Error
-SQL error code = -204
-Ambiguous field name between table T and table T and table T
-RDB$RECORD_VERSION
SQL> update t set x=-x where id=2 returning T.rdb$record_version; --------------- note alias "T." left side 'record_version' pseudo-column
Submitted by: @pavel-zotov
On WI-T3.0.0.31810:
SQL> recreate table t(id int, x int);
SQL> commit;
SQL> insert into t values(1, 100);
SQL> commit;
SQL> insert into t(id, x) values(2, 200) returning rdb$db_key;
DB_KEY
8100000002000000
SQL> delete from t where id=1 returning rdb$db_key;
DB_KEY
8100000001000000
SQL> update t set x=-x where id=2 returning rdb$db_key;
Statement failed, SQLSTATE = 42702
Dynamic SQL Error
-SQL error code = -204
-Ambiguous field name between table T and table T and table T
-RDB$DB_KEY
SQL> update t set x=-x where id=2 returning T.rdb$db_key; --------------- note alias "T." left side 'rdb$db_key' pseudo-column
DB_KEY
8100000002000000
SQL> update t set x=-x where id=2 returning rdb$record_version;
Statement failed, SQLSTATE = 42702
Dynamic SQL Error
-SQL error code = -204
-Ambiguous field name between table T and table T and table T
-RDB$RECORD_VERSION
SQL> update t set x=-x where id=2 returning T.rdb$record_version; --------------- note alias "T." left side 'record_version' pseudo-column
RDB$RECORD_VERSION
Commits: 94e9cc9 FirebirdSQL/fbt-repository@cfbeb07
The text was updated successfully, but these errors were encountered: