Server does not accept the right plan
-------------------------------------
Key: CORE-4539
URL: http://tracker.firebirdsql.org/browse/CORE-4539
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Beta 1
Environment: Windows 7 x64, ISQL
Reporter: Simonov Denis
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>
--
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
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
