Sub-optimal predicate checking while selecting from a view
----------------------------------------------------------
Key: CORE-3981
URL: http://tracker.firebirdsql.org/browse/CORE-3981
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2, 2.5.1, 2.5.0
Reporter: Dmitry Yemanov
Test case:
(1) Select from a derived table
select * from (
select r.rdb$relation_name, abs(r.rdb$relation_id) as id
from rdb$relations r natural left join rdb$relation_fields rf
where rdb$relation_id < 128
)
where id = 0
-- 42 reads from RDB$RELATIONS / 4 reads from RDB$RELATION_FIELDS
(2) Select from a view
recreate view v
as
select r.rdb$relation_name, abs(r.rdb$relation_id) as id
from rdb$relations r natural left join rdb$relation_fields rf
where rdb$relation_id < 128;
select * from vvv
where id = 0
-- 42 reads from RDB$RELATIONS / 343 (!) reads from RDB$RELATION_FIELDS
--
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
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
