Changeset: 8db7bfce6045 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8db7bfce6045 Added Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 Branch: default Log Message:
Approve upgrade on powerpc. diffs (truncated from 5347 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 new file mode 100644 --- /dev/null +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 @@ -0,0 +1,5342 @@ +stdout of test 'upgrade` in directory 'sql/test/emptydb-upgrade-chain` itself: + + +# 16:53:35 > +# 16:53:35 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39660" "--set" "mapi_usock=/var/tmp/mtest-30908/.s.monetdb.39660" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_emptydb-upgrade-chain" "--set" "mal_listing=0" "--set" "embedded_r=yes" +# 16:53:35 > + +# MonetDB 5 server v11.21.16 (hg id: c20b591c1c70+) +# This is an unreleased version +# Serving database 'mTests_sql_test_emptydb-upgrade-chain', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked +# Found 15.589 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# 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; +ALTER TABLE sys.keywords SET READ WRITE; +INSERT INTO sys.keywords VALUES ('WINDOW'); +drop table sys.systemfunctions; +create view sys.systemfunctions as select id as function_id from sys.functions where system; +grant select on sys.systemfunctions to public; +update sys._tables set system = true where name = 'systemfunctions' and schema_id = (select id from sys.schemas where name = 'sys'); +update sys._columns set type_digits = 1048576 where name = 'query' and table_id in (select id from sys._tables t where t.name = '_tables' and t.schema_id in (select id from sys.schemas s where s.name in ('sys', 'tmp'))); +update sys._columns set type_digits = 1048576 where name = 'query' and table_id in (select id from sys._tables t where t.name = 'tables' and t.schema_id in (select id from sys.schemas s where s.name = 'sys')); +set schema "sys"; +commit; + +Running database upgrade commands: +set schema "sys"; +ALTER TABLE sys.keywords SET READ ONLY; +set schema "sys"; +commit; + +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', 63, 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, 12, 2000); +insert into sys.types values (22, 'date', 'date', 0, 0, 0, 13, 2000); +insert into sys.types values (23, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000); +insert into sys.types values (24, 'timestamp', 'timestamptz', 7, 1, 0, 14, 2000); +insert into sys.types values (25, 'sqlblob', 'blob', 0, 0, 0, 5, 2000); +insert into sys.types values (26, 'wkb', 'geometry', 0, 0, 0, 15, 2000); +insert into sys.types values (27, 'wkba', 'geometrya', 0, 0, 0, 16, 2000); +insert into sys.types values (28, 'mbr', 'mbr', 0, 0, 0, 16, 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 (29, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18588, 29, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18589, 29, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18590, 29, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (30, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18591, 30, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18592, 30, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18593, 30, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (31, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18594, 31, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18595, 31, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18596, 31, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (32, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18597, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18598, 32, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18599, 32, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (33, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18600, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18601, 33, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18602, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (34, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18603, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18604, 34, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18605, 34, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (35, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18606, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18607, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18608, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (36, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18609, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18610, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18611, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (37, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18612, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18613, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18614, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (38, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18615, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18616, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18617, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (39, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18618, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18619, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18620, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (40, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18621, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18622, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18623, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (41, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18624, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18625, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18626, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (42, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18627, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18628, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18629, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (43, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18630, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18631, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18632, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (44, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18633, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18634, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18635, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (45, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18636, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18637, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18638, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (46, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18639, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18640, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18641, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (47, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18642, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18643, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18644, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (48, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18645, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18646, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18647, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (49, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18648, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18649, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18650, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (50, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18651, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18652, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18653, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (51, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18654, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18655, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18656, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (52, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18657, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18658, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18659, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (53, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18660, 53, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (18661, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18662, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (54, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18663, 54, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (18664, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18665, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (55, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18666, 55, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18667, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18668, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (56, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18669, 56, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18670, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18671, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (57, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18672, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18673, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18674, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (58, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18675, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18676, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18677, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (60, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18678, 60, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18679, 60, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.functions values (61, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18680, 61, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18681, 61, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.functions values (62, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18682, 62, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (18683, 62, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (63, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18684, 63, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (18685, 63, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (18686, 63, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (18687, 63, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (64, '=', '=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18688, 64, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18689, 64, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18690, 64, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (65, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18691, 65, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18692, 65, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18693, 65, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (66, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18694, 66, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18695, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (67, '>', '>', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18696, 67, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18697, 67, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18698, 67, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (68, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18699, 68, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18700, 68, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18701, 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 (18702, 69, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18703, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18704, 69, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (70, '<=', '<=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18705, 70, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18706, 70, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18707, 70, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (75, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18708, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18709, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (76, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18710, 76, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18711, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (77, 'in', 'in', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18712, 77, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18713, 77, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18714, 77, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (78, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18715, 78, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18716, 78, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (79, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18717, 79, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (18718, 79, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (80, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18719, 80, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18720, 80, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18721, 80, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (18722, 80, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.functions values (83, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18723, 83, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (18724, 83, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18725, 83, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (84, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18726, 84, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (18727, 84, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18728, 84, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (85, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18729, 85, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (18730, 85, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (18731, 85, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18732, 85, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (102, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18733, 102, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18734, 102, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (18735, 102, 'arg_2', 'oid', 63, 0, 1, 2); +insert into sys.functions values (103, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18736, 103, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (18737, 103, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (18738, 103, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (104, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18739, 104, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (18740, 104, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (18741, 104, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (105, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18742, 105, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (18743, 105, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (18744, 105, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (106, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18745, 106, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (18746, 106, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (18747, 106, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.functions values (107, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18748, 107, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (18749, 107, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (18750, 107, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.functions values (108, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (18751, 108, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (18752, 108, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (18753, 108, 'arg_2', 'decimal', 4, 0, 1, 2); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
