Changeset: 9feab9aae4fb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9feab9aae4fb Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.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.powerpc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.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/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. diffs (truncated from 193934 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 @@ -179,5723 +179,5737 @@ insert into sys.functions values (62, 'r insert into sys.args values (29851, 62, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (29852, 62, 'arg_1', 'mbr', 0, 0, 1, 1); insert into sys.args values (29853, 62, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (63, 'grouping', 'grouping', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29854, 63, 'res', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (29855, 63, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (64, 'grouping', 'grouping', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29856, 64, 'res', 'smallint', 16, 0, 0, 0); +insert into sys.args values (29857, 64, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (65, 'grouping', 'grouping', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29858, 65, 'res', 'int', 32, 0, 0, 0); +insert into sys.args values (29859, 65, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (66, 'grouping', 'grouping', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29860, 66, 'res', 'bigint', 64, 0, 0, 0); +insert into sys.args values (29861, 66, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (67, 'grouping', 'grouping', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29862, 67, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29863, 67, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (68, 'not_unique', 'not_unique', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29864, 68, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29865, 68, 'arg', 'oid', 63, 0, 1, 1); insert into sys.functions values (69, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29854, 69, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29855, 69, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (29866, 69, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (29867, 69, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (70, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29856, 70, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29857, 70, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (29868, 70, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (29869, 70, 'arg_1', 'oid', 63, 0, 1, 1); insert into sys.functions values (71, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29858, 71, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (29859, 71, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29870, 71, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (29871, 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); -insert into sys.args values (29860, 72, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (29861, 72, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (29862, 72, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (29863, 72, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (29872, 72, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (29873, 72, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (29874, 72, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (29875, 72, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (73, '=', '=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29864, 73, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29865, 73, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29866, 73, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29876, 73, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29877, 73, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29878, 73, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (74, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29867, 74, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29868, 74, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29869, 74, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29879, 74, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29880, 74, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29881, 74, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (75, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29870, 75, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29871, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29882, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29883, 75, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (76, '>', '>', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29872, 76, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29873, 76, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29874, 76, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29884, 76, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29885, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29886, 76, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (77, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29875, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29876, 77, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29877, 77, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29887, 77, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29888, 77, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29889, 77, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (78, '<', '<', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29878, 78, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29879, 78, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29880, 78, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29890, 78, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29891, 78, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29892, 78, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (79, '<=', '<=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29881, 79, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29882, 79, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29883, 79, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29893, 79, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29894, 79, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29895, 79, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (80, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29884, 80, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29885, 80, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29886, 80, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (29887, 80, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.args values (29888, 80, 'arg_4', 'boolean', 1, 0, 1, 4); -insert into sys.args values (29889, 80, 'arg_5', 'boolean', 1, 0, 1, 5); -insert into sys.args values (29890, 80, 'arg_6', 'boolean', 1, 0, 1, 6); -insert into sys.args values (29891, 80, 'arg_7', 'boolean', 1, 0, 1, 7); -insert into sys.args values (29892, 80, 'arg_8', 'boolean', 1, 0, 1, 8); +insert into sys.args values (29896, 80, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29897, 80, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29898, 80, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29899, 80, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (29900, 80, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.args values (29901, 80, 'arg_5', 'boolean', 1, 0, 1, 5); +insert into sys.args values (29902, 80, 'arg_6', 'boolean', 1, 0, 1, 6); +insert into sys.args values (29903, 80, 'arg_7', 'boolean', 1, 0, 1, 7); +insert into sys.args values (29904, 80, 'arg_8', 'boolean', 1, 0, 1, 8); +insert into sys.functions values (81, 'zero_or_one', 'zero_or_one', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29905, 81, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29906, 81, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (82, 'all', 'all', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29907, 82, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29908, 82, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (83, 'null', 'null', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29909, 83, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29910, 83, 'arg', 'any', 0, 0, 1, 1); insert into sys.functions values (84, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29893, 84, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29894, 84, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (29895, 84, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (29896, 84, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.args values (29911, 84, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29912, 84, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (29913, 84, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (29914, 84, 'arg_3', 'boolean', 1, 0, 1, 3); insert into sys.functions values (85, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29897, 85, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29898, 85, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (29899, 85, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (29900, 85, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.args values (29915, 85, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29916, 85, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (29917, 85, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (29918, 85, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (86, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29919, 86, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29920, 86, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (87, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29921, 87, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29922, 87, 'arg', 'any', 0, 0, 1, 1); insert into sys.functions values (88, 'sql_anyequal', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29901, 88, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29902, 88, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29903, 88, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29923, 88, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29924, 88, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29925, 88, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (89, 'sql_not_anyequal', 'not_anyequal', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29904, 89, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29905, 89, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29906, 89, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29926, 89, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29927, 89, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29928, 89, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (90, 'exist', 'exist', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29929, 90, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29930, 90, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (91, 'not_exist', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29931, 91, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29932, 91, 'arg', 'any', 0, 0, 1, 1); insert into sys.functions values (92, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29907, 92, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29908, 92, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29933, 92, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29934, 92, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (93, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29909, 93, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29910, 93, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29935, 93, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29936, 93, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (94, 'in', 'in', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29911, 94, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29912, 94, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29913, 94, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29937, 94, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29938, 94, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29939, 94, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (95, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29914, 95, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29915, 95, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29940, 95, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (29941, 95, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (96, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29916, 96, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29917, 96, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29942, 96, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (29943, 96, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (97, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29918, 97, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29919, 97, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29920, 97, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (29921, 97, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.args values (29944, 97, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (29945, 97, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29946, 97, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (29947, 97, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.functions values (98, 'min', 'min', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29948, 98, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29949, 98, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (99, 'max', 'max', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29950, 99, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29951, 99, 'arg', 'any', 0, 0, 1, 1); insert into sys.functions values (100, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29922, 100, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29923, 100, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29924, 100, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29952, 100, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29953, 100, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29954, 100, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (101, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29925, 101, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29926, 101, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29927, 101, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29955, 101, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29956, 101, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29957, 101, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (102, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29928, 102, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29929, 102, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29930, 102, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29958, 102, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29959, 102, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29960, 102, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (103, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29931, 103, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29932, 103, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29933, 103, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29961, 103, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29962, 103, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29963, 103, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (104, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29934, 104, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29935, 104, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (29936, 104, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (29937, 104, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (29964, 104, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29965, 104, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (29966, 104, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29967, 104, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (105, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29968, 105, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29969, 105, 'arg', 'tinyint', 8, 0, 1, 1); +insert into sys.functions values (106, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29970, 106, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29971, 106, 'arg', 'smallint', 16, 0, 1, 1); +insert into sys.functions values (107, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29972, 107, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29973, 107, 'arg', 'int', 32, 0, 1, 1); +insert into sys.functions values (108, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29974, 108, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29975, 108, 'arg', 'hugeint', 128, 0, 1, 1); +insert into sys.functions values (109, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29976, 109, 'res', 'bigint', 64, 0, 0, 0); +insert into sys.args values (29977, 109, 'arg', 'bigint', 64, 0, 1, 1); +insert into sys.functions values (110, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29978, 110, 'res', 'decimal', 38, 0, 0, 0); +insert into sys.args values (29979, 110, 'arg', 'decimal', 2, 0, 1, 1); +insert into sys.functions values (111, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29980, 111, 'res', 'decimal', 38, 0, 0, 0); +insert into sys.args values (29981, 111, 'arg', 'decimal', 4, 0, 1, 1); +insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29982, 112, 'res', 'decimal', 38, 0, 0, 0); +insert into sys.args values (29983, 112, 'arg', 'decimal', 9, 0, 1, 1); +insert into sys.functions values (113, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29984, 113, 'res', 'decimal', 38, 0, 0, 0); +insert into sys.args values (29985, 113, 'arg', 'decimal', 18, 0, 1, 1); +insert into sys.functions values (114, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29986, 114, 'res', 'decimal', 38, 0, 0, 0); +insert into sys.args values (29987, 114, 'arg', 'decimal', 38, 0, 1, 1); +insert into sys.functions values (115, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29988, 115, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29989, 115, 'arg', 'tinyint', 8, 0, 1, 1); +insert into sys.functions values (116, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29990, 116, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29991, 116, 'arg', 'smallint', 16, 0, 1, 1); +insert into sys.functions values (117, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29992, 117, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29993, 117, 'arg', 'int', 32, 0, 1, 1); +insert into sys.functions values (118, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29994, 118, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29995, 118, 'arg', 'bigint', 64, 0, 1, 1); +insert into sys.functions values (119, 'prod', 'prod', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29996, 119, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29997, 119, 'arg', 'hugeint', 128, 0, 1, 1); insert into sys.functions values (120, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29938, 120, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29939, 120, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (29940, 120, 'arg_2', 'oid', 63, 0, 1, 2); +insert into sys.args values (29998, 120, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (29999, 120, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (30000, 120, 'arg_2', 'oid', 63, 0, 1, 2); insert into sys.functions values (121, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
