Issue Details (XML | Word | Printable)

Key: CORE-4118
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 1
Watchers: 2
Operations

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

Expression index may be not used for derived fields or view fields

Created: 15/Jun/13 06:07 PM   Updated: 12/Jul/15 06:01 AM
Component/s: Engine
Affects Version/s: 3.0 Initial, 2.5.0, 2.5.1, 2.5.2, 2.5.2 Update 1
Fix Version/s: 2.5.3, 3.0 Beta 1

Issue Links:
Relate
 

QA Status: Done successfully
Test Details: Confirmed on WI-V2.5.2.26540


 Description  « Hide
Test case:

create table t (id int, d timestamp);
create index itd on t computed (cast(d as date));

select * from t
where cast(d as date) = current_date
-- PLAN (T INDEX (ITD))

select * from (select id, cast(d as date) as d from t)
where d = current_date
-- PLAN (T NATURAL)
-- expected:
-- PLAN (T INDEX (ITD))


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov made changes - 15/Jun/13 06:07 PM
Field Original Value New Value
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 15/Jun/13 07:21 PM
Status Open [ 1 ] In Progress [ 3 ]
Dmitry Yemanov made changes - 29/Jun/13 01:47 PM
Fix Version/s 2.5.3 [ 10461 ]
Dmitry Yemanov made changes - 06/Jan/14 09:24 AM
Status In Progress [ 3 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 29/Mar/14 02:44 PM
Link This issue is related to QA-528 [ QA-528 ]
Philippe Makowski made changes - 10/Apr/14 01:44 PM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 12/Jul/15 06:01 AM
Status Closed [ 6 ] Closed [ 6 ]
Test Details Confirmed on WI-V2.5.2.26540
QA Status Done successfully