Issue Details (XML | Word | Printable)

Key: CORE-2098
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: fabianobonin
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

View over global temporary table

Created: 30/Sep/08 02:20 PM   Updated: 26/Jan/09 08:29 AM
Component/s: Engine
Affects Version/s: 2.1.0, 2.5 Alpha 1, 2.1.1
Fix Version/s: 2.1.2, 2.5 Beta 1

Time Tracking:
Not Specified

Environment: FB 2.1.1 CS, Fedora Core 7
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
I´m facing an error when trying to create views over global temp
tables (is it allowed?).

I presume it is a bug. Tell me if i need to register:

FB 2.1.1 CS

create global temporary table temptable (
 id integer);

recreate view tempview1
as
select
 a.id as id
from
 temptable a;
/***
Runs fine
***/

recreate view tempview2
as
select
 a.id + 1 as id
from
 temptable a;
/*******************************************************************************
This operation is not defined for system tables.
unsuccessful metadata update.
persistent table "TEMPVIEW2" cannot depend on global temporary table
"TEMPTABLE" of type ON COMMIT DELETE ROWS.
*******************************************************************************/

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.