Updated on 2023-12-01 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