Subject | FB 2.1: GTT explanation |
---|---|
Author | Tetram Corp |
Post date | 2008-04-21T10:26:55Z |
Hi,
I'm reading release notes, and I saw this about GTT:
"references between persistent and temporary tables are forbidden"
So it isn't possible to do something like this? if yes, is it possible
to know the reason?
create table t1 (
field integer unique
);
create global temporary table gtt (
field integer references t1(field)
);
or is there only a restriction about static tables referencing temporary?
I'm reading release notes, and I saw this about GTT:
"references between persistent and temporary tables are forbidden"
So it isn't possible to do something like this? if yes, is it possible
to know the reason?
create table t1 (
field integer unique
);
create global temporary table gtt (
field integer references t1(field)
);
or is there only a restriction about static tables referencing temporary?