Updated on 2022-07-29 GMT+08:00

Temporary Tables

GaussDB(DWS) does not support GLOBAL TEMPORARY TABLE, and it will be migrated to LOCAL TEMPORARY TABLE.

ON COMMIT DELETE ROWS is also not supported, and will be migrated to ON COMMIT PRESERVE ROWS.

Figure 1 Input: TEMPORARY TABLE
Figure 2 Output: TEMPORARY TABLE