Issue Details (XML | Word | Printable)

Key: CORE-4038
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: John Kilin
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Broken optimization for the stored dbkeys

Created: 16/Jan/13 04:42 PM   Updated: 12/Jul/15 06:20 AM
Component/s: Engine
Affects Version/s: 3.0 Initial, 2.5.0, 2.5.1, 2.5.2
Fix Version/s: 3.0 Alpha 1, 2.5.3

Issue Links:
Relate
 

QA Status: Done successfully
Test Details: See also: CORE-4492, CORE-4530


 Description  « Hide
Test case:

create table t (dbkey char(8) character set octets);
create index it on t (dbkey);

select * from t as t1
  left join t as t2 on t2.dbkey = t1.rdb$db_key

-- expected plan:
PLAN JOIN (T1 NATURAL, T2 INDEX (IT))

-- actual plan:
PLAN JOIN (T1 NATURAL, T2 NATURAL)

This is a regression introduced with CORE-2550 when a separate internal datatype was created for dbkeys.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.