description: Consider the following test case:

create table TEST (UID varchar(64));

update or insert into TEST (UID) values (uuid_to_char(gen_uuid())) matching (UID);

This leads to "column unknown" in FB3.0 while it works in FB2.5.

=>

Consider the following test case:

create table TEST (UID varchar(64));

update or insert into TEST (UID) values (uuid_to_char(gen_uuid())) matching (UID);

This leads to "column unknown" in FB3.0 while it works in FB2.5.

In FB2.5, even

update or insert into TEST (UID)
values ((select uuid_to_char(gen_uuid()) from RDB$DATABASE))
matching (UID);

works fine.

summary: Buildin function no longer supported in "update or insert" value list => Buildin function and subselect no longer supported in "update or insert" value list

assignee: Adriano dos Santos Fernandes [ asfernandes ]

summary: Buildin function and subselect no longer supported in "update or insert" value list => Regression: Built-in functions and subselect no longer supported in "update or insert" value list

Version: 3.0 Initial [ 10301 ]

Version: 3.0 Alpha 1 [ 10331 ] =>

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

status: Resolved [ 5 ] => Closed [ 6 ]

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully