1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
# name: test/sql/table_function/duckdb_memory.test_slow
# group: [table_function]
require vector_size 2048
statement ok
set memory_limit='20mb';
statement ok
set max_temp_directory_size='150MiB';
loop i 0 5
statement ok
drop table if exists tmp1;
statement ok
create or replace temp table tmp1 as select * from range(15_000_000);
# i
endloop
# These should both report only 140mb is used
query I
select sum(temporary_storage_bytes) < 150_000_000 from duckdb_memory() where tag = 'IN_MEMORY_TABLE';
----
true
query I
select sum(size) < 150_000_000 FROM duckdb_temporary_files();
----
true
|
