Changeset: 20ef73dc0a20 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/20ef73dc0a20
Modified Files:
clients/Tests/MAL-signatures.stable.out
sql/common/sql_types.c
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Jan2022
Log Message:
Removed last occurrence of peak_next_value_for.
diffs (truncated from 49318 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
@@ -6351,7 +6351,7 @@
[ "batsql", "diff", "pattern batsql.diff(X_0:bit,
X_1:bat[:any_1]):bat[:bit] ", "SQLdiff;", "return true if cur != prev
row" ]
[ "batsql", "first_value", "pattern batsql.first_value(X_0:bat[:any_1],
X_1:any, X_2:any, X_3:int, X_4:any, X_5:any):bat[:any_1] ",
"SQLfirst_value;", "return the first value of groups" ]
[ "batsql", "get_value", "pattern batsql.get_value(X_0:bat[:str],
X_1:bat[:str]):bat[:lng] ", "mvc_get_value_bulk;", "return the current
value of the sequence (ie the next to be used value)" ]
-[ "batsql", "get_value", "pattern batsql.get_value(X_0:bat[:str],
X_1:bat[:str], X_2:bat[:oid], X_3:bat[:oid]):bat[:lng] ",
"mvc_get_value_bulk;", "return the current value of the sequence (ie the next
to be used value)"
+[ "batsql", "get_value", "pattern batsql.get_value(X_0:bat[:str],
X_1:bat[:str], X_2:bat[:oid], X_3:bat[:oid]):bat[:lng] ",
"mvc_get_value_bulk;", "return the current value of the sequence (ie the next
to be used value)" ]
[ "batsql", "index", "command batsql.index(X_0:bat[:str],
X_1:bit):bat[:bte] ", "BATSTRindex_bte;", "Return the offsets as an
index bat" ]
[ "batsql", "index", "command batsql.index(X_0:bat[:str],
X_1:bit):bat[:int] ", "BATSTRindex_int;", "Return the offsets as an
index bat" ]
[ "batsql", "index", "command batsql.index(X_0:bat[:str],
X_1:bit):bat[:sht] ", "BATSTRindex_sht;", "Return the offsets as an
index bat" ]
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -378,7 +378,7 @@ is_subtype(sql_subtype *sub, sql_subtype
if (super->digits > 0 && sub->digits > super->digits)
return 0;
/* while binding a function, 'char' types match each other */
- if (super->digits == 0 &&
+ if (super->digits == 0 &&
((super->type->eclass == EC_STRING &&
EC_VARCHAR(sub->type->eclass)) ||
(super->type->eclass == EC_CHAR && sub->type->eclass ==
EC_CHAR)))
return 1;
@@ -1439,7 +1439,6 @@ sqltypeinit( sql_allocator *sa)
for (t = strings; t < numerical; t++) {
sql_create_func(sa, "next_value_for", "sql", "next_value",
TRUE, SCALE_NONE, 0, LNG, 2, *t, *t);
sql_create_func(sa, "get_value_for", "sql", "get_value", TRUE,
SCALE_NONE, 0, LNG, 2, *t, *t);
- sql_create_func(sa, "peak_next_value_for", "sql",
"peak_next_value", TRUE, SCALE_NONE, 0, LNG, 2, *t, *t);
sql_create_func(sa, "restart", "sql", "restart", TRUE,
SCALE_NONE, 0, LNG, 3, *t, *t, LNG);
sql_create_func(sa, "index", "sql", "index", TRUE, SCALE_NONE,
0, BTE, 2, *t, BIT);
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -3463,694 +3463,682 @@ insert into sys.functions values (931, '
insert into sys.args values (43921, 931, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (43922, 931, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43923, 931, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (932, 'peak_next_value_for',
'peak_next_value', 'sql', 0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (932, 'restart', 'restart', 'sql', 0, 1,
true, false, false, 2000, true, true);
insert into sys.args values (43924, 932, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (43925, 932, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43926, 932, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (933, 'restart', 'restart', 'sql', 0, 1,
true, false, false, 2000, true, true);
-insert into sys.args values (43927, 933, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (43928, 933, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43929, 933, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (43930, 933, 'arg_3', 'bigint', 64, 0, 1, 3);
+insert into sys.args values (43927, 932, 'arg_3', 'bigint', 64, 0, 1, 3);
+insert into sys.functions values (933, 'index', 'index', 'sql', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (43928, 933, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (43929, 933, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43930, 933, 'arg_2', 'boolean', 1, 0, 1, 2);
insert into sys.functions values (934, 'index', 'index', 'sql', 0, 1, false,
false, false, 2000, true, true);
-insert into sys.args values (43931, 934, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (43931, 934, 'res_0', 'smallint', 16, 0, 0, 0);
insert into sys.args values (43932, 934, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43933, 934, 'arg_2', 'boolean', 1, 0, 1, 2);
insert into sys.functions values (935, 'index', 'index', 'sql', 0, 1, false,
false, false, 2000, true, true);
-insert into sys.args values (43934, 935, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (43934, 935, 'res_0', 'int', 32, 0, 0, 0);
insert into sys.args values (43935, 935, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43936, 935, 'arg_2', 'boolean', 1, 0, 1, 2);
-insert into sys.functions values (936, 'index', 'index', 'sql', 0, 1, false,
false, false, 2000, true, true);
-insert into sys.args values (43937, 936, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.functions values (936, 'strings', 'strings', 'sql', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43937, 936, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (43938, 936, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43939, 936, 'arg_2', 'boolean', 1, 0, 1, 2);
-insert into sys.functions values (937, 'strings', 'strings', 'sql', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43940, 937, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (43941, 937, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (938, 'locate', 'locate', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.functions values (937, 'locate', 'locate', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (43939, 937, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (43940, 937, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43941, 937, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (938, 'locate', 'locate3', 'str', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43942, 938, 'res_0', 'int', 32, 0, 0, 0);
insert into sys.args values (43943, 938, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43944, 938, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (939, 'locate', 'locate3', 'str', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43945, 939, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (43946, 939, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43947, 939, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (43948, 939, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.functions values (940, 'charindex', 'locate', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43945, 938, 'arg_3', 'int', 32, 0, 1, 3);
+insert into sys.functions values (939, 'charindex', 'locate', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43946, 939, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (43947, 939, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43948, 939, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (940, 'charindex', 'locate3', 'str', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43949, 940, 'res_0', 'int', 32, 0, 0, 0);
insert into sys.args values (43950, 940, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43951, 940, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (941, 'charindex', 'locate3', 'str', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43952, 941, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (43953, 941, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43954, 941, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (43955, 941, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.functions values (942, 'splitpart', 'splitpart', 'str', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43956, 942, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (43957, 942, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43958, 942, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (43959, 942, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.functions values (943, 'substring', 'substring', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43952, 940, 'arg_3', 'int', 32, 0, 1, 3);
+insert into sys.functions values (941, 'splitpart', 'splitpart', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43953, 941, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (43954, 941, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43955, 941, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.args values (43956, 941, 'arg_3', 'int', 32, 0, 1, 3);
+insert into sys.functions values (942, 'substring', 'substring', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43957, 942, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (43958, 942, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43959, 942, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (943, 'substring', 'substring3', 'str', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43960, 943, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (43961, 943, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43962, 943, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (944, 'substring', 'substring3', 'str', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43963, 944, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (43964, 944, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43965, 944, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.args values (43966, 944, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.functions values (945, 'substr', 'substring', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43963, 943, 'arg_3', 'int', 32, 0, 1, 3);
+insert into sys.functions values (944, 'substr', 'substring', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43964, 944, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (43965, 944, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43966, 944, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (945, 'substr', 'substring3', 'str', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43967, 945, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (43968, 945, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43969, 945, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (946, 'substr', 'substring3', 'str', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43970, 946, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (43971, 946, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43972, 946, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.args values (43973, 946, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.functions values (947, 'like', 'like', 'algebra', 0, 4, false,
false, false, 2000, true, false);
-insert into sys.args values (43974, 947, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (43975, 947, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43976, 947, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (43977, 947, 'arg_3', 'clob', 0, 0, 1, 3);
-insert into sys.args values (43978, 947, 'arg_4', 'boolean', 1, 0, 1, 4);
-insert into sys.functions values (948, 'not_like', 'not_like', 'algebra', 0,
4, false, false, false, 2000, true, false);
-insert into sys.args values (43979, 948, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (43980, 948, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43981, 948, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.args values (43982, 948, 'arg_3', 'clob', 0, 0, 1, 3);
-insert into sys.args values (43983, 948, 'arg_4', 'boolean', 1, 0, 1, 4);
-insert into sys.functions values (949, 'patindex', 'patindex', 'pcre', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (43984, 949, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (43970, 945, 'arg_3', 'int', 32, 0, 1, 3);
+insert into sys.functions values (946, 'like', 'like', 'algebra', 0, 4, false,
false, false, 2000, true, false);
+insert into sys.args values (43971, 946, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (43972, 946, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43973, 946, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.args values (43974, 946, 'arg_3', 'clob', 0, 0, 1, 3);
+insert into sys.args values (43975, 946, 'arg_4', 'boolean', 1, 0, 1, 4);
+insert into sys.functions values (947, 'not_like', 'not_like', 'algebra', 0,
4, false, false, false, 2000, true, false);
+insert into sys.args values (43976, 947, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (43977, 947, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43978, 947, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.args values (43979, 947, 'arg_3', 'clob', 0, 0, 1, 3);
+insert into sys.args values (43980, 947, 'arg_4', 'boolean', 1, 0, 1, 4);
+insert into sys.functions values (948, 'patindex', 'patindex', 'pcre', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43981, 948, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (43982, 948, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43983, 948, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (949, 'truncate', 'stringleft', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43984, 949, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (43985, 949, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43986, 949, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (950, 'truncate', 'stringleft', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43986, 949, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (950, 'concat', '+', 'calc', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (43987, 950, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (43988, 950, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43989, 950, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (951, 'concat', '+', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (43990, 951, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (43989, 950, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (951, 'ascii', 'ascii', 'str', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (43990, 951, 'res_0', 'int', 32, 0, 0, 0);
insert into sys.args values (43991, 951, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (43992, 951, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (952, 'ascii', 'ascii', 'str', 0, 1, false,
false, false, 2000, true, true);
-insert into sys.args values (43993, 952, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (43994, 952, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (953, 'code', 'unicode', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (43995, 953, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (43996, 953, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.functions values (954, 'length', 'length', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (43997, 954, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (43998, 954, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (955, 'right', 'stringright', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.functions values (952, 'code', 'unicode', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (43992, 952, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (43993, 952, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.functions values (953, 'length', 'length', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (43994, 953, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (43995, 953, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.functions values (954, 'right', 'stringright', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (43996, 954, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (43997, 954, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (43998, 954, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (955, 'left', 'stringleft', 'str', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43999, 955, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44000, 955, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (44001, 955, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (956, 'left', 'stringleft', 'str', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.functions values (956, 'upper', 'toUpper', 'str', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (44002, 956, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44003, 956, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (44004, 956, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (957, 'upper', 'toUpper', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44005, 957, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44006, 957, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (958, 'ucase', 'toUpper', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44007, 958, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44008, 958, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (959, 'lower', 'toLower', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44009, 959, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44010, 959, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (960, 'lcase', 'toLower', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44011, 960, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44012, 960, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (961, 'trim', 'trim', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44013, 961, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44014, 961, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (962, 'trim', 'trim2', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.functions values (957, 'ucase', 'toUpper', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44004, 957, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44005, 957, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.functions values (958, 'lower', 'toLower', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44006, 958, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44007, 958, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.functions values (959, 'lcase', 'toLower', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44008, 959, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44009, 959, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.functions values (960, 'trim', 'trim', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44010, 960, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44011, 960, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.functions values (961, 'trim', 'trim2', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44012, 961, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44013, 961, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (44014, 961, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (962, 'ltrim', 'ltrim', 'str', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (44015, 962, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44016, 962, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (44017, 962, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (963, 'ltrim', 'ltrim', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44018, 963, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44019, 963, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (964, 'ltrim', 'ltrim2', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.functions values (963, 'ltrim', 'ltrim2', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44017, 963, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44018, 963, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (44019, 963, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (964, 'rtrim', 'rtrim', 'str', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (44020, 964, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44021, 964, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (44022, 964, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (965, 'rtrim', 'rtrim', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44023, 965, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44024, 965, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.functions values (966, 'rtrim', 'rtrim2', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.functions values (965, 'rtrim', 'rtrim2', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44022, 965, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44023, 965, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (44024, 965, 'arg_2', 'clob', 0, 0, 1, 2);
+insert into sys.functions values (966, 'lpad', 'lpad', 'str', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (44025, 966, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44026, 966, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (44027, 966, 'arg_2', 'clob', 0, 0, 1, 2);
-insert into sys.functions values (967, 'lpad', 'lpad', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44027, 966, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (967, 'lpad', 'lpad3', 'str', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (44028, 967, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44029, 967, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (44030, 967, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (968, 'lpad', 'lpad3', 'str', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (44031, 968, 'res_0', 'clob', 0, 0, 0, 0);
-insert into sys.args values (44032, 968, 'arg_1', 'clob', 0, 0, 1, 1);
-insert into sys.args values (44033, 968, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.args values (44034, 968, 'arg_3', 'clob', 0, 0, 1, 3);
-insert into sys.functions values (969, 'rpad', 'rpad', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44031, 967, 'arg_3', 'clob', 0, 0, 1, 3);
+insert into sys.functions values (968, 'rpad', 'rpad', 'str', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (44032, 968, 'res_0', 'clob', 0, 0, 0, 0);
+insert into sys.args values (44033, 968, 'arg_1', 'clob', 0, 0, 1, 1);
+insert into sys.args values (44034, 968, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (969, 'rpad', 'rpad3', 'str', 0, 1, false,
false, false, 2000, true, false);
insert into sys.args values (44035, 969, 'res_0', 'clob', 0, 0, 0, 0);
insert into sys.args values (44036, 969, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (44037, 969, 'arg_2', 'int', 32, 0, 1, 2);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
