Changeset: 44f9835a5d9a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/44f9835a5d9a Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.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.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.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.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.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: default Log Message:
Approvals. diffs (truncated from 20550 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 @@ -9387,6 +9387,7 @@ [ "sql", "optimizer_updates", "pattern sql.optimizer_updates():void ", "SQLoptimizersUpdate;", "" ] [ "sql", "optimizers", "command sql.optimizers() (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str]) ", "getPipeCatalog;", "" ] [ "sql", "password", "pattern sql.password(X_0:str):str ", "db_password_wrap;", "Return password hash of user" ] +[ "sql", "peak_next_value", "pattern sql.peak_next_value(X_0:str, X_1:str):lng ", "mvc_peak_next_value;", "Peaks at the next value of the sequence" ] [ "sql", "percent_rank", "pattern sql.percent_rank(X_0:any_1, X_1:bit, X_2:bit):dbl ", "SQLpercent_rank;", "return the percentage into the total number of groups for each row" ] [ "sql", "prelude", "pattern sql.prelude():void ", "SQLprelude;", "" ] [ "sql", "prepared_statements", "pattern sql.prepared_statements() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], X_3:bat[:str], X_4:bat[:timestamp]) ", "SQLsession_prepared_statements;", "Available prepared statements in the current session" ] 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 @@ -12692,6 +12692,7 @@ [ "sql", "optimizer_updates", "pattern sql.optimizer_updates():void ", "SQLoptimizersUpdate;", "" ] [ "sql", "optimizers", "command sql.optimizers() (X_0:bat[:str], X_1:bat[:str], X_2:bat[:str]) ", "getPipeCatalog;", "" ] [ "sql", "password", "pattern sql.password(X_0:str):str ", "db_password_wrap;", "Return password hash of user" ] +[ "sql", "peak_next_value", "pattern sql.peak_next_value(X_0:str, X_1:str):lng ", "mvc_peak_next_value;", "Peaks at the next value of the sequence" ] [ "sql", "percent_rank", "pattern sql.percent_rank(X_0:any_1, X_1:bit, X_2:bit):dbl ", "SQLpercent_rank;", "return the percentage into the total number of groups for each row" ] [ "sql", "prelude", "pattern sql.prelude():void ", "SQLprelude;", "" ] [ "sql", "prepared_statements", "pattern sql.prepared_statements() (X_0:bat[:int], X_1:bat[:str], X_2:bat[:int], X_3:bat[:str], X_4:bat[:timestamp]) ", "SQLsession_prepared_statements;", "Available prepared statements in the current session" ] 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,682 +3463,694 @@ 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, 'restart', 'restart', 'sql', 0, 1, true, false, false, 2000, true, true); +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.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.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 (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.functions values (934, 'index', 'index', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (43931, 934, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (43931, 934, 'res_0', 'tinyint', 8, 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', 'int', 32, 0, 0, 0); +insert into sys.args values (43934, 935, 'res_0', 'smallint', 16, 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, '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.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.args values (43938, 936, 'arg_1', 'clob', 0, 0, 1, 1); -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 (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.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.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.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 (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.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.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 (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.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.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 (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.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.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 (43985, 949, 'arg_1', 'clob', 0, 0, 1, 1); -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 (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 (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', '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 (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 (43991, 951, 'arg_1', 'clob', 0, 0, 1, 1); -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 (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.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, 'upper', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (956, 'left', 'stringleft', '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.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 (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.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.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 (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.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.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 (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.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', '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 (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 (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.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.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 (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); -insert into sys.args values (44038, 969, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (970, 'insert', 'insert', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44039, 970, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44040, 970, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44041, 970, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (44042, 970, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (44043, 970, 'arg_4', 'clob', 0, 0, 1, 4); -insert into sys.functions values (971, 'replace', 'replace', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44044, 971, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44045, 971, 'arg_1', 'clob', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
