Changeset: 33c934b82ca0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=33c934b82ca0
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
sql/test/Dependencies/Tests/Dependencies.stable.out
sql/test/Dependencies/Tests/Dependencies.stable.out.int128
sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: mosaic
Log Message:
Approve outputs
diffs (truncated from 375 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -64,7 +64,7 @@ stdout of test 'MAL-signatures` in direc
% .L1, .L1, .L1, .L1, .L1 # table_name
% module, function, signature, address, comment # name
% clob, clob, clob, clob, clob # type
-% 11, 28, 364, 38, 874 # length
+% 11, 28, 386, 38, 874 # length
[ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1],
r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not
equal to l return true, else if r has nil nil else false" ]
[ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1],
r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l
return true, else if r has nil nil else false" ]
[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
bte" ]
@@ -11378,13 +11378,9 @@ stdout of test 'MAL-signatures` in direc
[ "mmath", "tan", "command mmath.tan(x:flt):flt ",
"MATHunary_TANflt;", "" ]
[ "mmath", "tanh", "command mmath.tanh(x:dbl):dbl ",
"MATHunary_TANHdbl;", "The tanh() function returns the hyperbolic tangent of
x, which is \n\tdefined mathematically as sinh(x) / cosh(x)." ]
[ "mmath", "tanh", "command mmath.tanh(x:flt):flt ",
"MATHunary_TANHflt;", "" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse():void ",
"MOSanalyse;", "Apply heap compression on all" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse(b:int):void ",
"MOSanalyse;", "Apply default heap compression on a specific column" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse(properties:str):void ",
"MOSanalyse;", "Apply heap compression on all with minimum threshold" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse(properties:str,
b:int):void ", "MOSanalyse;", "Apply heap compression on a single column"
]
[ "mosaic", "compress", "pattern
mosaic.compress(b:bat[:any_1]):bat[:any_1] ", "MOScompress;", "Apply dynamic
compression producing a temporary" ]
[ "mosaic", "compress", "pattern mosaic.compress(b:bat[:any_1],
prop:str):bat[:any_1] ", "MOScompress;", "Apply dynamic compression over
chunks" ]
-[ "mosaic", "decompress", "pattern
mosaic.decompress(b:bat[:any_1]):bat[:any_1] ", "MOSdecompress;",
"Apply dynamic decompression over chunks producing a temporary version" ]
+[ "mosaic", "decompress", "command
mosaic.decompress(b:bat[:any_1]):bat[:any_1] ", "MOSdecompress;",
"Apply dynamic decompression over chunks producing a temporary version" ]
[ "mosaic", "join", "pattern mosaic.join(l:bat[:any_1], r:bat[:any_1],
sl:bat[:oid], sr:bat[:oid], nil_matches:bit, estimate:lng) (X_0:bat[:oid],
X_1:bat[:oid]) ", "MOSjoin;", "Overloaded join operation" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:bit]):bat[:bit] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:bte]):bat[:bte] ", "MOSprojection;", "" ]
@@ -11392,7 +11388,6 @@ stdout of test 'MAL-signatures` in direc
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:daytime]):bat[:daytime] ", "MOSprojection;", "Overloaded
projection operation" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:dbl]):bat[:dbl] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:flt]):bat[:flt] ", "MOSprojection;", "" ]
-[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:hge]):bat[:hge] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:int]):bat[:int] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:lng]):bat[:lng] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:oid]):bat[:oid] ", "MOSprojection;", "" ]
@@ -11448,8 +11443,6 @@ stdout of test 'MAL-signatures` in direc
[ "mosaic", "thetaselect", "pattern mosaic.thetaselect(b:bat[:str],
low:str, oper:str):bat[:oid] ", "MOSthetaselect;", "" ]
[ "mosaic", "thetaselect", "pattern mosaic.thetaselect(b:bat[:timestamp],
c:bat[:oid], low:timestamp, oper:str):bat[:oid] ", "MOSthetaselect;",
"Overloaded selection routine" ]
[ "mosaic", "thetaselect", "pattern mosaic.thetaselect(b:bat[:timestamp],
low:timestamp, oper:str):bat[:oid] ", "MOSthetaselect;", "Overloaded
selection routine" ]
-[ "mtime", "add", "command mtime.add(v:timestamp, msecs:lng):timestamp ",
"MTIMEtimestamp_add;", "returns the timestamp that comes 'msecs'\n\t(possibly
negative) after 'value'." ]
-[ "mtime", "adddays", "command mtime.adddays(value:date,
days:int):date ", "MTIMEdate_adddays;", "returns the date after a
number\n\tof days (possibly negative)." ]
[ "mtime", "addmonths", "command mtime.addmonths(value:date,
months:int):date ", "MTIMEdate_addmonths;", "returns the date after a
number of\n\tmonths (possibly negative)." ]
[ "mtime", "century", "command mtime.century(d:date):int ",
"MTIMEdate_extract_century;", "extracts century from date." ]
[ "mtime", "century", "command mtime.century(t:timestamp):int ",
"MTIMEtimestamp_century;", "" ]
@@ -11555,6 +11548,7 @@ stdout of test 'MAL-signatures` in direc
[ "optimizer", "mitosis", "pattern optimizer.mitosis(mod:str,
fcn:str):str ", "OPTwrapper;", "Modify the plan to exploit parallel
processing on multiple cores" ]
[ "optimizer", "mosaic", "pattern optimizer.mosaic():str ",
"OPTwrapper;", "" ]
[ "optimizer", "mosaic", "pattern optimizer.mosaic(mod:str, fcn:str):str
", "OPTwrapper;", "Modify the plan to exploit compressed storage" ]
+[ "optimizer", "mosaic_pipe", "function optimizer.mosaic_pipe():void;",
"", "" ]
[ "optimizer", "multiplex", "pattern optimizer.multiplex():void ",
"OPTwrapper;", "Compiler for multiplexed instructions." ]
[ "optimizer", "multiplex", "pattern optimizer.multiplex(mod:str,
fcn:str):void ", "OPTwrapper;", "Compiler for multiplexed instructions."
]
[ "optimizer", "no_mitosis_pipe", "function
optimizer.no_mitosis_pipe():void;", "", "" ]
@@ -11778,6 +11772,9 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "logfile", "unsafe pattern sql.logfile(filename:str):void
", "mvc_logfile;", "Enable/disable saving the sql statement traces"
]
[ "sql", "max", "pattern sql.max(b:any_1, s:lng, e:lng):any_1 ",
"SQLmax;", "return the maximum of groups" ]
[ "sql", "min", "pattern sql.min(b:any_1, s:lng, e:lng):any_1 ",
"SQLmin;", "return the minimum of groups" ]
+[ "sql", "mosaicanalysis", "pattern sql.mosaicanalysis(sch:str,
tbl:str, col:str) (technique:bat[:str], outputsize:bat[:lng], factor:bat[:dbl],
compress:bat[:lng], decompress:bat[:lng]) ", "sql_mosaicAnalysis;",
"Return a table with compression opportunities for the column" ]
+[ "sql", "mosaicanalysis", "pattern sql.mosaicanalysis(sch:str,
tbl:str, col:str, compression:str) (technique:bat[:str], outputsize:bat[:lng],
factor:bat[:dbl], compress:bat[:lng], decompress:bat[:lng]) ",
"sql_mosaicAnalysis;", "" ]
+[ "sql", "mosaiclayout", "pattern sql.mosaiclayout(sch:str, tbl:str,
col:str) (technique:bat[:str], count:bat[:lng], inputsize:bat[:lng],
outputsize:bat[:lng], properties:bat[:str]) ", "sql_mosaicLayout;", "Return
a table with detailed compression information " ]
[ "sql", "ms_trunc", "command sql.ms_trunc(v:dbl, r:int):dbl ",
"dbl_trunc_wrap;", "truncate the floating point v to r digits behind the
dot (if r < 0, before the dot)" ]
[ "sql", "ms_trunc", "command sql.ms_trunc(v:flt, r:int):flt ",
"flt_trunc_wrap;", "truncate the floating point v to r digits behind the
dot (if r < 0, before the dot)" ]
[ "sql", "mvc", "pattern sql.mvc():int ", "SQLmvc;", "Get
the multiversion catalog context. \nNeeded for correct statement
dependencies\n(ie sql.update, should be after sql.bind in concurrent
execution)" ]
@@ -11837,10 +11834,10 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "single", "pattern sql.single(x:any_2):bat[:any_2] ",
"CMDBATsingle;", "" ]
[ "sql", "sql_environment", "inline function sql.sql_environment()
(name:bat[:str], value:bat[:str]);", "", "" ]
[ "sql", "sql_variables", "pattern sql.sql_variables():bat[:str]
", "sql_variables;", "return the table with session variables"
]
-[ "sql", "storage", "pattern sql.storage() (schema:bat[:str],
table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str],
location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng],
heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng],
sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ",
"sql_storage;", "return a table with storage information " ]
-[ "sql", "storage", "pattern sql.storage(sname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular schema " ]
-[ "sql", "storage", "pattern sql.storage(sname:str, tname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular table" ]
-[ "sql", "storage", "pattern sql.storage(sname:str, tname:str,
cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str],
type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng],
atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng],
phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit],
key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with
storage information for a particular column" ]
+[ "sql", "storage", "pattern sql.storage() (schema:bat[:str],
table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str],
location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng],
heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng],
sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng],
compressed:bat[:bit]) ", "sql_storage;", "return a table with storage
information " ]
+[ "sql", "storage", "pattern sql.storage(sname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng], compressed:bat[:bit]) ", "sql_storage;", "return a table
with storage information for a particular schema " ]
+[ "sql", "storage", "pattern sql.storage(sname:str, tname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng], compressed:bat[:bit]) ", "sql_storage;", "return a
table with storage information for a particular table" ]
+[ "sql", "storage", "pattern sql.storage(sname:str, tname:str,
cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str],
type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng],
atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng],
phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit],
key:bat[:bit], orderidx:bat[:lng], compressed:bat[:bit]) ", "sql_storage;",
"return a table with storage information for a particular column" ]
[ "sql", "suball", "command sql.suball(l:bat[:any_1],
gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1] ", "SQLall_grp;",
"if all values in l are equal (per group) return the value, else nil" ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ",
"DELTAsub2;", "Return a single bat of selected delta." ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ",
"DELTAsub;", "Return a single bat of selected delta." ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -68,7 +68,7 @@ stdout of test 'MAL-signatures` in direc
% .L1, .L1, .L1, .L1, .L1 # table_name
% module, function, signature, address, comment # name
% clob, clob, clob, clob, clob # type
-% 11, 28, 364, 38, 874 # length
+% 11, 28, 386, 38, 874 # length
[ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1],
r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not
equal to l return true, else if r has nil nil else false" ]
[ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1],
r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l
return true, else if r has nil nil else false" ]
[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
bte" ]
@@ -15782,13 +15782,9 @@ stdout of test 'MAL-signatures` in direc
[ "mmath", "tan", "command mmath.tan(x:flt):flt ",
"MATHunary_TANflt;", "" ]
[ "mmath", "tanh", "command mmath.tanh(x:dbl):dbl ",
"MATHunary_TANHdbl;", "The tanh() function returns the hyperbolic tangent of
x, which is \n\tdefined mathematically as sinh(x) / cosh(x)." ]
[ "mmath", "tanh", "command mmath.tanh(x:flt):flt ",
"MATHunary_TANHflt;", "" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse():void ",
"MOSanalyse;", "Apply heap compression on all" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse(b:int):void ",
"MOSanalyse;", "Apply default heap compression on a specific column" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse(properties:str):void ",
"MOSanalyse;", "Apply heap compression on all with minimum threshold" ]
-[ "mosaic", "analyse", "pattern mosaic.analyse(properties:str,
b:int):void ", "MOSanalyse;", "Apply heap compression on a single column"
]
[ "mosaic", "compress", "pattern
mosaic.compress(b:bat[:any_1]):bat[:any_1] ", "MOScompress;", "Apply dynamic
compression producing a temporary" ]
[ "mosaic", "compress", "pattern mosaic.compress(b:bat[:any_1],
prop:str):bat[:any_1] ", "MOScompress;", "Apply dynamic compression over
chunks" ]
-[ "mosaic", "decompress", "pattern
mosaic.decompress(b:bat[:any_1]):bat[:any_1] ", "MOSdecompress;",
"Apply dynamic decompression over chunks producing a temporary version" ]
+[ "mosaic", "decompress", "command
mosaic.decompress(b:bat[:any_1]):bat[:any_1] ", "MOSdecompress;",
"Apply dynamic decompression over chunks producing a temporary version" ]
[ "mosaic", "join", "pattern mosaic.join(l:bat[:any_1], r:bat[:any_1],
sl:bat[:oid], sr:bat[:oid], nil_matches:bit, estimate:lng) (X_0:bat[:oid],
X_1:bat[:oid]) ", "MOSjoin;", "Overloaded join operation" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:bit]):bat[:bit] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:bte]):bat[:bte] ", "MOSprojection;", "" ]
@@ -15796,7 +15792,6 @@ stdout of test 'MAL-signatures` in direc
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:daytime]):bat[:daytime] ", "MOSprojection;", "Overloaded
projection operation" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:dbl]):bat[:dbl] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:flt]):bat[:flt] ", "MOSprojection;", "" ]
-[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:hge]):bat[:hge] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:int]):bat[:int] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:lng]):bat[:lng] ", "MOSprojection;", "" ]
[ "mosaic", "projection", "pattern mosaic.projection(b:bat[:oid],
cand:bat[:oid]):bat[:oid] ", "MOSprojection;", "" ]
@@ -15852,8 +15847,6 @@ stdout of test 'MAL-signatures` in direc
[ "mosaic", "thetaselect", "pattern mosaic.thetaselect(b:bat[:str],
low:str, oper:str):bat[:oid] ", "MOSthetaselect;", "" ]
[ "mosaic", "thetaselect", "pattern mosaic.thetaselect(b:bat[:timestamp],
c:bat[:oid], low:timestamp, oper:str):bat[:oid] ", "MOSthetaselect;",
"Overloaded selection routine" ]
[ "mosaic", "thetaselect", "pattern mosaic.thetaselect(b:bat[:timestamp],
low:timestamp, oper:str):bat[:oid] ", "MOSthetaselect;", "Overloaded
selection routine" ]
-[ "mtime", "add", "command mtime.add(v:timestamp, msecs:lng):timestamp ",
"MTIMEtimestamp_add;", "returns the timestamp that comes 'msecs'\n\t(possibly
negative) after 'value'." ]
-[ "mtime", "adddays", "command mtime.adddays(value:date,
days:int):date ", "MTIMEdate_adddays;", "returns the date after a
number\n\tof days (possibly negative)." ]
[ "mtime", "addmonths", "command mtime.addmonths(value:date,
months:int):date ", "MTIMEdate_addmonths;", "returns the date after a
number of\n\tmonths (possibly negative)." ]
[ "mtime", "century", "command mtime.century(d:date):int ",
"MTIMEdate_extract_century;", "extracts century from date." ]
[ "mtime", "century", "command mtime.century(t:timestamp):int ",
"MTIMEtimestamp_century;", "" ]
@@ -15959,6 +15952,7 @@ stdout of test 'MAL-signatures` in direc
[ "optimizer", "mitosis", "pattern optimizer.mitosis(mod:str,
fcn:str):str ", "OPTwrapper;", "Modify the plan to exploit parallel
processing on multiple cores" ]
[ "optimizer", "mosaic", "pattern optimizer.mosaic():str ",
"OPTwrapper;", "" ]
[ "optimizer", "mosaic", "pattern optimizer.mosaic(mod:str, fcn:str):str
", "OPTwrapper;", "Modify the plan to exploit compressed storage" ]
+[ "optimizer", "mosaic_pipe", "function optimizer.mosaic_pipe():void;",
"", "" ]
[ "optimizer", "multiplex", "pattern optimizer.multiplex():void ",
"OPTwrapper;", "Compiler for multiplexed instructions." ]
[ "optimizer", "multiplex", "pattern optimizer.multiplex(mod:str,
fcn:str):void ", "OPTwrapper;", "Compiler for multiplexed instructions."
]
[ "optimizer", "no_mitosis_pipe", "function
optimizer.no_mitosis_pipe():void;", "", "" ]
@@ -16184,6 +16178,9 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "logfile", "unsafe pattern sql.logfile(filename:str):void
", "mvc_logfile;", "Enable/disable saving the sql statement traces"
]
[ "sql", "max", "pattern sql.max(b:any_1, s:lng, e:lng):any_1 ",
"SQLmax;", "return the maximum of groups" ]
[ "sql", "min", "pattern sql.min(b:any_1, s:lng, e:lng):any_1 ",
"SQLmin;", "return the minimum of groups" ]
+[ "sql", "mosaicanalysis", "pattern sql.mosaicanalysis(sch:str,
tbl:str, col:str) (technique:bat[:str], outputsize:bat[:lng], factor:bat[:dbl],
compress:bat[:lng], decompress:bat[:lng]) ", "sql_mosaicAnalysis;",
"Return a table with compression opportunities for the column" ]
+[ "sql", "mosaicanalysis", "pattern sql.mosaicanalysis(sch:str,
tbl:str, col:str, compression:str) (technique:bat[:str], outputsize:bat[:lng],
factor:bat[:dbl], compress:bat[:lng], decompress:bat[:lng]) ",
"sql_mosaicAnalysis;", "" ]
+[ "sql", "mosaiclayout", "pattern sql.mosaiclayout(sch:str, tbl:str,
col:str) (technique:bat[:str], count:bat[:lng], inputsize:bat[:lng],
outputsize:bat[:lng], properties:bat[:str]) ", "sql_mosaicLayout;", "Return
a table with detailed compression information " ]
[ "sql", "ms_trunc", "command sql.ms_trunc(v:dbl, r:int):dbl ",
"dbl_trunc_wrap;", "truncate the floating point v to r digits behind the
dot (if r < 0, before the dot)" ]
[ "sql", "ms_trunc", "command sql.ms_trunc(v:flt, r:int):flt ",
"flt_trunc_wrap;", "truncate the floating point v to r digits behind the
dot (if r < 0, before the dot)" ]
[ "sql", "mvc", "pattern sql.mvc():int ", "SQLmvc;", "Get
the multiversion catalog context. \nNeeded for correct statement
dependencies\n(ie sql.update, should be after sql.bind in concurrent
execution)" ]
@@ -16249,10 +16246,10 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "single", "pattern sql.single(x:any_2):bat[:any_2] ",
"CMDBATsingle;", "" ]
[ "sql", "sql_environment", "inline function sql.sql_environment()
(name:bat[:str], value:bat[:str]);", "", "" ]
[ "sql", "sql_variables", "pattern sql.sql_variables():bat[:str]
", "sql_variables;", "return the table with session variables"
]
-[ "sql", "storage", "pattern sql.storage() (schema:bat[:str],
table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str],
location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng],
heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng],
sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ",
"sql_storage;", "return a table with storage information " ]
-[ "sql", "storage", "pattern sql.storage(sname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular schema " ]
-[ "sql", "storage", "pattern sql.storage(sname:str, tname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular table" ]
-[ "sql", "storage", "pattern sql.storage(sname:str, tname:str,
cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str],
type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng],
atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng],
phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit],
key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with
storage information for a particular column" ]
+[ "sql", "storage", "pattern sql.storage() (schema:bat[:str],
table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str],
location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng],
heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng],
sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng],
compressed:bat[:bit]) ", "sql_storage;", "return a table with storage
information " ]
+[ "sql", "storage", "pattern sql.storage(sname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng], compressed:bat[:bit]) ", "sql_storage;", "return a table
with storage information for a particular schema " ]
+[ "sql", "storage", "pattern sql.storage(sname:str, tname:str)
(schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str],
mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int],
columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit],
imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit],
orderidx:bat[:lng], compressed:bat[:bit]) ", "sql_storage;", "return a
table with storage information for a particular table" ]
+[ "sql", "storage", "pattern sql.storage(sname:str, tname:str,
cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str],
type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng],
atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng],
phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit],
key:bat[:bit], orderidx:bat[:lng], compressed:bat[:bit]) ", "sql_storage;",
"return a table with storage information for a particular column" ]
[ "sql", "suball", "command sql.suball(l:bat[:any_1],
gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1] ", "SQLall_grp;",
"if all values in l are equal (per group) return the value, else nil" ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ",
"DELTAsub2;", "Return a single bat of selected delta." ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ",
"DELTAsub;", "Return a single bat of selected delta." ]
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -1513,7 +1513,7 @@ void MOSadvance_var(MOStask task);
void MOSblk(MosaicBlk blk);
str MOScompress(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
str MOScompressInternal(BAT *bsrc, const char *compressions);
-void MOScompress_capped(MOStask task);
+void MOScompress_capped(MOStask task, MosaicBlkRec *estimate);
void MOScompress_delta(MOStask task);
void MOScompress_frame(MOStask task);
void MOScompress_linear(MOStask task);
diff --git
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
---
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
+++
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
@@ -35,9 +35,9 @@ stdout of test 'table_functions_fail_aft
[ "tmp" ]
[ "json" ]
[ "profiler" ]
-[ "mosaic" ]
[ "wlc" ]
[ "wlr" ]
+[ "mosaic" ]
[ "bam" ]
[ "ft" ]
diff --git
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
---
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
+++
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
@@ -31,9 +31,9 @@ stdout of test 'table_functions_fail_aft
[ "tmp" ]
[ "json" ]
[ "profiler" ]
-[ "mosaic" ]
[ "wlc" ]
[ "wlr" ]
+[ "mosaic" ]
[ "bam" ]
[ "ft" ]
#drop function ft.func;
diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out
b/sql/test/Dependencies/Tests/Dependencies.stable.out
--- a/sql/test/Dependencies/Tests/Dependencies.stable.out
+++ b/sql/test/Dependencies/Tests/Dependencies.stable.out
@@ -345,6 +345,7 @@ Cleanup
% 7, 8, 10 # length
[ "monetdb", "bam", "DEP_SCHEMA" ]
[ "monetdb", "json", "DEP_SCHEMA" ]
+[ "monetdb", "mosaic", "DEP_SCHEMA" ]
[ "monetdb", "profiler", "DEP_SCHEMA" ]
[ "monetdb", "sys", "DEP_SCHEMA" ]
[ "monetdb", "tmp", "DEP_SCHEMA" ]
diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out.int128
b/sql/test/Dependencies/Tests/Dependencies.stable.out.int128
--- a/sql/test/Dependencies/Tests/Dependencies.stable.out.int128
+++ b/sql/test/Dependencies/Tests/Dependencies.stable.out.int128
@@ -88,6 +88,7 @@ Dependencies between database objects
% 7, 8, 10 # length
[ "monetdb", "bam", "DEP_SCHEMA" ]
[ "monetdb", "json", "DEP_SCHEMA" ]
+[ "monetdb", "mosaic", "DEP_SCHEMA" ]
[ "monetdb", "profiler", "DEP_SCHEMA" ]
[ "monetdb", "sys", "DEP_SCHEMA" ]
[ "monetdb", "test", "DEP_SCHEMA" ]
@@ -344,9 +345,9 @@ Cleanup
% 7, 8, 10 # length
[ "monetdb", "bam", "DEP_SCHEMA" ]
[ "monetdb", "json", "DEP_SCHEMA" ]
+[ "monetdb", "mosaic", "DEP_SCHEMA" ]
[ "monetdb", "profiler", "DEP_SCHEMA" ]
[ "monetdb", "sys", "DEP_SCHEMA" ]
-[ "monetdb", "mosaic", "DEP_SCHEMA" ]
[ "monetdb", "tmp", "DEP_SCHEMA" ]
[ "monetdb", "wlc", "DEP_SCHEMA" ]
[ "monetdb", "wlr", "DEP_SCHEMA" ]
diff --git
a/sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
b/sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
--- a/sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
+++ b/sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
@@ -38,9 +38,9 @@ stdout of test 'groupby_having_charlengt
[ "tmp", 3, 10 ]
[ "json", 4, 10 ]
[ "profiler", 8, 10 ]
-[ "mosaic", 6, 10 ]
[ "wlc", 3, 10 ]
[ "wlr", 3, 10 ]
+[ "mosaic", 6, 10 ]
[ "bam", 3, 10 ]
# 12:48:35 >
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -762,6 +762,7 @@ stdout of test 'systemfunctions` in dire
[ "sys", "host", 1, "inet", "" ]
[ "sys", "hostmask", 0, "inet", "create function \"hostmask\"
(p inet) returns inet\n external name inet.\"hostmask\";" ]
[ "sys", "hostmask", 1, "inet", "" ]
+[ "sys", "hot_snapshot", 0, "clob", "create procedure
hot_snapshot(tarfile string)\n external name sql.hot_snapshot;" ]
[ "sys", "hour", 0, "int", "hours" ]
[ "sys", "hour", 1, "time", "" ]
[ "sys", "hour", 0, "int", "hours" ]
@@ -4398,7 +4399,7 @@ stdout of test 'systemfunctions` in dire
[ "sys", "stddev_samp", 1, "timestamp", "" ]
[ "sys", "stop", 0, "int", "create procedure sys.stop(tag
int)\nexternal name sql.sysmon_stop;" ]
[ "sys", "stop", 0, "bigint", "create procedure sys.stop(tag
bigint)\nexternal name sql.sysmon_stop;" ]
-[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"()\nreturns table (\n \"schema\" varchar(1024),\n \"table\"
varchar(1024),\n \"column\" varchar(1024), \n \"type\" varchar(1024),\n
\"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth
int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash
boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n
\"unique\" boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ]
+[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"()\nreturns table (\n \"schema\" varchar(1024),\n \"table\"
varchar(1024),\n \"column\" varchar(1024), \n \"type\" varchar(1024),\n
\"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth
int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash
boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n
\"unique\" boolean,\n orderidx bigint,\n compressed boolean\n)\nexternal name
sql.\"storage\";" ]
[ "sys", "storage", 1, "varchar", "" ]
[ "sys", "storage", 2, "varchar", "" ]
[ "sys", "storage", 3, "varchar", "" ]
@@ -4415,7 +4416,8 @@ stdout of test 'systemfunctions` in dire
[ "sys", "storage", 14, "boolean", "" ]
[ "sys", "storage", 15, "boolean", "" ]
[ "sys", "storage", 16, "bigint", "" ]
-[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"(sname varchar(1024))\nreturns table (\n \"schema\"
varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n
\"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n
\"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n
hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n
revsorted boolean,\n \"unique\" boolean,\n orderidx bigint\n)\nexternal name
sql.\"storage\";" ]
+[ "sys", "storage", 17, "boolean", "" ]
+[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"(sname varchar(1024))\nreturns table (\n \"schema\"
varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n
\"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n
\"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n
hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n
revsorted boolean,\n \"unique\" boolean,\n orderidx bigint,\n compressed
boolean\n)\nexternal name sql.\"storage\";" ]
[ "sys", "storage", 1, "varchar", "" ]
[ "sys", "storage", 2, "varchar", "" ]
[ "sys", "storage", 3, "varchar", "" ]
@@ -4432,8 +4434,9 @@ stdout of test 'systemfunctions` in dire
[ "sys", "storage", 14, "boolean", "" ]
[ "sys", "storage", 15, "boolean", "" ]
[ "sys", "storage", 16, "bigint", "" ]
-[ "sys", "storage", 17, "varchar", "" ]
-[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"(sname varchar(1024), tname varchar(1024))\nreturns table (\n
\"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\"
varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location
varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n
heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n
sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx
bigint\n)\nexternal name sql.\"storage\";" ]
+[ "sys", "storage", 17, "boolean", "" ]
+[ "sys", "storage", 18, "varchar", "" ]
+[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"(sname varchar(1024), tname varchar(1024))\nreturns table (\n
\"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\"
varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location
varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n
heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n
sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint,\n
compressed boolean\n)\nexternal name sql.\"storage\";" ]
[ "sys", "storage", 1, "varchar", "" ]
[ "sys", "storage", 2, "varchar", "" ]
[ "sys", "storage", 3, "varchar", "" ]
@@ -4450,9 +4453,10 @@ stdout of test 'systemfunctions` in dire
[ "sys", "storage", 14, "boolean", "" ]
[ "sys", "storage", 15, "boolean", "" ]
[ "sys", "storage", 16, "bigint", "" ]
-[ "sys", "storage", 17, "varchar", "" ]
+[ "sys", "storage", 17, "boolean", "" ]
[ "sys", "storage", 18, "varchar", "" ]
-[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname
varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\"
varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\"
varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n
columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n
\"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\"
boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ]
+[ "sys", "storage", 19, "varchar", "" ]
+[ "sys", "storage", 0, "varchar", "create function
sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname
varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\"
varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\"
varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n
columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n
\"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\"
boolean,\n orderidx bigint,\n compressed boolean\n)\nexternal name
sql.\"storage\";" ]
[ "sys", "storage", 1, "varchar", "" ]
[ "sys", "storage", 2, "varchar", "" ]
[ "sys", "storage", 3, "varchar", "" ]
@@ -4469,9 +4473,10 @@ stdout of test 'systemfunctions` in dire
[ "sys", "storage", 14, "boolean", "" ]
[ "sys", "storage", 15, "boolean", "" ]
[ "sys", "storage", 16, "bigint", "" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
