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
SQL> set plan on;
SQL> select count(*)
CON> from horse
CON> join color on horse.code_color = color.code_color
CON> where http://horse.name = http://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 http://horse.name = http://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>
Submitted by: @sim1984
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 http://horse.name = http://color.name;
PLAN JOIN (COLOR NATURAL, HORSE INDEX (HORSE_IDX_NAME))
============
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 http://horse.name = http://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>
Commits: 7a7fd78 FirebirdSQL/fbt-repository@3b9b015
====== 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
The text was updated successfully, but these errors were encountered: