Changeset: 8e3f9b40b207 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8e3f9b40b207 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 upgrade. diffs (truncated from 188602 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,5737 +179,5727 @@ 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.functions values (63, 'grouping', '', '', 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.functions values (64, 'grouping', '', '', 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.functions values (65, 'grouping', '', '', 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.functions values (66, 'grouping', '', '', 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.functions values (67, 'grouping', '', '', 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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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.functions values (69, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29866, 69, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (29867, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (70, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29868, 70, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (29869, 70, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (29870, 70, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (29871, 70, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (71, '=', '=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29872, 71, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29873, 71, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29874, 71, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (72, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29875, 72, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29876, 72, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29877, 72, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (73, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29878, 73, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29879, 73, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (74, '>', '>', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29880, 74, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29881, 74, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29882, 74, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (75, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29883, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29884, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29885, 75, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (76, '<', '<', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29886, 76, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29887, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29888, 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 (29889, 77, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29890, 77, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29891, 77, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (78, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29892, 78, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29893, 78, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29894, 78, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29895, 78, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (29896, 78, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.args values (29897, 78, 'arg_5', 'boolean', 1, 0, 1, 5); +insert into sys.args values (29898, 78, 'arg_6', 'boolean', 1, 0, 1, 6); +insert into sys.args values (29899, 78, 'arg_7', 'boolean', 1, 0, 1, 7); +insert into sys.args values (29900, 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); +insert into sys.args values (29901, 79, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29902, 79, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (80, 'all', 'all', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29903, 80, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29904, 80, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (81, 'null', 'null', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29905, 81, 'res', 'boolean', 1, 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 (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 (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 (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 (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 (29933, 92, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.functions values (82, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29907, 82, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29908, 82, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (29909, 82, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (29910, 82, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (83, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29911, 83, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29912, 83, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (29913, 83, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (29914, 83, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (84, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29915, 84, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29916, 84, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (85, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29917, 85, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29918, 85, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (86, 'sql_anyequal', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29919, 86, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29920, 86, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29921, 86, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (87, 'sql_not_anyequal', 'not_anyequal', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29922, 87, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29923, 87, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29924, 87, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (88, 'exist', 'exist', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29925, 88, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29926, 88, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (89, 'not_exist', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29927, 89, 'res', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29928, 89, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (90, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29929, 90, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29930, 90, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (91, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29931, 91, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (29932, 91, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (92, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29933, 92, 'res_0', 'oid', 63, 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 (29935, 93, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.functions values (93, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29935, 93, 'res_0', 'int', 32, 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 (29937, 94, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.functions values (94, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29937, 94, 'res_0', 'oid', 63, 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 (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 (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 (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 (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 (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 (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 (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 (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.args values (29939, 94, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (29940, 94, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.functions values (95, 'min', 'min', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29941, 95, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29942, 95, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (96, 'max', 'max', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29943, 96, 'res', 'any', 0, 0, 0, 0); +insert into sys.args values (29944, 96, 'arg', 'any', 0, 0, 1, 1); +insert into sys.functions values (97, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29945, 97, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29946, 97, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29947, 97, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (98, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29948, 98, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29949, 98, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29950, 98, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (99, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29951, 99, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29952, 99, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29953, 99, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (100, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29954, 100, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29955, 100, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (29956, 100, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (101, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (29957, 101, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (29958, 101, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (29959, 101, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (29960, 101, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (102, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29961, 102, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29962, 102, 'arg', 'tinyint', 8, 0, 1, 1); +insert into sys.functions values (103, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29963, 103, 'res', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (29964, 103, 'arg', 'smallint', 16, 0, 1, 1); +insert into sys.functions values (104, 'sum', 'sum', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (29965, 104, 'res', 'hugeint', 128, 0, 0, 0); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
