Closed
Description
Submitted by: tord (tord)
SFID: 452120#
Submitted By: tord
When you include an explicit plan in a CREATE VIEW
statement, the plan is silently ignored.
Demonstration:
<snip>
/*
* This sql-script tests for the viewplan-bug
*
* set ISC_USER and ISC_PASSWORD, then call
* isql -i viewplan.sql
*/
create database "viewplan.gdb";
create table a (
b integer not null
);
create index a_b on a(b);
create view view_a(b) as
select b
from a
where b < 2
plan (a natural);
commit;
set plan;
set echo;
select * from view_a;
select b from a where b < 2
plan (b natural);
commit;
drop database;
<snip>