Changeset: 6634b00e193c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6634b00e193c Modified Files: clients/Tests/MAL-signatures.test 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 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: default Log Message:
Approve upgrades. diffs (truncated from 214332 to 300 lines): diff --git a/clients/Tests/MAL-signatures.test b/clients/Tests/MAL-signatures.test --- a/clients/Tests/MAL-signatures.test +++ b/clients/Tests/MAL-signatures.test @@ -1,4 +1,5 @@ hash-threshold 100000 + query TTTTT nosort select * from sys.malfunctions() order by module, "function", address, signature, comment ---- 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 @@ -161,3833 +161,2818 @@ insert into sys.functions values (64, 'r insert into sys.args values (44899, 64, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (44900, 64, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (44901, 64, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44902, 65, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (44903, 65, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (66, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44904, 66, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (44905, 66, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (67, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44906, 67, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44907, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (68, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44908, 68, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (44909, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (69, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44910, 69, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (44911, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (70, 'not_unique', 'not_unique', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44912, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44913, 70, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (71, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44914, 71, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (44915, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (72, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44916, 72, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (44917, 72, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (44918, 72, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (44919, 72, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (73, '=', '=', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44920, 73, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44921, 73, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44922, 73, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44902, 73, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44903, 73, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44904, 73, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (74, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44923, 74, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44924, 74, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44925, 74, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44905, 74, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44906, 74, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44907, 74, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (75, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44926, 75, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44927, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44908, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44909, 75, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (76, 'isnotnull', 'isnotnil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44928, 76, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44929, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44910, 76, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44911, 76, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (77, '>', '>', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44930, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44931, 77, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44932, 77, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44912, 77, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44913, 77, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44914, 77, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (78, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44933, 78, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44934, 78, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44935, 78, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44915, 78, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44916, 78, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44917, 78, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (79, '<', '<', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44936, 79, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44937, 79, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44938, 79, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44918, 79, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44919, 79, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44920, 79, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (80, '<=', '<=', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44939, 80, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44940, 80, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44941, 80, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44921, 80, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44922, 80, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44923, 80, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (81, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (44942, 81, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44943, 81, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44944, 81, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (44945, 81, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.args values (44946, 81, 'arg_4', 'boolean', 1, 0, 1, 4); -insert into sys.args values (44947, 81, 'arg_5', 'boolean', 1, 0, 1, 5); -insert into sys.args values (44948, 81, 'arg_6', 'boolean', 1, 0, 1, 6); -insert into sys.args values (44949, 81, 'arg_7', 'boolean', 1, 0, 1, 7); -insert into sys.args values (44950, 81, 'arg_8', 'boolean', 1, 0, 1, 8); -insert into sys.functions values (82, 'zero_or_one', 'zero_or_one', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44951, 82, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (44952, 82, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (83, 'all', 'all', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44953, 83, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (44954, 83, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (84, 'null', 'null', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44955, 84, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44956, 84, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (85, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44957, 85, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44958, 85, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (44959, 85, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (44960, 85, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (86, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44961, 86, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44962, 86, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (44963, 86, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (44964, 86, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (87, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44965, 87, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44966, 87, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44967, 87, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (88, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44968, 88, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44969, 88, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44970, 88, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (44971, 88, 'arg_3', 'oid', 63, 0, 1, 3); -insert into sys.functions values (89, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44972, 89, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44973, 89, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44974, 89, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (90, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44975, 90, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44976, 90, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44977, 90, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (44978, 90, 'arg_3', 'oid', 63, 0, 1, 3); -insert into sys.functions values (91, 'sql_anyequal', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44979, 91, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44980, 91, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44981, 91, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (92, 'sql_not_anyequal', 'not_anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44982, 92, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44983, 92, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44984, 92, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (93, 'exist', 'exist', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44985, 93, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44986, 93, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (94, 'not_exist', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (44987, 94, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44988, 94, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (95, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44989, 95, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44990, 95, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (96, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44991, 96, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (44992, 96, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (97, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44993, 97, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (44994, 97, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (98, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44995, 98, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (44996, 98, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (99, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (44997, 99, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (44998, 99, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (44999, 99, 'arg_2', 'clob', 0, 0, 1, 2); -insert into sys.args values (45000, 99, 'arg_3', 'clob', 0, 0, 1, 3); +insert into sys.args values (44924, 81, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (44925, 81, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44926, 81, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44927, 81, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (44928, 81, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.args values (44929, 81, 'arg_5', 'boolean', 1, 0, 1, 5); +insert into sys.args values (44930, 81, 'arg_6', 'boolean', 1, 0, 1, 6); +insert into sys.args values (44931, 81, 'arg_7', 'boolean', 1, 0, 1, 7); +insert into sys.args values (44932, 81, 'arg_8', 'boolean', 1, 0, 1, 8); insert into sys.functions values (100, 'min', 'min', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45001, 100, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45002, 100, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44933, 100, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44934, 100, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (101, 'max', 'max', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45003, 101, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45004, 101, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44935, 101, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44936, 101, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (102, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (45005, 102, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45006, 102, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45007, 102, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44937, 102, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44938, 102, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44939, 102, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (103, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (45008, 103, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45009, 103, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45010, 103, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44940, 103, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44941, 103, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44942, 103, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (104, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45011, 104, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45012, 104, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45013, 104, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44943, 104, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44944, 104, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44945, 104, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (105, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45014, 105, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45015, 105, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45016, 105, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44946, 105, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44947, 105, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (44948, 105, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (106, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45017, 106, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45018, 106, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (45019, 106, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (45020, 106, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (107, 'nullif', '', '', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45021, 107, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45022, 107, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45023, 107, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (108, 'coalesce', '', '', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45024, 108, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45025, 108, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45026, 108, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (109, 'casewhen', '', '', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45027, 109, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45028, 109, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45029, 109, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (110, 'case', '', '', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45030, 110, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (45031, 110, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (45032, 110, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (111, 'star', '', '', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (45033, 111, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44949, 106, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (44950, 106, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (44951, 106, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (44952, 106, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45034, 112, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (45035, 112, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (44953, 112, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (44954, 112, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (113, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45036, 113, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (45037, 113, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (44955, 113, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (44956, 113, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (114, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45038, 114, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (45039, 114, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (44957, 114, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (44958, 114, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (115, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45040, 115, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (45041, 115, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (44959, 115, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (44960, 115, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (116, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45042, 116, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (45043, 116, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (44961, 116, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (44962, 116, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (117, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45044, 117, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (45045, 117, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (44963, 117, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (44964, 117, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.functions values (118, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45046, 118, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (45047, 118, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (44965, 118, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (44966, 118, 'arg_1', 'decimal', 4, 0, 1, 1); insert into sys.functions values (119, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45048, 119, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (45049, 119, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (44967, 119, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (44968, 119, 'arg_1', 'decimal', 9, 0, 1, 1); insert into sys.functions values (120, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45050, 120, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (45051, 120, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (44969, 120, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (44970, 120, 'arg_1', 'decimal', 18, 0, 1, 1); insert into sys.functions values (121, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45052, 121, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (45053, 121, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (44971, 121, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (44972, 121, 'arg_1', 'decimal', 38, 0, 1, 1); insert into sys.functions values (122, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (45054, 122, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (45055, 122, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (44973, 122, 'res_0', 'hugeint', 128, 0, 0, 0); _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
