Changeset: 7ff55a602c6b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7ff55a602c6b Modified Files: 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 sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.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: default Log Message:
Approve upgrades. diffs (truncated from 24707 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -3520,689 +3520,617 @@ insert into sys.functions values (944, ' insert into sys.args values (43965, 944, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (43966, 944, 'arg_1', 'clob', 0, 0, 1, 1); insert into sys.args values (43967, 944, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (945, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (43968, 945, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (43969, 945, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43970, 945, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (43971, 945, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (946, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (43972, 946, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (43973, 946, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43974, 946, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (947, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (43975, 947, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (43976, 947, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43977, 947, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (43978, 947, 'arg_3', 'clob', 0, 0, 1, 3); -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.functions values (949, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (43982, 949, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (43983, 949, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43984, 949, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (43985, 949, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (950, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (43986, 950, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (43987, 950, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43988, 950, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (951, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (43989, 951, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (43990, 951, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43991, 951, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (43992, 951, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (952, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true, false); -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.args values (43995, 952, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (953, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (43996, 953, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (43997, 953, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (43998, 953, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (954, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (43999, 954, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44000, 954, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44001, 954, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (955, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44002, 955, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44003, 955, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (956, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44004, 956, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44005, 956, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.functions values (957, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44006, 957, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44007, 957, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (958, 'right', 'stringright', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44008, 958, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44009, 958, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44010, 958, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (959, 'left', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44011, 959, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44012, 959, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44013, 959, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (960, 'upper', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44014, 960, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44015, 960, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (961, 'ucase', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44016, 961, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44017, 961, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (962, 'lower', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44018, 962, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44019, 962, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (963, 'lcase', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44020, 963, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44021, 963, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (964, 'trim', 'trim', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44022, 964, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44023, 964, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (965, 'trim', 'trim2', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44024, 965, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44025, 965, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44026, 965, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (966, 'ltrim', 'ltrim', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44027, 966, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44028, 966, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (967, 'ltrim', 'ltrim2', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43968, 944, 'arg_3', 'clob', 0, 0, 1, 3); +insert into sys.args values (43969, 944, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.functions values (945, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (43970, 945, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (43971, 945, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (43972, 945, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.args values (43973, 945, 'arg_3', 'clob', 0, 0, 1, 3); +insert into sys.args values (43974, 945, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.functions values (946, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43975, 946, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (43976, 946, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (43977, 946, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.functions values (947, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43978, 947, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (43979, 947, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (43980, 947, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (948, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43981, 948, 'res_0', 'clob', 0, 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, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true, true); +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.functions values (950, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43986, 950, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (43987, 950, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.functions values (951, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43988, 951, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (43989, 951, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (952, 'right', 'stringright', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43990, 952, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (43991, 952, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (43992, 952, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (953, 'left', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43993, 953, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (43994, 953, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (43995, 953, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (954, 'upper', 'toUpper', '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.functions values (955, 'ucase', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (43998, 955, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (43999, 955, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (956, 'lower', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44000, 956, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44001, 956, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (957, 'lcase', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44002, 957, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44003, 957, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (958, 'trim', 'trim', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44004, 958, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44005, 958, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (959, 'trim', 'trim2', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44006, 959, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44007, 959, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44008, 959, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.functions values (960, 'ltrim', 'ltrim', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44009, 960, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44010, 960, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (961, 'ltrim', 'ltrim2', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44011, 961, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44012, 961, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44013, 961, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.functions values (962, 'rtrim', 'rtrim', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44014, 962, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44015, 962, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (963, 'rtrim', 'rtrim2', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44016, 963, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44017, 963, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44018, 963, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.functions values (964, 'lpad', 'lpad', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44019, 964, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44020, 964, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44021, 964, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (965, 'lpad', 'lpad3', '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', 'int', 32, 0, 1, 2); +insert into sys.args values (44025, 965, 'arg_3', 'clob', 0, 0, 1, 3); +insert into sys.functions values (966, 'rpad', 'rpad', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44026, 966, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44027, 966, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44028, 966, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (967, 'rpad', 'rpad3', 'str', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (44029, 967, 'res_0', 'clob', 0, 0, 0, 0); insert into sys.args values (44030, 967, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44031, 967, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (968, 'rtrim', 'rtrim', '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.functions values (969, 'rtrim', 'rtrim2', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44034, 969, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44035, 969, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44036, 969, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (970, 'lpad', 'lpad', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44037, 970, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44038, 970, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44039, 970, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (971, 'lpad', 'lpad3', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44040, 971, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44041, 971, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44042, 971, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (44043, 971, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (972, 'rpad', 'rpad', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44044, 972, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44045, 972, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44046, 972, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (973, 'rpad', 'rpad3', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44047, 973, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44048, 973, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44049, 973, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (44050, 973, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (974, 'insert', 'insert', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44051, 974, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44031, 967, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (44032, 967, 'arg_3', 'clob', 0, 0, 1, 3); +insert into sys.functions values (968, 'insert', 'insert', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44033, 968, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44034, 968, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44035, 968, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (44036, 968, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.args values (44037, 968, 'arg_4', 'clob', 0, 0, 1, 4); +insert into sys.functions values (969, 'replace', 'replace', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44038, 969, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44039, 969, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44040, 969, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.args values (44041, 969, 'arg_3', 'clob', 0, 0, 1, 3); +insert into sys.functions values (970, 'repeat', 'repeat', 'str', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (44042, 970, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44043, 970, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (44044, 970, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (971, 'space', 'space', 'str', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (44045, 971, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44046, 971, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.functions values (972, 'char_length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44047, 972, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (44048, 972, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (973, 'character_length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44049, 973, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (44050, 973, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (974, 'octet_length', 'nbytes', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44051, 974, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (44052, 974, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44053, 974, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (44054, 974, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (44055, 974, 'arg_4', 'clob', 0, 0, 1, 4); -insert into sys.functions values (975, 'replace', 'replace', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44056, 975, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44057, 975, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44058, 975, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (44059, 975, 'arg_3', 'clob', 0, 0, 1, 3); -insert into sys.functions values (976, 'repeat', 'repeat', 'str', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44060, 976, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44061, 976, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44062, 976, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (977, 'space', 'space', 'str', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44063, 977, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44064, 977, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.functions values (978, 'char_length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44065, 978, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44066, 978, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (979, 'character_length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44067, 979, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44068, 979, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (980, 'octet_length', 'nbytes', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44069, 980, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44070, 980, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (981, 'soundex', 'soundex', 'txtsim', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44071, 981, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44072, 981, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (982, 'difference', 'stringdiff', 'txtsim', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44073, 982, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44074, 982, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44075, 982, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (983, 'editdistance', 'editdistance', 'txtsim', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44076, 983, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44077, 983, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44078, 983, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (984, 'editdistance2', 'editdistance2', 'txtsim', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44079, 984, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44080, 984, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44081, 984, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (985, 'similarity', 'similarity', 'txtsim', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44082, 985, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (44083, 985, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44084, 985, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (986, 'qgramnormalize', 'qgramnormalize', 'txtsim', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44085, 986, 'res_0', 'clob', 0, 0, 0, 0); -insert into sys.args values (44086, 986, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.functions values (987, 'levenshtein', 'levenshtein', 'txtsim', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44087, 987, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44088, 987, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44089, 987, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.functions values (988, 'levenshtein', 'levenshtein', 'txtsim', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44090, 988, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44091, 988, 'arg_1', 'clob', 0, 0, 1, 1); -insert into sys.args values (44092, 988, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (44093, 988, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (44094, 988, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (44095, 988, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.functions values (989, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (44096, 989, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (44097, 989, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (44098, 989, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (990, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44099, 990, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.functions values (975, 'soundex', 'soundex', 'txtsim', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (44053, 975, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (44054, 975, 'arg_1', 'clob', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
