You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 http://a.id as id
from
temptable a;
/***
Runs fine
***/
recreate view tempview2
as
select http://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.
*******************************************************************************/
Submitted by: fabianobonin (fabianobonin)
Is related to QA225
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
http://a.id as id
from
temptable a;
/***
Runs fine
***/
recreate view tempview2
as
select
http://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.
*******************************************************************************/
Commits: a0f6677 905708b
The text was updated successfully, but these errors were encountered: