Version: 2.1 Alpha 1 [ 10150 ]

description: Indi?es using completely broken for views

CREATE TABLE "TABLE" (ID INTEGER NOT NULL PRIMARY KEY);

COMMIT;

INSERT INTO "TABLE" (ID) VALUES (1);
INSERT INTO "TABLE" (ID) VALUES (2);
INSERT INTO "TABLE" (ID) VALUES (3);

COMMIT;

CREATE VIEW "VIEW" AS SELECT * FROM "TABLE";

Now test query:

SELECT * FROM "TABLE" WHERE ID = 1
UNION ALL
SELECT * FROM "VIEW" WHERE ID = 1

Plan for table: PLAN (TABLE INDEX (PK_TABLE))

Plan for view: PLAN (VIEW TABLE NATURAL)

=>

Indices using completely broken for views

CREATE TABLE "TABLE" (ID INTEGER NOT NULL PRIMARY KEY);

COMMIT;

INSERT INTO "TABLE" (ID) VALUES (1);
INSERT INTO "TABLE" (ID) VALUES (2);
INSERT INTO "TABLE" (ID) VALUES (3);

COMMIT;

CREATE VIEW "VIEW" AS SELECT * FROM "TABLE";

Now test query:

SELECT * FROM "TABLE" WHERE ID = 1
UNION ALL
SELECT * FROM "VIEW" WHERE ID = 1

Plan for table: PLAN (TABLE INDEX (PK_TABLE))

Plan for view: PLAN (VIEW TABLE NATURAL)

summary: Indi?es not used for views => Indices not used for views

Link: This issue is related to CORE1245 [ CORE1245 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 Beta 1 [ 10141 ]

Link: This issue is related to QA140 [ QA140 ]

status: Resolved [ 5 ] => Closed [ 6 ]

Workflow: jira [ 12279 ] => Firebird [ 14713 ]

QA Status: No test

QA Status: No test => Done successfully