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
-- repeat this many times
update or insert into v values (1, 2);
After a few:
Statement failed, SQLSTATE = 54001
Dynamic SQL Error
-UPDATE OR INSERT without MATCHING could not be used with views based on more than one table
Submitted by: @asfernandes
Test case:
create table t1 (n1 integer);
create table t2 (n2 integer);
create view v as select * from t1, t2;
-- repeat this many times
update or insert into v values (1, 2);
After a few:
Statement failed, SQLSTATE = 54001
Dynamic SQL Error
-UPDATE OR INSERT without MATCHING could not be used with views based on more than one table
It starts raising:
Statement failed, SQLSTATE = 54001
unsuccessful metadata update
-request depth exceeded. (Recursive definition?)
Commits: 1ee74f5
The text was updated successfully, but these errors were encountered: