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
Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL [CORE5130]
#5414
create or alter view v2 as select 1 id from rdb$database;
recreate table t1(id int, x int, y int);
commit;
alter view v1 as
select * from t1 a
where
not exists(select * from t1 r where r.x > a.x) ---------- yes, it's not allowed when using together with clause "with check option"
--a.x is not null
with check option
;
Submitted by: @pavel-zotov
create or alter view v2 as select 1 id from rdb$database;
recreate table t1(id int, x int, y int);
commit;
alter view v1 as
select * from t1 a
where
not exists(select * from t1 r where r.x > a.x) ---------- yes, it's not allowed when using together with clause "with check option"
--a.x is not null
with check option
;
Output in 2.5.6:
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -607
-Invalid command
-No subqueries permitted for VIEW WITH CHECK OPTION
(OK, expected)
Output in WI-V3.0.0.32375:
Statement failed, SQLSTATE = HY000
invalid request BLR at offset 79
-context already in use (BLR error)
The same in WI-V3.0.0.32366 Firebird 3.0 Release Candidate 2.
Commits: 152b6bd 0eef9d8 FirebirdSQL/fbt-repository@d7c76a4 FirebirdSQL/fbt-repository@cba41c2
The text was updated successfully, but these errors were encountered: