Changeset: 4308271d4ed3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/4308271d4ed3
Added Files:
sql/test/sysmon/Tests/test_vacuum.SQL.py
sql/test/sysmon/Tests/test_vacuum_mal.maltest
Removed Files:
sql/test/sysmon/Tests/test_vacuum.maltest
Modified Files:
sql/test/sysmon/Tests/All
Branch: strheapvacuum
Log Message:
add sql test
diffs (39 lines):
diff --git a/sql/test/sysmon/Tests/All b/sql/test/sysmon/Tests/All
--- a/sql/test/sysmon/Tests/All
+++ b/sql/test/sysmon/Tests/All
@@ -7,5 +7,6 @@ timeout_join
timeout_aggr
timeout_select
stop
+test_vacuum_mal
test_vacuum
diff --git a/sql/test/sysmon/Tests/test_vacuum.SQL.py
b/sql/test/sysmon/Tests/test_vacuum.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/sysmon/Tests/test_vacuum.SQL.py
@@ -0,0 +1,21 @@
+import sys
+from uuid import uuid4
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ tc.execute('drop table if exists foo;')
+ tc.execute("create table foo(a string);").assertSucceeded()
+ tc.execute('insert into foo values (\'hello\');').assertSucceeded()
+ for i in range(1000):
+ tc.execute(f"update foo set a='{str(uuid4())}';").assertSucceeded()
+ res = tc.execute("select heapsize from sys.storage('sys', 'foo',
'a');").assertSucceeded()
+ heap_large = int(res.data[0][0])
+ tc.execute("call sys.vacuum('sys', 'foo', 'a');").assertSucceeded()
+ res = tc.execute("select heapsize from sys.storage('sys', 'foo',
'a');").assertSucceeded()
+ heap_small = int(res.data[0][0])
+ assert(heap_small < heap_large)
+
+
+
+
+
diff --git a/sql/test/sysmon/Tests/test_vacuum.maltest
b/sql/test/sysmon/Tests/test_vacuum_mal.maltest
rename from sql/test/sysmon/Tests/test_vacuum.maltest
rename to sql/test/sysmon/Tests/test_vacuum_mal.maltest
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
