Issue Details (XML | Word | Printable)

Key: CORE-4539
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Simonov Denis
Votes: 0
Watchers: 4
Operations

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

Server does not accept the right plan

Created: 04/Sep/14 11:53 AM   Updated: 28/May/15 03:12 PM
Component/s: None
Affects Version/s: 3.0 Beta 1
Fix Version/s: 3.0 Beta 2

Environment: Windows 7 x64, ISQL

QA Status: Done successfully
Test Details:
Confirmed on WI-T3.0.0.31374 Firebird 3.0 Beta 1
Statement failed, SQLSTATE = 42000
index <...> cannot be used in the specified plan


 Description  « Hide
Server does not accept the right plan

SQL> set plan on;
SQL> select count(*)
CON> from horse
CON> join color on horse.code_color = color.code_color
CON> where horse.name = color.name;

PLAN JOIN (COLOR NATURAL, HORSE INDEX (HORSE_IDX_NAME))

       COUNT
============
          48

add up plan in the previous query

SQL> select count(*)
CON> from horse
CON> join color on horse.code_color = color.code_color
CON> where horse.name = color.name
CON> PLAN JOIN (COLOR NATURAL, HORSE INDEX (HORSE_IDX_NAME));
Statement failed, SQLSTATE = 42000
index HORSE_IDX_NAME cannot be used in the specified plan
SQL>

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