Expressions containing some built-in functions may be badly optimized
---------------------------------------------------------------------
Key: CORE-4460
URL: http://tracker.firebirdsql.org/browse/CORE-4460
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2, 2.1.5
Reporter: Dmitry Yemanov
Test cases for predicates distributed into the union sub-parts:
select * from (
select rdb$relation_name from rdb$relations
union
select rdb$procedure_name from rdb$procedures
) as dt (name) where dt.name = ''
PLAN (DT RDB$RELATIONS INDEX (RDB$INDEX_0))
PLAN (DT RDB$PROCEDURES INDEX (RDB$INDEX_21))
select * from (
select rdb$relation_name from rdb$relations
union
select rdb$procedure_name from rdb$procedures
) as dt (name) where dt.name = upper('')
PLAN (DT RDB$RELATIONS INDEX (RDB$INDEX_0))
PLAN (DT RDB$PROCEDURES INDEX (RDB$INDEX_21))
select * from (
select rdb$relation_name from rdb$relations
union
select rdb$procedure_name from rdb$procedures
) as dt (name) where dt.name = trim('')
PLAN (DT RDB$RELATIONS INDEX (RDB$INDEX_0))
PLAN (DT RDB$PROCEDURES INDEX (RDB$INDEX_21))
select * from (
select rdb$relation_name from rdb$relations
union
select rdb$procedure_name from rdb$procedures
) as dt (name) where dt.name = left('', 0)
PLAN (DT RDB$RELATIONS NATURAL)
PLAN (DT RDB$PROCEDURES NATURAL)
select * from (
select rdb$relation_name from rdb$relations
union
select rdb$procedure_name from rdb$procedures
) as dt (name) where dt.name = minvalue('', '')
PLAN (DT RDB$RELATIONS NATURAL)
PLAN (DT RDB$PROCEDURES NATURAL)
select * from (
select rdb$relation_name from rdb$relations
union
select rdb$procedure_name from rdb$procedures
) as dt (name) where dt.name = rpad('', 0, '')
PLAN (DT RDB$RELATIONS NATURAL)
PLAN (DT RDB$PROCEDURES NATURAL)
The issue does not affect v3.0.
--
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
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
