[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-checkins
Subject: MonetDB: Mar2018 - Approve post-release upgrade.
From: Sjoerd Mullender <commits+sjoerd=acm.org () monetdb ! org>
Date: 2018-03-29 14:24:55
Message-ID: hg.f5d05f0cf981.1522333495.6315528441665844383 () monetdb-vm0 ! spin-off ! cwi ! nl
[Download RAW message or body]
Changeset: f5d05f0cf981 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f5d05f0cf981
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Mar2018
Log Message:
Approve post-release upgrade.
diffs (truncated from 121749 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
@@ -24,5743 +24,10 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
-Running database upgrade commands:
-set schema "sys";
-drop view sys.geometry_columns cascade;
-create view sys.geometry_columns as
- select cast(null as varchar(1)) as f_table_catalog,
- s.name as f_table_schema,
- t.name as f_table_name,
- c.name as f_geometry_column,
- cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer) as \
coord_dimension,
- c.type_scale as srid,
- get_type(c.type_digits, 0) as type
- from sys.columns c, sys.tables t, sys.schemas s
- where c.table_id = t.id and t.schema_id = s.id
- and c.type in (select sqlname from sys.types where systemname in ('wkb', \
'wkba'));
-GRANT SELECT ON sys.geometry_columns TO PUBLIC;
-update sys._tables set system = true where name = 'geometry_columns' and schema_id \
in (select id from schemas where name = 'sys');
-delete from sys.systemfunctions where function_id not in (select id from \
sys.functions);
-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, 'hge', 'hugeint', 128, 1, 2, 7, 2000);
-insert into sys.types values (13, 'bte', 'decimal', 2, 1, 10, 10, 2000);
-insert into sys.types values (14, 'sht', 'decimal', 4, 1, 10, 10, 2000);
-insert into sys.types values (15, 'int', 'decimal', 9, 1, 10, 10, 2000);
-insert into sys.types values (16, 'lng', 'decimal', 18, 1, 10, 10, 2000);
-insert into sys.types values (17, 'hge', 'decimal', 38, 1, 10, 10, 2000);
-insert into sys.types values (18, 'flt', 'real', 24, 2, 2, 11, 2000);
-insert into sys.types values (19, 'dbl', 'double', 53, 2, 2, 11, 2000);
-insert into sys.types values (20, 'int', 'month_interval', 32, 0, 2, 8, 2000);
-insert into sys.types values (21, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
-insert into sys.types values (22, 'daytime', 'time', 7, 0, 0, 12, 2000);
-insert into sys.types values (23, 'daytime', 'timetz', 7, 1, 0, 12, 2000);
-insert into sys.types values (24, 'date', 'date', 0, 0, 0, 13, 2000);
-insert into sys.types values (25, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000);
-insert into sys.types values (26, 'timestamp', 'timestamptz', 7, 1, 0, 14, 2000);
-insert into sys.types values (27, 'sqlblob', 'blob', 0, 0, 0, 5, 2000);
-insert into sys.types values (28, 'wkb', 'geometry', 0, 0, 0, 15, 2000);
-insert into sys.types values (29, 'wkba', 'geometrya', 0, 0, 0, 16, 2000);
-insert into sys.types values (30, '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 (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16320, 31, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16321, 31, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16322, 31, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16323, 32, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16324, 32, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16325, 32, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (33, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16326, 33, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16327, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16328, 33, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (34, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16329, 34, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16330, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16331, 34, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (35, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16332, 35, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16333, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16334, 35, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (36, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16335, 36, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16336, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16337, 36, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (37, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16338, 37, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16339, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16340, 37, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (38, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16341, 38, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16342, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16343, 38, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (39, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16344, 39, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16345, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16346, 39, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (40, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16347, 40, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16348, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16349, 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);
-insert into sys.args values (16350, 41, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16351, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16352, 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);
-insert into sys.args values (16353, 42, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16354, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16355, 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);
-insert into sys.args values (16356, 43, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16357, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16358, 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);
-insert into sys.args values (16359, 44, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16360, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16361, 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);
-insert into sys.args values (16362, 45, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16363, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16364, 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);
-insert into sys.args values (16365, 46, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16366, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16367, 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);
-insert into sys.args values (16368, 47, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16369, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16370, 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);
-insert into sys.args values (16371, 48, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16372, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16373, 48, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (49, 'mbr_contains', 'mbrContains', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16374, 49, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16375, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16376, 49, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (50, 'mbr_contains', 'mbrContains', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16377, 50, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16378, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16379, 50, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (51, 'mbr_contained', 'mbrContained', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16380, 51, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16381, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16382, 51, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (52, 'mbr_contained', 'mbrContained', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16383, 52, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16384, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16385, 52, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (53, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16386, 53, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16387, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16388, 53, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (54, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16389, 54, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16390, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16391, 54, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (55, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16392, 55, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (16393, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16394, 55, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (56, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16395, 56, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (16396, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16397, 56, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (57, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16398, 57, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16399, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16400, 57, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (58, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16401, 58, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16402, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16403, 58, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (59, 'right_shift', 'mbrRight', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16404, 59, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16405, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (16406, 59, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (60, 'right_shift', 'mbrRight', 'geom', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16407, 60, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16408, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (16409, 60, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (62, 'not_uniques', 'not_uniques', 'sql', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16410, 62, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (16411, 62, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.functions values (63, 'not_uniques', 'not_uniques', 'sql', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16412, 63, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (16413, 63, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.functions values (64, 'hash', 'hash', 'mkey', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16414, 64, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (16415, 64, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (65, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', \
0, 1, false, false, false, 2000);
-insert into sys.args values (16416, 65, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (16417, 65, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.args values (16418, 65, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.args values (16419, 65, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.functions values (66, '=', '=', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16420, 66, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16421, 66, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16422, 66, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (67, '<>', '!=', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16423, 67, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16424, 67, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16425, 67, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (68, 'isnull', 'isnil', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16426, 68, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16427, 68, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (69, '>', '>', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16428, 69, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16429, 69, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16430, 69, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (70, '>=', '>=', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16431, 70, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16432, 70, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16433, 70, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (71, '<', '<', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16434, 71, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16435, 71, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16436, 71, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (72, '<=', '<=', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16437, 72, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16438, 72, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16439, 72, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (77, 'sql_exists', 'exist', 'aggr', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16440, 77, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16441, 77, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (78, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16442, 78, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16443, 78, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (79, 'in', 'in', 'calc', 0, 1, false, false, false, \
2000);
-insert into sys.args values (16444, 79, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (16445, 79, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16446, 79, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (80, 'identity', 'identity', 'calc', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16447, 80, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (16448, 80, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (81, 'rowid', 'identity', 'calc', 0, 1, false, \
false, false, 2000);
-insert into sys.args values (16449, 81, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (16450, 81, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (82, 'rowid', 'rowid', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16451, 82, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (16452, 82, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16453, 82, 'arg_2', 'varchar', 0, 0, 1, 2);
-insert into sys.args values (16454, 82, 'arg_3', 'varchar', 0, 0, 1, 3);
-insert into sys.functions values (85, 'sql_min', 'min', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16455, 85, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (16456, 85, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16457, 85, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (86, 'sql_max', 'max', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16458, 86, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (16459, 86, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (16460, 86, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (87, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, \
false, false, false, 2000);
-insert into sys.args values (16461, 87, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (16462, 87, 'arg_1', 'boolean', 1, 0, 1, 1);
-insert into sys.args values (16463, 87, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.args values (16464, 87, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.functions values (108, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16465, 108, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (16466, 108, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (16467, 108, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (109, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16468, 109, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (16469, 109, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (16470, 109, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (110, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16471, 110, 'res_0', 'smallint', 16, 0, 0, 0);
-insert into sys.args values (16472, 110, 'arg_1', 'smallint', 16, 0, 1, 1);
-insert into sys.args values (16473, 110, 'arg_2', 'smallint', 16, 0, 1, 2);
-insert into sys.functions values (111, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16474, 111, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (16475, 111, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.args values (16476, 111, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16477, 112, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (16478, 112, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.args values (16479, 112, 'arg_2', 'bigint', 64, 0, 1, 2);
-insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16480, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (16481, 113, 'arg_1', 'hugeint', 128, 0, 1, 1);
-insert into sys.args values (16482, 113, 'arg_2', 'hugeint', 128, 0, 1, 2);
-insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16483, 114, 'res_0', 'decimal', 2, 0, 0, 0);
-insert into sys.args values (16484, 114, 'arg_1', 'decimal', 2, 0, 1, 1);
-insert into sys.args values (16485, 114, 'arg_2', 'decimal', 2, 0, 1, 2);
-insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16486, 115, 'res_0', 'decimal', 4, 0, 0, 0);
-insert into sys.args values (16487, 115, 'arg_1', 'decimal', 4, 0, 1, 1);
-insert into sys.args values (16488, 115, 'arg_2', 'decimal', 4, 0, 1, 2);
-insert into sys.functions values (116, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16489, 116, 'res_0', 'decimal', 9, 0, 0, 0);
-insert into sys.args values (16490, 116, 'arg_1', 'decimal', 9, 0, 1, 1);
-insert into sys.args values (16491, 116, 'arg_2', 'decimal', 9, 0, 1, 2);
-insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000);
-insert into sys.args values (16492, 117, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (16493, 117, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.args values (16494, 117, 'arg_2', 'decimal', 18, 0, 1, 2);
-insert into sys.functions values (118, 'mod', '%', 'calc', 0, 1, false, false, \
false, 2000); _______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic