Changeset: 6a041c78da9a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6a041c78da9a Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 Branch: oscar Log Message:
Power 8 upgrade. diffs (truncated from 29311 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 @@ -205,11 +205,11 @@ insert into sys.args values (34881, 70, insert into sys.args values (34882, 70, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.args values (34883, 70, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.args values (34884, 70, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (71, '=', '=', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (71, '=', '=', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (34885, 71, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (34886, 71, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34887, 71, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (72, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (72, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (34888, 72, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (34889, 72, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34890, 72, 'arg_2', 'any', 0, 0, 1, 2); @@ -235,7 +235,7 @@ insert into sys.functions values (78, '< insert into sys.args values (34904, 78, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (34905, 78, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34906, 78, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (79, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (79, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (34907, 79, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (34908, 79, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34909, 79, 'arg_2', 'any', 0, 0, 1, 2); @@ -315,11 +315,11 @@ insert into sys.functions values (99, 's insert into sys.args values (34963, 99, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (34964, 99, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34965, 99, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (100, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (100, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (34966, 100, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (34967, 100, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34968, 100, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (101, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (101, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true, true); insert into sys.args values (34969, 101, 'res_0', 'any', 0, 0, 0, 0); insert into sys.args values (34970, 101, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (34971, 101, 'arg_2', 'any', 0, 0, 1, 2); @@ -328,5407 +328,5430 @@ insert into sys.args values (34972, 102, insert into sys.args values (34973, 102, 'arg_1', 'boolean', 1, 0, 1, 1); insert into sys.args values (34974, 102, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.args values (34975, 102, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (103, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (34976, 103, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34977, 103, 'arg_1', 'tinyint', 8, 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 (34978, 104, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34979, 104, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.functions values (103, 'nullif', '', '', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (34976, 103, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (34977, 103, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (34978, 103, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (104, 'coalesce', '', '', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (34979, 104, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (34980, 104, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (34981, 104, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (105, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (34980, 105, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34981, 105, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (34982, 105, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (34983, 105, 'arg_1', 'tinyint', 8, 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 (34982, 106, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34983, 106, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (34984, 106, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (34985, 106, 'arg_1', 'smallint', 16, 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 (34984, 107, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (34985, 107, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (34986, 107, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (34987, 107, 'arg_1', 'int', 32, 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 (34986, 108, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (34987, 108, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (34988, 108, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (34989, 108, 'arg_1', 'hugeint', 128, 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 (34988, 109, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (34989, 109, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (34990, 109, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (34991, 109, 'arg_1', 'bigint', 64, 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 (34990, 110, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (34991, 110, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (34992, 110, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (34993, 110, 'arg_1', 'decimal', 2, 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 (34992, 111, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (34993, 111, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (34994, 111, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (34995, 111, 'arg_1', 'decimal', 4, 0, 1, 1); insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (34994, 112, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (34995, 112, 'arg_1', 'decimal', 38, 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 (34996, 113, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34997, 113, 'arg_1', 'tinyint', 8, 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 (34998, 114, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34999, 114, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (34996, 112, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (34997, 112, 'arg_1', 'decimal', 9, 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 (34998, 113, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (34999, 113, 'arg_1', 'decimal', 18, 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 (35000, 114, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (35001, 114, 'arg_1', 'decimal', 38, 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 (35000, 115, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (35001, 115, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (35002, 115, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35003, 115, 'arg_1', 'tinyint', 8, 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 (35002, 116, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (35003, 116, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (35004, 116, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35005, 116, 'arg_1', 'smallint', 16, 0, 1, 1); insert into sys.functions values (117, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35004, 117, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (35005, 117, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.functions values (118, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35006, 118, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (35007, 118, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (35008, 118, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (119, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35009, 119, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (35010, 119, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (35011, 119, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.args values (35006, 117, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35007, 117, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.functions values (118, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35008, 118, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35009, 118, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.functions values (119, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35010, 119, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35011, 119, 'arg_1', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (120, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35012, 120, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (35013, 120, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (35014, 120, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.args values (35012, 120, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (35013, 120, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (35014, 120, 'arg_2', 'oid', 63, 0, 1, 2); insert into sys.functions values (121, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (35015, 121, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (35016, 121, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (35017, 121, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (35015, 121, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (35016, 121, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (35017, 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 (35018, 122, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35019, 122, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (35020, 122, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.args values (35018, 122, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (35019, 122, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (35020, 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 (35021, 123, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (35022, 123, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (35023, 123, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.args values (35021, 123, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (35022, 123, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (35023, 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 (35024, 124, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (35025, 124, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (35026, 124, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.args values (35024, 124, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (35025, 124, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (35026, 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 (35027, 125, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (35028, 125, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.args values (35029, 125, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (35027, 125, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (35028, 125, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (35029, 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 (35030, 126, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (35031, 126, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (35032, 126, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.args values (35030, 126, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (35031, 126, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (35032, 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 (35033, 127, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (35034, 127, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (35035, 127, 'arg_2', 'decimal', 18, 0, 1, 2); +insert into sys.args values (35033, 127, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (35034, 127, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (35035, 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 (35036, 128, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (35037, 128, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (35038, 128, 'arg_2', 'decimal', 38, 0, 1, 2); +insert into sys.args values (35036, 128, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (35037, 128, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (35038, 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 (35039, 129, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (35040, 129, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.args values (35041, 129, 'arg_2', 'real', 24, 0, 1, 2); +insert into sys.args values (35039, 129, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (35040, 129, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (35041, 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 (35042, 130, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35043, 130, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.args values (35044, 130, 'arg_2', 'double', 53, 0, 1, 2); -insert into sys.functions values (131, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true, false); +insert into sys.args values (35042, 130, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (35043, 130, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (35044, 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 (35045, 131, 'res_0', 'real', 24, 0, 0, 0); insert into sys.args values (35046, 131, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.functions values (132, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (35047, 132, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (35048, 132, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.args values (35047, 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 (35048, 132, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (35049, 132, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (35050, 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 (35049, 133, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35050, 133, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (35051, 133, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (35052, 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 (35051, 134, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35052, 134, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (35053, 134, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (35054, 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 (35053, 135, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (35054, 135, 'arg_1', 'month_interval', 32, 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 (35055, 136, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (35056, 136, 'arg_1', 'sec_interval', 13, 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 (35057, 137, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35058, 137, 'arg_1', 'double', 53, 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 (35059, 138, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35060, 138, 'arg_1', 'tinyint', 8, 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 (35061, 139, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35062, 139, 'arg_1', 'smallint', 16, 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 (35063, 140, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35064, 140, 'arg_1', 'int', 32, 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 (35065, 141, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35066, 141, 'arg_1', 'bigint', 64, 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 (35067, 142, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35068, 142, 'arg_1', 'hugeint', 128, 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 (35069, 143, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (35070, 143, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.functions values (144, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35071, 144, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (35072, 144, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.functions values (145, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35073, 145, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (35074, 145, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.functions values (146, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35075, 146, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (35076, 146, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.functions values (147, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35077, 147, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (35078, 147, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.functions values (148, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35079, 148, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (35080, 148, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.functions values (149, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35081, 149, 'res_0', 'month_interval', 32, 0, 0, 0); -insert into sys.args values (35082, 149, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (150, 'avg', 'avg', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35083, 150, 'res_0', 'sec_interval', 13, 0, 0, 0); -insert into sys.args values (35084, 150, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (151, 'count_no_nil', 'count_no_nil', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35085, 151, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.functions values (152, 'count', 'count', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35086, 152, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (35087, 152, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (153, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35088, 153, 'res_0', 'varchar', 0, 0, 0, 0); -insert into sys.args values (35089, 153, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.functions values (154, 'listagg', 'str_group_concat', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (35090, 154, 'res_0', 'varchar', 0, 0, 0, 0); -insert into sys.args values (35091, 154, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (35092, 154, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (155, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true, true); -insert into sys.args values (35093, 155, 'res_0', 'boolean', 1, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
