Changeset: 9263b59db469 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9263b59db469 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-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:
Upgrade approvals. diffs (truncated from 39129 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -180,23 +180,23 @@ insert into sys.args values (30964, 62, insert into sys.args values (30965, 62, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (30966, 62, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (30967, 63, 'res', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (30968, 63, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (30967, 63, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (30968, 63, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (64, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (30969, 64, 'res', 'smallint', 16, 0, 0, 0); -insert into sys.args values (30970, 64, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (30969, 64, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (30970, 64, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (30971, 65, 'res', 'int', 32, 0, 0, 0); -insert into sys.args values (30972, 65, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (30971, 65, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (30972, 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 (30973, 66, 'res', 'bigint', 64, 0, 0, 0); -insert into sys.args values (30974, 66, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (30973, 66, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (30974, 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 (30975, 67, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (30976, 67, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (30975, 67, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (30976, 67, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (68, 'not_unique', 'not_unique', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (30977, 68, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (30978, 68, 'arg', 'oid', 63, 0, 1, 1); +insert into sys.args values (30977, 68, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30978, 68, 'arg_1', 'oid', 63, 0, 1, 1); insert into sys.functions values (69, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (30979, 69, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (30980, 69, 'arg_1', 'any', 0, 0, 1, 1); @@ -243,14 +243,14 @@ insert into sys.args values (31011, 78, insert into sys.args values (31012, 78, 'arg_7', 'boolean', 1, 0, 1, 7); insert into sys.args values (31013, 78, 'arg_8', 'boolean', 1, 0, 1, 8); insert into sys.functions values (79, 'zero_or_one', 'zero_or_one', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31014, 79, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (31015, 79, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31014, 79, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31015, 79, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (80, 'all', 'all', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31016, 80, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (31017, 80, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31016, 80, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31017, 80, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (81, 'null', 'null', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31018, 81, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31019, 81, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31018, 81, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31019, 81, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (82, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (31020, 82, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (31021, 82, 'arg_1', 'boolean', 1, 0, 1, 1); @@ -262,11 +262,11 @@ insert into sys.args values (31025, 83, insert into sys.args values (31026, 83, 'arg_2', 'boolean', 1, 0, 1, 2); insert into sys.args values (31027, 83, 'arg_3', 'boolean', 1, 0, 1, 3); insert into sys.functions values (84, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31028, 84, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31029, 84, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31028, 84, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31029, 84, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (85, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31030, 85, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31031, 85, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31030, 85, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31031, 85, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (86, 'sql_anyequal', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (31032, 86, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (31033, 86, 'arg_1', 'any', 0, 0, 1, 1); @@ -276,11 +276,11 @@ insert into sys.args values (31035, 87, insert into sys.args values (31036, 87, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (31037, 87, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (88, 'exist', 'exist', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31038, 88, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31039, 88, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31038, 88, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31039, 88, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (89, 'not_exist', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31040, 89, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31041, 89, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31040, 89, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31041, 89, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (90, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (31042, 90, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (31043, 90, 'arg_1', 'any', 0, 0, 1, 1); @@ -299,11 +299,11 @@ insert into sys.args values (31051, 94, insert into sys.args values (31052, 94, 'arg_2', 'varchar', 0, 0, 1, 2); insert into sys.args values (31053, 94, 'arg_3', 'varchar', 0, 0, 1, 3); insert into sys.functions values (95, 'min', 'min', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31054, 95, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (31055, 95, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31054, 95, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31055, 95, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (96, 'max', 'max', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31056, 96, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (31057, 96, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31056, 96, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31057, 96, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (97, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (31058, 97, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (31059, 97, 'arg_1', 'any', 0, 0, 1, 1); @@ -326,50 +326,50 @@ insert into sys.args values (31071, 101, insert into sys.args values (31072, 101, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.args values (31073, 101, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (102, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31074, 102, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31075, 102, 'arg', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (31074, 102, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31075, 102, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (103, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31076, 103, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31077, 103, 'arg', 'smallint', 16, 0, 1, 1); +insert into sys.args values (31076, 103, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31077, 103, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (104, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31078, 104, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31079, 104, 'arg', 'int', 32, 0, 1, 1); +insert into sys.args values (31078, 104, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31079, 104, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (105, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31080, 105, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31081, 105, 'arg', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (31080, 105, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31081, 105, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (106, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31082, 106, 'res', 'bigint', 64, 0, 0, 0); -insert into sys.args values (31083, 106, 'arg', 'bigint', 64, 0, 1, 1); +insert into sys.args values (31082, 106, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (31083, 106, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (107, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31084, 107, 'res', 'decimal', 38, 0, 0, 0); -insert into sys.args values (31085, 107, 'arg', 'decimal', 2, 0, 1, 1); +insert into sys.args values (31084, 107, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (31085, 107, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.functions values (108, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31086, 108, 'res', 'decimal', 38, 0, 0, 0); -insert into sys.args values (31087, 108, 'arg', 'decimal', 4, 0, 1, 1); +insert into sys.args values (31086, 108, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (31087, 108, 'arg_1', 'decimal', 4, 0, 1, 1); insert into sys.functions values (109, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31088, 109, 'res', 'decimal', 38, 0, 0, 0); -insert into sys.args values (31089, 109, 'arg', 'decimal', 9, 0, 1, 1); +insert into sys.args values (31088, 109, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (31089, 109, 'arg_1', 'decimal', 9, 0, 1, 1); insert into sys.functions values (110, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31090, 110, 'res', 'decimal', 38, 0, 0, 0); -insert into sys.args values (31091, 110, 'arg', 'decimal', 18, 0, 1, 1); +insert into sys.args values (31090, 110, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (31091, 110, 'arg_1', 'decimal', 18, 0, 1, 1); insert into sys.functions values (111, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31092, 111, 'res', 'decimal', 38, 0, 0, 0); -insert into sys.args values (31093, 111, 'arg', 'decimal', 38, 0, 1, 1); +insert into sys.args values (31092, 111, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (31093, 111, 'arg_1', 'decimal', 38, 0, 1, 1); insert into sys.functions values (112, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31094, 112, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31095, 112, 'arg', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (31094, 112, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31095, 112, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (113, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31096, 113, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31097, 113, 'arg', 'smallint', 16, 0, 1, 1); +insert into sys.args values (31096, 113, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31097, 113, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (114, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31098, 114, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31099, 114, 'arg', 'int', 32, 0, 1, 1); +insert into sys.args values (31098, 114, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31099, 114, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (115, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31100, 115, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31101, 115, 'arg', 'bigint', 64, 0, 1, 1); +insert into sys.args values (31100, 115, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31101, 115, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (116, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31102, 116, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (31103, 116, 'arg', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (31102, 116, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (31103, 116, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (31104, 117, 'res_0', 'oid', 63, 0, 0, 0); insert into sys.args values (31105, 117, 'arg_1', 'oid', 63, 0, 1, 1); @@ -423,5481 +423,5482 @@ insert into sys.args values (31140, 129, insert into sys.args values (31141, 129, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.args values (31142, 129, 'arg_2', 'double', 53, 0, 1, 2); insert into sys.functions values (130, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31143, 130, 'res', 'real', 24, 0, 0, 0); -insert into sys.args values (31144, 130, 'arg', 'real', 24, 0, 1, 1); +insert into sys.args values (31143, 130, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (31144, 130, 'arg_1', 'real', 24, 0, 1, 1); insert into sys.functions values (131, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31145, 131, 'res', 'real', 24, 0, 0, 0); -insert into sys.args values (31146, 131, 'arg', 'real', 24, 0, 1, 1); +insert into sys.args values (31145, 131, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (31146, 131, 'arg_1', 'real', 24, 0, 1, 1); insert into sys.functions values (132, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31147, 132, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31148, 132, 'arg', 'double', 53, 0, 1, 1); +insert into sys.args values (31147, 132, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31148, 132, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.functions values (133, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31149, 133, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31150, 133, 'arg', 'double', 53, 0, 1, 1); +insert into sys.args values (31149, 133, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31150, 133, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.functions values (134, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31151, 134, 'res', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (31152, 134, 'arg', 'month_interval', 32, 0, 1, 1); +insert into sys.args values (31151, 134, 'res_0', 'month_interval', 32, 0, 0, 0); +insert into sys.args values (31152, 134, 'arg_1', 'month_interval', 32, 0, 1, 1); insert into sys.functions values (135, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (31153, 135, 'res', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (31154, 135, 'arg', 'sec_interval', 13, 0, 1, 1); +insert into sys.args values (31153, 135, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (31154, 135, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (136, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31155, 136, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31156, 136, 'arg', 'double', 53, 0, 1, 1); +insert into sys.args values (31155, 136, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31156, 136, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.functions values (137, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31157, 137, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31158, 137, 'arg', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (31157, 137, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31158, 137, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (138, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31159, 138, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31160, 138, 'arg', 'smallint', 16, 0, 1, 1); +insert into sys.args values (31159, 138, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31160, 138, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (139, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31161, 139, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31162, 139, 'arg', 'int', 32, 0, 1, 1); +insert into sys.args values (31161, 139, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31162, 139, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (140, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31163, 140, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31164, 140, 'arg', 'bigint', 64, 0, 1, 1); +insert into sys.args values (31163, 140, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31164, 140, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (141, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31165, 141, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31166, 141, 'arg', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (31165, 141, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31166, 141, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (142, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31167, 142, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31168, 142, 'arg', 'real', 24, 0, 1, 1); +insert into sys.args values (31167, 142, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31168, 142, 'arg_1', 'real', 24, 0, 1, 1); insert into sys.functions values (143, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31169, 143, 'res', 'double', 53, 0, 0, 0); -insert into sys.args values (31170, 143, 'arg', 'month_interval', 32, 0, 1, 1); +insert into sys.args values (31169, 143, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (31170, 143, 'arg_1', 'month_interval', 32, 0, 1, 1); insert into sys.functions values (144, 'count_no_nil', 'count_no_nil', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31171, 144, 'res', 'bigint', 64, 0, 0, 0); +insert into sys.args values (31171, 144, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.functions values (145, 'count', 'count', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31172, 145, 'res', 'bigint', 64, 0, 0, 0); -insert into sys.args values (31173, 145, 'arg', 'any', 0, 0, 1, 1); +insert into sys.args values (31172, 145, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (31173, 145, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (146, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31174, 146, 'res', 'varchar', 0, 0, 0, 0); -insert into sys.args values (31175, 146, 'arg', 'varchar', 0, 0, 1, 1); +insert into sys.args values (31174, 146, 'res_0', 'varchar', 0, 0, 0, 0); +insert into sys.args values (31175, 146, 'arg_1', 'varchar', 0, 0, 1, 1); insert into sys.functions values (147, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (31176, 147, 'res', 'varchar', 0, 0, 0, 0); -insert into sys.args values (31177, 147, 'arg', 'varchar', 0, 0, 1, 1); +insert into sys.args values (31176, 147, 'res_0', 'varchar', 0, 0, 0, 0); +insert into sys.args values (31177, 147, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (31178, 147, 'arg_2', 'varchar', 0, 0, 1, 2); insert into sys.functions values (148, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (31178, 148, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31179, 148, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (31179, 148, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31180, 148, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (149, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (31180, 149, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (31181, 149, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (31182, 149, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (31181, 149, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31182, 149, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (31183, 149, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (150, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (31183, 150, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (31184, 150, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (31185, 150, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (31186, 150, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (31187, 150, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (31188, 150, 'arg_5', 'tinyint', 8, 0, 1, 5); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
