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
---------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5130
URL: http://tracker.firebirdsql.org/browse/CORE-5130
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Initial
Reporter: 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
