Changeset: 9b375495355c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9b375495355c
Modified Files:
sql/backends/monet5/dict.c
sql/backends/monet5/for.c
sql/test/dict/Tests/dict01.test
Branch: Jan2022
Log Message:
At the moment, temporary tables cannot be compressed
diffs (36 lines):
diff --git a/sql/backends/monet5/dict.c b/sql/backends/monet5/dict.c
--- a/sql/backends/monet5/dict.c
+++ b/sql/backends/monet5/dict.c
@@ -233,6 +233,8 @@ DICTcompress_col(Client cntxt, MalBlkPtr
if (!isTable(t))
throw(SQL, "dict.compress", SQLSTATE(42000) "%s '%s' is not
persistent",
TABLE_TYPE_DESCRIPTION(t->type, t->properties),
t->base.name);
+ if (isTempTable(t))
+ throw(SQL, "dict.compress", SQLSTATE(42000) "columns from
temporary tables cannot be compressed");
if (t->system)
throw(SQL, "dict.compress", SQLSTATE(42000) "columns from
system tables cannot be compressed");
sql_column *c = find_sql_column(t, cname);
diff --git a/sql/backends/monet5/for.c b/sql/backends/monet5/for.c
--- a/sql/backends/monet5/for.c
+++ b/sql/backends/monet5/for.c
@@ -234,6 +234,8 @@ FORcompress_col(Client cntxt, MalBlkPtr
if (!isTable(t))
throw(SQL, "for.compress", SQLSTATE(42000) "%s '%s' is not
persistent",
TABLE_TYPE_DESCRIPTION(t->type, t->properties),
t->base.name);
+ if (isTempTable(t))
+ throw(SQL, "for.compress", SQLSTATE(42000) "columns from
temporary tables cannot be compressed");
if (t->system)
throw(SQL, "for.compress", SQLSTATE(42000) "columns from system
tables cannot be compressed");
sql_column *c = find_sql_column(t, cname);
diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/dict01.test
--- a/sql/test/dict/Tests/dict01.test
+++ b/sql/test/dict/Tests/dict01.test
@@ -727,7 +727,7 @@ 1
2
3
-statement ok
+statement error 42000!columns from temporary tables cannot be compressed
CALL "sys"."dict_compress"('tmp','t0','c0',false)
query I rowsort
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
