Changeset: 60bfe01cd194 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=60bfe01cd194 Modified Files: sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out 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/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out 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: out2in Log Message:
Approve tests. diffs (truncated from 208541 to 300 lines): diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out b/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out --- a/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out +++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out @@ -66,9 +66,9 @@ stdout of test 'pyloader3_01` in directo #DROP LOADER myfunc3; #SELECT * FROM functions WHERE name='myfunc'; % sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, semantics, side_effect, varres, vararg, schema_id, system # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, boolean, int, boolean # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 5, 1, 5 # length +% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id, system, semantics # name +% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int, boolean, boolean # type +% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1, 5, 5 # length #ROLLBACK; # 13:26:39 > 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 @@ -53,5859 +53,5859 @@ insert into sys.types values (31, 'wkba' insert into sys.types values (32, '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 (28, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29781, 28, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29782, 28, 'arg_1', 'blob', 0, 0, 1, 1); -insert into sys.functions values (29, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29783, 29, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29784, 29, 'arg_1', 'blob', 0, 0, 1, 1); -insert into sys.functions values (33, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29785, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29786, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29787, 33, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (34, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29788, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29789, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29790, 34, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (35, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29791, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29792, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29793, 35, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (36, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29794, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29795, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29796, 36, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (37, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29797, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29798, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29799, 37, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (38, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29800, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29801, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29802, 38, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (39, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29803, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29804, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29805, 39, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (40, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29806, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29807, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29808, 40, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (41, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29809, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29810, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29811, 41, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (42, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29812, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29813, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29814, 42, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (43, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29815, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29816, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29817, 43, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (44, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29818, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29819, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29820, 44, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (45, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29821, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29822, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29823, 45, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (46, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29824, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29825, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29826, 46, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (47, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29827, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29828, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29829, 47, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (48, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29830, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29831, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29832, 48, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (49, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29833, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29834, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29835, 49, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (50, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29836, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29837, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29838, 50, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (51, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29839, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29840, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29841, 51, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (52, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29842, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29843, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29844, 52, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (53, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29845, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29846, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29847, 53, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (54, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29848, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29849, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29850, 54, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (55, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29851, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29852, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29853, 55, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (56, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29854, 56, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29855, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29856, 56, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (57, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29857, 57, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (29858, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29859, 57, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (58, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29860, 58, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (29861, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29862, 58, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (59, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29863, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29864, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29865, 59, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (60, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29866, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29867, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29868, 60, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (61, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29869, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29870, 61, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (29871, 61, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (62, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29872, 62, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29873, 62, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (29874, 62, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false, false, 2000, true); -insert into sys.args values (29875, 63, 'res', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (29876, 63, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (64, 'grouping', '', '', 0, 3, false, false, false, 2000, true); -insert into sys.args values (29877, 64, 'res', 'smallint', 16, 0, 0, 0); -insert into sys.args values (29878, 64, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false, false, 2000, true); -insert into sys.args values (29879, 65, 'res', 'int', 32, 0, 0, 0); -insert into sys.args values (29880, 65, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (66, 'grouping', '', '', 0, 3, false, false, false, 2000, true); -insert into sys.args values (29881, 66, 'res', 'bigint', 64, 0, 0, 0); -insert into sys.args values (29882, 66, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (67, 'grouping', '', '', 0, 3, false, false, false, 2000, true); -insert into sys.args values (29883, 67, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (29884, 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 (29885, 68, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29886, 68, 'arg', 'oid', 63, 0, 1, 1); -insert into sys.functions values (69, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29887, 69, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (29888, 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 (29889, 70, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (29890, 70, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (29891, 70, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (29892, 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 (29893, 71, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29894, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29895, 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 (29896, 72, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29897, 72, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29898, 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 (29899, 73, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29900, 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 (29901, 74, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29902, 74, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29903, 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 (29904, 75, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29905, 75, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29906, 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 (29907, 76, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29908, 76, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29909, 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 (29910, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29911, 77, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29912, 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 (29913, 78, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29914, 78, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29915, 78, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (29916, 78, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.args values (29917, 78, 'arg_4', 'boolean', 1, 0, 1, 4); -insert into sys.args values (29918, 78, 'arg_5', 'boolean', 1, 0, 1, 5); -insert into sys.args values (29919, 78, 'arg_6', 'boolean', 1, 0, 1, 6); -insert into sys.args values (29920, 78, 'arg_7', 'boolean', 1, 0, 1, 7); -insert into sys.args values (29921, 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 (29922, 79, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (29923, 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 (29924, 80, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (29925, 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 (29926, 81, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29927, 81, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (82, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29928, 82, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29929, 82, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (29930, 82, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (29931, 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 (29932, 83, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29933, 83, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (29934, 83, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (29935, 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 (29936, 84, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29937, 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 (29938, 85, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29939, 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 (29940, 86, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29941, 86, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29942, 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 (29943, 87, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29944, 87, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29945, 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 (29946, 88, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29947, 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 (29948, 89, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29949, 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 (29950, 90, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29951, 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 (29952, 91, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29953, 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 (29954, 92, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29955, 92, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (93, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29956, 93, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29957, 93, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (94, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29958, 94, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (29959, 94, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29960, 94, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (29961, 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 (29962, 95, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (29963, 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 (29964, 96, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (29965, 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 (29966, 97, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29967, 97, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29968, 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 (29969, 98, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29970, 98, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29971, 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 (29972, 99, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29973, 99, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29974, 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 (29975, 100, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29976, 100, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (29977, 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 (29978, 101, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (29979, 101, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (29980, 101, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (29981, 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 (29982, 102, 'res', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (29983, 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 (29984, 103, 'res', 'hugeint', 128, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
