Changeset: ffad9f9cf90d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ffad9f9cf90d 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: Oct2020 Log Message:
Approvals. diffs (truncated from 125200 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 @@ -384,3709 +384,3687 @@ insert into sys.functions values (120, ' insert into sys.args values (35016, 120, 'res_0', 'hugeint', 128, 0, 0, 0); insert into sys.args values (35017, 120, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (121, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35018, 121, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (35019, 121, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (35020, 121, 'arg_2', 'oid', 63, 0, 1, 2); +insert into sys.args values (35018, 121, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (35019, 121, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (35020, 121, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (122, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35021, 122, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (35022, 122, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (35023, 122, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (35021, 122, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (35022, 122, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (35023, 122, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (123, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35024, 123, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (35025, 123, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (35026, 123, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (35024, 123, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (35025, 123, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (35026, 123, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (124, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35027, 124, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (35028, 124, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (35029, 124, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (35027, 124, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (35028, 124, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (35029, 124, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (125, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35030, 125, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35031, 125, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (35032, 125, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (35030, 125, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35031, 125, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (35032, 125, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (126, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35033, 126, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (35034, 126, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (35035, 126, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (35033, 126, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (35034, 126, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (35035, 126, 'arg_2', 'decimal', 2, 0, 1, 2); insert into sys.functions values (127, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35036, 127, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (35037, 127, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (35038, 127, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.args values (35036, 127, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (35037, 127, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (35038, 127, 'arg_2', 'decimal', 4, 0, 1, 2); insert into sys.functions values (128, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35039, 128, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (35040, 128, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.args values (35041, 128, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (35039, 128, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (35040, 128, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (35041, 128, 'arg_2', 'decimal', 9, 0, 1, 2); insert into sys.functions values (129, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35042, 129, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (35043, 129, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (35044, 129, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.args values (35042, 129, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (35043, 129, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (35044, 129, 'arg_2', 'decimal', 18, 0, 1, 2); insert into sys.functions values (130, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35045, 130, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (35046, 130, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (35047, 130, 'arg_2', 'decimal', 18, 0, 1, 2); +insert into sys.args values (35045, 130, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (35046, 130, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (35047, 130, 'arg_2', 'decimal', 38, 0, 1, 2); insert into sys.functions values (131, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35048, 131, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (35049, 131, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (35050, 131, 'arg_2', 'decimal', 38, 0, 1, 2); +insert into sys.args values (35048, 131, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (35049, 131, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.args values (35050, 131, 'arg_2', 'real', 24, 0, 1, 2); insert into sys.functions values (132, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35051, 132, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (35052, 132, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.args values (35053, 132, 'arg_2', 'real', 24, 0, 1, 2); -insert into sys.functions values (133, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35054, 133, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35055, 133, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.args values (35056, 133, 'arg_2', 'double', 53, 0, 1, 2); -insert into sys.functions values (134, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35057, 134, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (35058, 134, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.functions values (135, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35059, 135, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (35060, 135, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.functions values (136, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35061, 136, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35062, 136, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.functions values (137, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35063, 137, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35064, 137, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (35051, 132, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35052, 132, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (35053, 132, 'arg_2', 'double', 53, 0, 1, 2); +insert into sys.functions values (133, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35054, 133, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (35055, 133, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.functions values (134, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35056, 134, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (35057, 134, 'arg_1', 'real', 24, 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 (35058, 135, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35059, 135, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.functions values (136, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35060, 136, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35061, 136, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.functions values (137, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35062, 137, 'res_0', 'month_interval', 32, 0, 0, 0); +insert into sys.args values (35063, 137, 'arg_1', 'month_interval', 32, 0, 1, 1); insert into sys.functions values (138, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35065, 138, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (35066, 138, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (139, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35067, 139, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (35068, 139, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.args values (35064, 138, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (35065, 138, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (139, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35066, 139, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35067, 139, 'arg_1', 'double', 53, 0, 1, 1); insert into sys.functions values (140, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35069, 140, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35070, 140, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (35068, 140, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35069, 140, 'arg_1', 'tinyint', 8, 0, 1, 1); insert into sys.functions values (141, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35071, 141, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35072, 141, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (35070, 141, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35071, 141, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (142, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35073, 142, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35074, 142, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (35072, 142, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35073, 142, 'arg_1', 'int', 32, 0, 1, 1); insert into sys.functions values (143, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35075, 143, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35076, 143, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (35074, 143, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35075, 143, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (144, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35077, 144, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35078, 144, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (35076, 144, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35077, 144, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (145, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35079, 145, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35080, 145, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (35078, 145, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35079, 145, 'arg_1', 'real', 24, 0, 1, 1); insert into sys.functions values (146, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35081, 146, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35082, 146, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.args values (35080, 146, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (35081, 146, 'arg_1', 'decimal', 2, 0, 1, 1); insert into sys.functions values (147, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35083, 147, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (35084, 147, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (35082, 147, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (35083, 147, 'arg_1', 'decimal', 4, 0, 1, 1); insert into sys.functions values (148, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35085, 148, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (35086, 148, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (35084, 148, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (35085, 148, 'arg_1', 'decimal', 9, 0, 1, 1); insert into sys.functions values (149, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35087, 149, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (35088, 149, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (35086, 149, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (35087, 149, 'arg_1', 'decimal', 18, 0, 1, 1); insert into sys.functions values (150, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35089, 150, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (35090, 150, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (35088, 150, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (35089, 150, 'arg_1', 'decimal', 38, 0, 1, 1); insert into sys.functions values (151, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35091, 151, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (35092, 151, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (35090, 151, 'res_0', 'month_interval', 32, 0, 0, 0); +insert into sys.args values (35091, 151, 'arg_1', 'month_interval', 32, 0, 1, 1); insert into sys.functions values (152, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35093, 152, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (35094, 152, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (153, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35095, 153, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (35096, 153, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (154, 'count_no_nil', 'count_no_nil', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35097, 154, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.functions values (155, 'count', 'count', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35098, 155, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35099, 155, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (35092, 152, 'res_0', 'sec_interval', 13, 0, 0, 0); +insert into sys.args values (35093, 152, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (153, 'count_no_nil', 'count_no_nil', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.args values (35094, 153, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.functions values (154, 'count', 'count', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.args values (35095, 154, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (35096, 154, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (155, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.args values (35097, 155, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (35098, 155, 'arg_1', 'char', 0, 0, 1, 1); insert into sys.functions values (156, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35100, 156, 'res_0', 'varchar', 0, 0, 0, 0); -insert into sys.args values (35101, 156, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (35099, 156, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (35100, 156, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (35101, 156, 'arg_2', 'char', 0, 0, 1, 2); insert into sys.functions values (157, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); insert into sys.args values (35102, 157, 'res_0', 'varchar', 0, 0, 0, 0); insert into sys.args values (35103, 157, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (35104, 157, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (158, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35105, 158, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (35106, 158, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (159, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35107, 159, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (35108, 159, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (35109, 159, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (160, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35110, 160, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35111, 160, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (35112, 160, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (35113, 160, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (35114, 160, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (35115, 160, 'arg_5', 'tinyint', 8, 0, 1, 5); -insert into sys.functions values (161, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35116, 161, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35117, 161, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (35118, 161, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (35119, 161, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (35120, 161, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (35121, 161, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.args values (35122, 161, 'arg_6', 'tinyint', 8, 0, 1, 6); -insert into sys.functions values (162, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35123, 162, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35124, 162, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (35125, 162, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (35126, 162, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (35127, 162, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (35128, 162, 'arg_5', 'smallint', 16, 0, 1, 5); +insert into sys.functions values (158, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.args values (35104, 158, 'res_0', 'varchar', 0, 0, 0, 0); +insert into sys.args values (35105, 158, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (35106, 158, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.functions values (159, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.args values (35107, 159, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (35108, 159, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.functions values (160, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); +insert into sys.args values (35109, 160, 'res_0', 'clob', 0, 0, 0, 0); +insert into sys.args values (35110, 160, 'arg_1', 'clob', 0, 0, 1, 1); +insert into sys.args values (35111, 160, 'arg_2', 'clob', 0, 0, 1, 2); +insert into sys.functions values (161, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (35112, 161, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (35113, 161, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (162, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); +insert into sys.args values (35114, 162, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (35115, 162, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (35116, 162, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (163, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35129, 163, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35130, 163, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (35131, 163, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (35132, 163, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (35133, 163, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (35134, 163, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.args values (35135, 163, 'arg_6', 'smallint', 16, 0, 1, 6); +insert into sys.args values (35117, 163, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (35118, 163, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (35119, 163, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (35120, 163, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.args values (35121, 163, 'arg_4', 'int', 32, 0, 1, 4); +insert into sys.args values (35122, 163, 'arg_5', 'tinyint', 8, 0, 1, 5); insert into sys.functions values (164, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35136, 164, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35137, 164, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (35138, 164, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (35139, 164, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (35140, 164, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (35141, 164, 'arg_5', 'int', 32, 0, 1, 5); +insert into sys.args values (35123, 164, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (35124, 164, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (35125, 164, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (35126, 164, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.args values (35127, 164, 'arg_4', 'int', 32, 0, 1, 4); +insert into sys.args values (35128, 164, 'arg_5', 'int', 32, 0, 1, 5); +insert into sys.args values (35129, 164, 'arg_6', 'tinyint', 8, 0, 1, 6); insert into sys.functions values (165, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35142, 165, 'res_0', 'bigint', 64, 0, 0, 0); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
