|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
FB 2.1.1 CS, Fedora Core 7
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
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.
*******************************************************************************/
|
|
Description
|
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.
*******************************************************************************/ |
Show » |
| The cvs commits can not be displayed for repository Firebird at the moment since the log has not yet been parsed. The log will be parsed the next time the VcsService runs. If you have administrators privileges you can hasten the next time the service will run in the service section of the Administration pages.
|
|
Bug
View over global temporary table
