Changeset: b9b9e5803b5c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b9b9e5803b5c Branch: octbugs Log Message:
Merge with Oct2020 branch. diffs (truncated from 5361 to 300 lines): diff --git a/documentation/source/build.rst b/documentation/source/build.rst --- a/documentation/source/build.rst +++ b/documentation/source/build.rst @@ -31,7 +31,7 @@ Prerequisites ============= PATH settings: None -ROle of clients?? How to install +Role of clients?? How to install ## Testing @@ -47,9 +47,9 @@ Configuration options The way options interact with building of the MonetDB source has fundamentally changed from the way this was done using the autotools -buildsystem. Now almost all options are on by default. And these options +build system. Now almost all options are on by default. And these options mostly control library detection. In the old system, it was possible to -build a subset of the codebase. For example, you could choose not to +build a subset of the code base. For example, you could choose not to build the sql part. Now the every part of the code is build, as long as the dependent libraries are detected. And by default, the system would try to detect all dependent libraries. If your system does not have a diff --git a/monetdb5/mal/mal_linker.c b/monetdb5/mal/mal_linker.c --- a/monetdb5/mal/mal_linker.c +++ b/monetdb5/mal/mal_linker.c @@ -485,7 +485,7 @@ MSP_locate_sqlscript(const char *filenam int malLibraryEnabled(str name) { - if (strcmp(name, "pyapi3") == 0) { + if (strcmp(name, "pyapi3") == 0 || strcmp(name, "pyapi3map") == 0) { const char *val = GDKgetenv("embedded_py"); return val && (strcmp(val, "3") == 0 || strcasecmp(val, "true") == 0 || @@ -510,7 +510,7 @@ malLibraryEnabled(str name) char * malLibraryHowToEnable(str name) { - if (strcmp(name, "pyapi3") == 0) { + if (strcmp(name, "pyapi3") == 0 || strcmp(name, "pyapi3map") == 0) { HOW_TO_ENABLE_ERROR("Python 3", "embedded_py=3") } else if (strcmp(name, "rapi") == 0) { HOW_TO_ENABLE_ERROR("R", "embedded_r=true") diff --git a/monetdb5/modules/mal/batcalc.c b/monetdb5/modules/mal/batcalc.c --- a/monetdb5/modules/mal/batcalc.c +++ b/monetdb5/modules/mal/batcalc.c @@ -1051,8 +1051,7 @@ CMDconvertbat(MalStkPtr stk, InstrPtr pc } if (s && ATOMtype(s->ttype) != TYPE_oid) { BBPunfix(b->batCacheid); - if (s) - BBPunfix(s->batCacheid); + BBPunfix(s->batCacheid); throw(MAL, "batcalc.convert", SQLSTATE(42000) ILLEGAL_ARGUMENT); } } diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 @@ -3447,853 +3447,886 @@ insert into sys.args values (37299, 894, insert into sys.functions values (895, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37300, 895, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37301, 895, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (896, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37302, 896, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37303, 896, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (897, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (896, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37302, 896, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37303, 896, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (897, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37304, 897, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37305, 897, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (898, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37306, 898, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (898, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37306, 898, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37307, 898, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (899, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37308, 899, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37309, 899, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (900, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37310, 900, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37311, 900, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (901, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37312, 901, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (899, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37308, 899, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37309, 899, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (900, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37310, 900, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37311, 900, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (901, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37312, 901, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37313, 901, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (902, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (902, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37314, 902, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37315, 902, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (903, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37316, 903, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37317, 903, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (904, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37318, 904, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37319, 904, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (905, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37315, 902, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (903, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37316, 903, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37317, 903, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (904, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37318, 904, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37319, 904, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (905, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37320, 905, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37321, 905, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (906, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (906, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37322, 906, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37323, 906, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (907, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (907, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37324, 907, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37325, 907, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (908, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (908, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37326, 908, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37327, 908, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (909, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (909, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37328, 909, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37329, 909, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (910, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37330, 910, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (910, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37330, 910, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37331, 910, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (911, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (911, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37332, 911, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37333, 911, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (912, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37333, 911, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (912, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37334, 912, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37335, 912, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (913, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37336, 913, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37337, 913, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (914, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37338, 914, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37339, 914, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (915, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37335, 912, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (913, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37336, 913, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37337, 913, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (914, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37338, 914, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37339, 914, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (915, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37340, 915, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37341, 915, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (916, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (916, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37342, 916, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37343, 916, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (917, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (917, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37344, 917, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37345, 917, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (918, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (918, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37346, 918, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37347, 918, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (919, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37348, 919, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (919, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37348, 919, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37349, 919, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (920, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (920, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37350, 920, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37351, 920, 'arg_1', 'month_interval', 3, 0, 1, 1); -insert into sys.functions values (921, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37351, 920, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (921, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37352, 921, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37353, 921, 'arg_1', 'month_interval', 3, 0, 1, 1); -insert into sys.functions values (922, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37354, 922, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37355, 922, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.functions values (923, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37356, 923, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37357, 923, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (924, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37358, 924, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37359, 924, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (925, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37353, 921, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (922, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37354, 922, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37355, 922, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (923, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37356, 923, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37357, 923, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (924, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37358, 924, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37359, 924, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (925, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37360, 925, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37361, 925, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (926, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (37362, 926, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37363, 926, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37364, 926, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (927, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37365, 927, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37366, 927, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37367, 927, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (928, 'restart', 'restart', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (37368, 928, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37369, 928, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37370, 928, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37371, 928, 'arg_3', 'bigint', 64, 0, 1, 3); -insert into sys.functions values (929, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37372, 929, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (37373, 929, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37374, 929, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (930, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37375, 930, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (37376, 930, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37377, 930, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (931, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37378, 931, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37379, 931, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37380, 931, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (932, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37381, 932, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37382, 932, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (933, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37383, 933, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37384, 933, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37385, 933, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (934, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37386, 934, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37387, 934, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37388, 934, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37389, 934, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (935, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37390, 935, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37391, 935, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37392, 935, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (936, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37393, 936, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37394, 936, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37395, 936, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37396, 936, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (937, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37397, 937, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37398, 937, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37399, 937, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37400, 937, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (938, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37401, 938, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37402, 938, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37403, 938, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (939, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37404, 939, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37405, 939, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37406, 939, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (37407, 939, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (940, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37408, 940, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37409, 940, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37410, 940, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (941, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37411, 941, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37412, 941, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37413, 941, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (37414, 941, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (942, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37415, 942, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37416, 942, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37417, 942, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (943, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37418, 943, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37419, 943, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37420, 943, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37421, 943, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (944, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37422, 944, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37423, 944, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37424, 944, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (945, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37425, 945, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37426, 945, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37427, 945, 'arg_2', 'char', 0, 0, 1, 2); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list