> In tracker case 4212, Vlad Khorsun wrote:
>
> It is documented since introducing GTT in v2.1 that constraints
> between temporary and permanent tables is forbidden. This
> requirement is per SQL standard.
>
> I want to be sure that this is correct (sorry Vlad), cus it seems wrong.
11.8 <referential constraint definition>
Syntax Rules
5) The referenced table shall be a base table.
Case:
a) If the referencing table is a persistent base table, then the referenced
table shall be a
persistent base table.
b) If the referencing table is a global temporary table, then the referenced
table shall be a
global temporary table.
...
6) If the referenced table is a temporary table with ON COMMIT DELETE ROWS
specified, then
the referencing table shall specify ON COMMIT DELETE ROWS.
> I can see that a permanent table should not be able to refer to a GTT, but
> the reverse (a GTT referencing a permanent table) seems
> entirely
> logical and desirable for data integrity purposes.
It is physically impossible to check detail data in all instances of detail
GTT when master
record is changed.
Regards,
Vlad
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
