Changeset: 62c76da54430 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=62c76da54430 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit Branch: Jun2020 Log Message:
Approve upgrade on 32 bits. diffs (truncated from 20472 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit @@ -16,6 +16,5114 @@ stdout of test 'upgrade` in directory 's # Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:39660/ # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-30908/.s.monetdb.39660 # MonetDB/GIS module loaded +Running database upgrade commands: +set schema "sys"; +delete from sys.dependencies where id < 2000; +delete from sys.types where id < 2000; +insert into sys.types values (0, 'void', 'any', 0, 0, 0, 0, 2000); +insert into sys.types values (1, 'bat', 'table', 0, 0, 0, 1, 2000); +insert into sys.types values (2, 'ptr', 'ptr', 0, 0, 0, 1, 2000); +insert into sys.types values (3, 'bit', 'boolean', 1, 0, 2, 2, 2000); +insert into sys.types values (4, 'str', 'char', 0, 0, 0, 3, 2000); +insert into sys.types values (5, 'str', 'varchar', 0, 0, 0, 4, 2000); +insert into sys.types values (6, 'str', 'clob', 0, 0, 0, 4, 2000); +insert into sys.types values (7, 'oid', 'oid', 31, 0, 2, 6, 2000); +insert into sys.types values (8, 'bte', 'tinyint', 8, 1, 2, 7, 2000); +insert into sys.types values (9, 'sht', 'smallint', 16, 1, 2, 7, 2000); +insert into sys.types values (10, 'int', 'int', 32, 1, 2, 7, 2000); +insert into sys.types values (11, 'lng', 'bigint', 64, 1, 2, 7, 2000); +insert into sys.types values (12, 'bte', 'decimal', 2, 1, 10, 10, 2000); +insert into sys.types values (13, 'sht', 'decimal', 4, 1, 10, 10, 2000); +insert into sys.types values (14, 'int', 'decimal', 9, 1, 10, 10, 2000); +insert into sys.types values (15, 'lng', 'decimal', 18, 1, 10, 10, 2000); +insert into sys.types values (16, 'flt', 'real', 24, 2, 2, 11, 2000); +insert into sys.types values (17, 'dbl', 'double', 53, 2, 2, 11, 2000); +insert into sys.types values (18, 'int', 'month_interval', 32, 0, 2, 8, 2000); +insert into sys.types values (19, 'lng', 'sec_interval', 13, 1, 10, 9, 2000); +insert into sys.types values (20, 'daytime', 'time', 7, 0, 0, 12, 2000); +insert into sys.types values (21, 'daytime', 'timetz', 7, 1, 0, 13, 2000); +insert into sys.types values (22, 'date', 'date', 0, 0, 0, 14, 2000); +insert into sys.types values (23, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000); +insert into sys.types values (24, 'timestamp', 'timestamptz', 7, 1, 0, 16, 2000); +insert into sys.types values (25, 'blob', 'blob', 0, 0, 0, 5, 2000); +insert into sys.types values (28, 'wkb', 'geometry', 0, 0, 0, 17, 2000); +insert into sys.types values (29, 'wkba', 'geometrya', 0, 0, 0, 18, 2000); +insert into sys.types values (30, 'mbr', 'mbr', 0, 0, 0, 18, 2000); +delete from sys.functions where id < 2000; +delete from sys.args where func_id not in (select id from sys.functions); +insert into sys.functions values (26, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30851, 26, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (30852, 26, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.functions values (27, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30853, 27, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (30854, 27, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.functions values (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30855, 31, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30856, 31, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30857, 31, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30858, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30859, 32, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30860, 32, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (33, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30861, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30862, 33, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30863, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (34, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30864, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30865, 34, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30866, 34, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (35, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30867, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30868, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30869, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (36, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30870, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30871, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30872, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (37, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30873, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30874, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30875, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (38, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30876, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30877, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30878, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (39, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30879, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30880, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30881, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (40, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30882, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30883, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30884, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (41, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30885, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30886, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30887, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (42, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30888, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30889, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30890, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (43, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30891, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30892, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30893, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (44, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30894, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30895, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30896, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (45, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30897, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30898, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30899, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (46, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30900, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30901, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30902, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (47, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30903, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30904, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30905, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (48, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30906, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30907, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30908, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (49, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30909, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30910, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30911, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (50, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30912, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30913, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30914, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (51, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30915, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30916, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30917, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (52, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30918, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30919, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30920, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (53, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30921, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30922, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30923, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (54, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30924, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30925, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30926, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (55, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30927, 55, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (30928, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30929, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (56, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30930, 56, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (30931, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30932, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (57, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30933, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30934, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30935, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (58, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30936, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30937, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30938, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (59, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30939, 59, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30940, 59, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (30941, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (60, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30942, 60, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30943, 60, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (30944, 60, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (61, 'grouping', '', '', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30945, 61, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (30946, 61, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (62, 'grouping', '', '', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30947, 62, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (30948, 62, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30949, 63, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (30950, 63, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (64, 'grouping', '', '', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30951, 64, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (30952, 64, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (65, 'not_unique', 'not_unique', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30953, 65, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30954, 65, 'arg_1', 'oid', 31, 0, 1, 1); +insert into sys.functions values (66, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30955, 66, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (30956, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (67, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30957, 67, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (30958, 67, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (30959, 67, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (30960, 67, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (68, '=', '=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30961, 68, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30962, 68, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30963, 68, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (69, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30964, 69, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30965, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30966, 69, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (70, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30967, 70, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30968, 70, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (71, '>', '>', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30969, 71, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30970, 71, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30971, 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 (30972, 72, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30973, 72, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30974, 72, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (73, '<', '<', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30975, 73, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30976, 73, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30977, 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 (30978, 74, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30979, 74, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30980, 74, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (75, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30981, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30982, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (30983, 75, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (30984, 75, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (30985, 75, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.args values (30986, 75, 'arg_5', 'boolean', 1, 0, 1, 5); +insert into sys.args values (30987, 75, 'arg_6', 'boolean', 1, 0, 1, 6); +insert into sys.args values (30988, 75, 'arg_7', 'boolean', 1, 0, 1, 7); +insert into sys.args values (30989, 75, 'arg_8', 'boolean', 1, 0, 1, 8); +insert into sys.functions values (76, 'zero_or_one', 'zero_or_one', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30990, 76, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (30991, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (77, 'all', 'all', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30992, 77, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (30993, 77, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (78, 'null', 'null', 'sql', 0, 3, false, false, false, 2000, true); +insert into sys.args values (30994, 78, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30995, 78, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (79, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (30996, 79, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (30997, 79, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (30998, 79, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (30999, 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 (31000, 80, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31001, 80, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (31002, 80, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (31003, 80, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (81, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (31004, 81, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31005, 81, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (82, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (31006, 82, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31007, 82, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (83, 'sql_anyequal', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31008, 83, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31009, 83, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (31010, 83, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (84, 'sql_not_anyequal', 'not_anyequal', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31011, 84, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31012, 84, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (31013, 84, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (85, 'exist', 'exist', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (31014, 85, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31015, 85, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (86, 'not_exist', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (31016, 86, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31017, 86, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (87, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31018, 87, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31019, 87, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (88, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31020, 88, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (31021, 88, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (89, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31022, 89, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (31023, 89, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (90, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31024, 90, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (31025, 90, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (91, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31026, 91, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (31027, 91, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (31028, 91, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (31029, 91, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.functions values (92, 'min', 'min', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (31030, 92, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31031, 92, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (93, 'max', 'max', 'aggr', 0, 3, false, false, false, 2000, true); +insert into sys.args values (31032, 93, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31033, 93, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (94, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31034, 94, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31035, 94, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (31036, 94, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (95, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31037, 95, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (31038, 95, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (31039, 95, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (96, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (31040, 96, 'res_0', 'any', 0, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
