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
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 http://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 http://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 http://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 http://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 http://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 http://dt.name = rpad('', 0, '')
PLAN (DT RDB$RELATIONS NATURAL)
PLAN (DT RDB$PROCEDURES NATURAL)
Submitted by: @dyemanov
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 http://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 http://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 http://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 http://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 http://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 http://dt.name = rpad('', 0, '')
PLAN (DT RDB$RELATIONS NATURAL)
PLAN (DT RDB$PROCEDURES NATURAL)
The issue does not affect v3.0.
Commits: 480bd4c FirebirdSQL/fbt-repository@18ac373
The text was updated successfully, but these errors were encountered: