Changeset: dddfbd662d0e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dddfbd662d0e Removed Files: sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128 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/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: default Log Message:
Approve upgrade tests. diffs (truncated from 194046 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 @@ -220,5636 +220,5664 @@ insert into sys.functions values (74, '< insert into sys.args values (20793, 74, 'res_0', 'boolean', 1, 0, 0, 0); insert into sys.args values (20794, 74, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.args values (20795, 74, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (79, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20796, 79, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (20797, 79, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (80, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20798, 80, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (20799, 80, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (81, 'in', 'in', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20800, 81, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (20801, 81, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20802, 81, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (82, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20803, 82, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (20804, 82, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (83, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20805, 83, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (20806, 83, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (84, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20807, 84, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (20808, 84, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20809, 84, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (20810, 84, 'arg_3', 'varchar', 0, 0, 1, 3); -insert into sys.functions values (87, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20811, 87, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (20812, 87, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20813, 87, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (88, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20814, 88, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (20815, 88, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20816, 88, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (89, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20817, 89, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (20818, 89, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20819, 89, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (90, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20820, 90, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (20821, 90, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20822, 90, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (91, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20823, 91, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (20824, 91, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (20825, 91, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (20826, 91, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20827, 112, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (20828, 112, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (20829, 112, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20830, 113, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (20831, 113, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (20832, 113, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20833, 114, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (20834, 114, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (20835, 114, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20836, 115, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (20837, 115, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (20838, 115, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (116, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20839, 116, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20840, 116, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (20841, 116, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20842, 117, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (20843, 117, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (20844, 117, 'arg_2', 'hugeint', 128, 0, 1, 2); +insert into sys.functions values (75, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20796, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20797, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20798, 75, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (20799, 75, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (20800, 75, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.args values (20801, 75, 'arg_5', 'boolean', 1, 0, 1, 5); +insert into sys.args values (20802, 75, 'arg_6', 'boolean', 1, 0, 1, 6); +insert into sys.args values (20803, 75, 'arg_7', 'boolean', 1, 0, 1, 7); +insert into sys.functions values (79, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20804, 79, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20805, 79, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (20806, 79, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (20807, 79, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (80, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20808, 80, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20809, 80, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (20810, 80, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (20811, 80, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (85, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20812, 85, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20813, 85, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (86, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20814, 86, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20815, 86, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (87, 'in', 'in', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20816, 87, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20817, 87, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20818, 87, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (88, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20819, 88, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (20820, 88, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (89, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20821, 89, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (20822, 89, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (90, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20823, 90, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (20824, 90, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20825, 90, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (20826, 90, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.functions values (93, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20827, 93, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (20828, 93, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20829, 93, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (94, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20830, 94, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (20831, 94, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20832, 94, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (95, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20833, 95, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (20834, 95, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20835, 95, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (96, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20836, 96, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (20837, 96, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20838, 96, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (97, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20839, 97, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (20840, 97, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (20841, 97, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (20842, 97, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (118, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20845, 118, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (20846, 118, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (20847, 118, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.args values (20843, 118, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (20844, 118, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (20845, 118, 'arg_2', 'oid', 63, 0, 1, 2); insert into sys.functions values (119, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20848, 119, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (20849, 119, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.args values (20850, 119, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.args values (20846, 119, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (20847, 119, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (20848, 119, 'arg_2', 'tinyint', 8, 0, 1, 2); insert into sys.functions values (120, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20851, 120, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (20852, 120, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (20853, 120, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.args values (20849, 120, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (20850, 120, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (20851, 120, 'arg_2', 'smallint', 16, 0, 1, 2); insert into sys.functions values (121, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20854, 121, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (20855, 121, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (20856, 121, 'arg_2', 'decimal', 18, 0, 1, 2); +insert into sys.args values (20852, 121, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (20853, 121, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (20854, 121, 'arg_2', 'int', 32, 0, 1, 2); insert into sys.functions values (122, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20857, 122, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (20858, 122, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (20859, 122, 'arg_2', 'decimal', 38, 0, 1, 2); +insert into sys.args values (20855, 122, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (20856, 122, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (20857, 122, 'arg_2', 'bigint', 64, 0, 1, 2); insert into sys.functions values (123, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20860, 123, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (20861, 123, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.args values (20862, 123, 'arg_2', 'real', 24, 0, 1, 2); +insert into sys.args values (20858, 123, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (20859, 123, 'arg_1', 'hugeint', 128, 0, 1, 1); +insert into sys.args values (20860, 123, 'arg_2', 'hugeint', 128, 0, 1, 2); insert into sys.functions values (124, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (20863, 124, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (20864, 124, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.args values (20865, 124, 'arg_2', 'double', 53, 0, 1, 2); -insert into sys.functions values (140, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20866, 140, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (20867, 140, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (141, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20868, 141, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (20869, 141, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (20870, 141, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (142, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20871, 142, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20872, 142, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20873, 142, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (20874, 142, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20875, 142, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20876, 142, 'arg_5', 'tinyint', 8, 0, 1, 5); -insert into sys.functions values (143, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20877, 143, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20878, 143, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (20879, 143, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (20880, 143, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20881, 143, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20882, 143, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.args values (20883, 143, 'arg_6', 'tinyint', 8, 0, 1, 6); -insert into sys.functions values (144, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20884, 144, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20885, 144, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20886, 144, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (20887, 144, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20888, 144, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20889, 144, 'arg_5', 'smallint', 16, 0, 1, 5); -insert into sys.functions values (145, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20890, 145, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20891, 145, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (20892, 145, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (20893, 145, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20894, 145, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20895, 145, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.args values (20896, 145, 'arg_6', 'smallint', 16, 0, 1, 6); -insert into sys.functions values (146, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20897, 146, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20898, 146, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20899, 146, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (20900, 146, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20901, 146, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20902, 146, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.functions values (147, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20903, 147, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20904, 147, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (20905, 147, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (20906, 147, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20907, 147, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20908, 147, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.args values (20909, 147, 'arg_6', 'int', 32, 0, 1, 6); +insert into sys.args values (20861, 124, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (20862, 124, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (20863, 124, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.functions values (125, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20864, 125, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (20865, 125, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (20866, 125, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.functions values (126, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20867, 126, 'res_0', 'decimal', 9, 0, 0, 0); +insert into sys.args values (20868, 126, 'arg_1', 'decimal', 9, 0, 1, 1); +insert into sys.args values (20869, 126, 'arg_2', 'decimal', 9, 0, 1, 2); +insert into sys.functions values (127, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20870, 127, 'res_0', 'decimal', 18, 0, 0, 0); +insert into sys.args values (20871, 127, 'arg_1', 'decimal', 18, 0, 1, 1); +insert into sys.args values (20872, 127, 'arg_2', 'decimal', 18, 0, 1, 2); +insert into sys.functions values (128, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20873, 128, 'res_0', 'decimal', 38, 0, 0, 0); +insert into sys.args values (20874, 128, 'arg_1', 'decimal', 38, 0, 1, 1); +insert into sys.args values (20875, 128, 'arg_2', 'decimal', 38, 0, 1, 2); +insert into sys.functions values (129, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20876, 129, 'res_0', 'real', 24, 0, 0, 0); +insert into sys.args values (20877, 129, 'arg_1', 'real', 24, 0, 1, 1); +insert into sys.args values (20878, 129, 'arg_2', 'real', 24, 0, 1, 2); +insert into sys.functions values (130, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (20879, 130, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (20880, 130, 'arg_1', 'double', 53, 0, 1, 1); +insert into sys.args values (20881, 130, 'arg_2', 'double', 53, 0, 1, 2); +insert into sys.functions values (146, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true); +insert into sys.args values (20882, 146, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20883, 146, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (147, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000, true); +insert into sys.args values (20884, 147, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (20885, 147, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (20886, 147, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (148, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20910, 148, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20911, 148, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20912, 148, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (20913, 148, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20914, 148, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20915, 148, 'arg_5', 'bigint', 64, 0, 1, 5); +insert into sys.args values (20887, 148, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (20888, 148, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (20889, 148, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (20890, 148, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.args values (20891, 148, 'arg_4', 'int', 32, 0, 1, 4); +insert into sys.args values (20892, 148, 'arg_5', 'tinyint', 8, 0, 1, 5); insert into sys.functions values (149, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20916, 149, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20917, 149, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (20918, 149, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (20919, 149, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20920, 149, 'arg_4', 'int', 32, 0, 1, 4); -insert into sys.args values (20921, 149, 'arg_5', 'int', 32, 0, 1, 5); -insert into sys.args values (20922, 149, 'arg_6', 'bigint', 64, 0, 1, 6); +insert into sys.args values (20893, 149, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (20894, 149, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (20895, 149, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (20896, 149, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.args values (20897, 149, 'arg_4', 'int', 32, 0, 1, 4); +insert into sys.args values (20898, 149, 'arg_5', 'int', 32, 0, 1, 5); +insert into sys.args values (20899, 149, 'arg_6', 'tinyint', 8, 0, 1, 6); insert into sys.functions values (150, 'window_bound', 'window_bound', 'sql', 0, 6, false, false, false, 2000, true); -insert into sys.args values (20923, 150, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (20924, 150, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (20925, 150, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (20926, 150, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.args values (20927, 150, 'arg_4', 'int', 32, 0, 1, 4); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
