Temporary Tables¶
GaussDB(DWS) does not support GLOBAL TEMPORARY TABLE, It migrates GLOBAL TEMPORARY TABLE to LOCAL TEMPORARY TABLE.
ON COMMIT DELETE ROWS is also not supported and will be migrated to ON COMMIT PRESERVE ROWS.
The following is an example of the syntax of a temporary table before and after migration.
Pre-migration¶
Figure 1 GLOBAL TEMPORARY TABLE and ON COMMIT DELETE ROWS¶
Post-migration¶
Figure 2 LOCAL TEMPORARY TABLE and ON COMMIT PRESERVE ROWS¶