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
Assignees
Comments
Modified by: @dyemanovFix Version: 3.0 RC2 [ 10048 ] |
|
Commented by: @dyemanov I see that the check for subqueries was removed. Looks like a minor regression. |
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @dyemanovFix Version: 3.0.0 [ 10740 ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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: