The problem is related to GTTs ON COMMIT PRESERVE ROWS.
Steps to reproduce:
- Create GTT. For example:
create global temporary table temp_table(id bigint, str varchar(100)) on commit preserve rows;
- Insert some data in it.
- Drop it.
Repeat these steps many times, and the temp file will be constantly growing in size.
The problem is related to GTTs ON COMMIT PRESERVE ROWS.
Steps to reproduce:
create global temporary table temp_table(id bigint, str varchar(100)) on commit preserve rows;Repeat these steps many times, and the temp file will be constantly growing in size.