[Firebird-devel] BUG? Specifying PLAN in SELECT crashes server

[<dh...@le...>]

Hi,

I'm using Firebird 1.5 RC5, and trying to specify the PLAN to use when I do
a query.

I have a table called Metrics, with a primary key of Id.

If I do "set plan;" and then "SELECT * FROM METRICS WHERE ID=2" I see, as
expected that it is using the primary key:

      PLAN (METRICS INDEX (RDB$PRIMARY5))

When I try and specify the plan, however, apparently when the SELECT
statement does not have a WHERE clause, the Firebird Server crashes!

To test this, I trying the following:

      SELECT * FROM METRICS WHERE ID=2 PLAN (METRICS INDEX (RDB$PRIMARY5));

and everything worked fine.

However, if I do

      SELECT * FROM METRICS PLAN (METRICS INDEX (RDB$PRIMARY5));
or
      SELECT MIN(Id) FROM METRICS PLAN (METRICS INDEX (RDB$PRIMARY5));

the server crashes, and isql shows

      Statement failed, SQLCODE = -901

      connection lost to database

Am I doing something wrong here (quite possible!) or is this a bug.

Cheers,

David