Changeset: fcafb0ff5f52 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fcafb0ff5f52
Added Files:
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.oid32
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.oid32
Modified Files:
gdk/gdk_bbp.c
Branch: Jun2016
Log Message:
Fix upgrade for 32-bit OIDs.
diffs (truncated from 19721 to 300 lines):
diff --git a/gdk/gdk_bbp.c b/gdk/gdk_bbp.c
--- a/gdk/gdk_bbp.c
+++ b/gdk/gdk_bbp.c
@@ -885,7 +885,7 @@ fixwkbheap(void)
new = (var_t *) Tloc(b, BUNfirst(b));
for (i = 0; i < b->batCount; i++) {
int len;
- owkb = (struct old_wkb *) (h2.base + old[i]);
+ owkb = (struct old_wkb *) (h2.base + (old[i] <<
GDK_VARSHIFT));
if ((len = owkb->len) == ~0)
len = 0;
if ((new[i] = HEAP_malloc(b->T->vheap, offsetof(struct
new_wkb, data) + len)) == 0)
diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.oid32
b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.oid32
new file mode 100644
--- /dev/null
+++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.oid32
@@ -0,0 +1,9848 @@
+stdout of test 'upgrade` in directory 'sql/test/testdb-upgrade-chain-hge`
itself:
+
+
+# 15:45:52 >
+# 15:45:52 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=37689" "--set"
"mapi_usock=/var/tmp/mtest-31771/.s.monetdb.37689" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_sql_test_testdb-upgrade-chain-hge"
"--set" "mal_listing=0" "--set" "embedded_r=yes"
+# 15:45:52 >
+
+# MonetDB 5 server v11.21.6 (hg id: adf405e7edb0+)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_testdb-upgrade-chain-hge', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit
integers dynamically linked
+# Found 15.590 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.ins.cwi.nl:37689/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-31771/.s.monetdb.37689
+# MonetDB/GIS module loaded
+# Start processing logs sql/sql_logs version 52200
+# Finished processing logs sql/sql_logs
+# MonetDB/SQL module loaded
+# MonetDB/R module loaded
+
+Ready.
+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, 'wrd', 'wrd', 64, 1, 2, 7, 2000);
+insert into sys.types values (13, 'hge', 'hugeint', 128, 1, 2, 7, 2000);
+insert into sys.types values (14, 'bte', 'decimal', 2, 1, 10, 10, 2000);
+insert into sys.types values (15, 'sht', 'decimal', 4, 1, 10, 10, 2000);
+insert into sys.types values (16, 'int', 'decimal', 9, 1, 10, 10, 2000);
+insert into sys.types values (17, 'lng', 'decimal', 18, 1, 10, 10, 2000);
+insert into sys.types values (18, 'hge', 'decimal', 39, 1, 10, 10, 2000);
+insert into sys.types values (19, 'flt', 'real', 24, 2, 2, 11, 2000);
+insert into sys.types values (20, 'dbl', 'double', 53, 2, 2, 11, 2000);
+insert into sys.types values (21, 'int', 'month_interval', 32, 0, 2, 8, 2000);
+insert into sys.types values (22, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
+insert into sys.types values (23, 'daytime', 'time', 7, 0, 0, 12, 2000);
+insert into sys.types values (24, 'daytime', 'timetz', 7, 1, 0, 12, 2000);
+insert into sys.types values (25, 'date', 'date', 0, 0, 0, 13, 2000);
+insert into sys.types values (26, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000);
+insert into sys.types values (27, 'timestamp', 'timestamptz', 7, 1, 0, 14,
2000);
+insert into sys.types values (28, 'sqlblob', 'blob', 0, 0, 0, 5, 2000);
+insert into sys.types values (29, 'wkb', 'geometry', 0, 0, 0, 15, 2000);
+insert into sys.types values (30, 'wkba', 'geometrya', 0, 0, 0, 16, 2000);
+insert into sys.types values (31, '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 (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000);
+insert into sys.args values (7700, 32, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7701, 32, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7702, 32, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (33, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000);
+insert into sys.args values (7703, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7704, 33, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7705, 33, 'arg_2', 'mbr', 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 (7706, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7707, 34, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7708, 34, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (35, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7709, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7710, 35, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7711, 35, 'arg_2', 'mbr', 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 (7712, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7713, 36, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7714, 36, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (37, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7715, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7716, 37, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7717, 37, 'arg_2', 'mbr', 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 (7718, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7719, 38, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7720, 38, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (39, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7721, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7722, 39, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7723, 39, 'arg_2', 'mbr', 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 (7724, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7725, 40, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7726, 40, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (41, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7727, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7728, 41, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7729, 41, 'arg_2', 'mbr', 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 (7730, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7731, 42, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7732, 42, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (43, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (7733, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7734, 43, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7735, 43, 'arg_2', 'mbr', 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 (7736, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7737, 44, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7738, 44, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (45, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (7739, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7740, 45, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7741, 45, 'arg_2', 'mbr', 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 (7742, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7743, 46, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7744, 46, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (47, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (7745, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7746, 47, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7747, 47, 'arg_2', 'mbr', 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 (7748, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7749, 48, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7750, 48, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (49, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (7751, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7752, 49, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7753, 49, 'arg_2', 'mbr', 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 (7754, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7755, 50, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7756, 50, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (51, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (7757, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7758, 51, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7759, 51, 'arg_2', 'mbr', 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 (7760, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7761, 52, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7762, 52, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (53, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (7763, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7764, 53, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7765, 53, 'arg_2', 'mbr', 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 (7766, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7767, 54, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7768, 54, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (55, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7769, 55, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7770, 55, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7771, 55, 'arg_2', 'mbr', 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 (7772, 56, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (7773, 56, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7774, 56, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (57, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (7775, 57, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (7776, 57, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7777, 57, 'arg_2', 'mbr', 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 (7778, 58, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7779, 58, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7780, 58, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (59, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7781, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7782, 59, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7783, 59, 'arg_2', 'mbr', 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 (7784, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7785, 60, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (7786, 60, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (61, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7787, 61, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7788, 61, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (7789, 61, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (63, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000);
+insert into sys.args values (7790, 63, 'res_0', 'oid', 31, 0, 0, 0);
+insert into sys.args values (7791, 63, 'arg_1', 'wrd', 64, 0, 1, 1);
+insert into sys.functions values (64, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000);
+insert into sys.args values (7792, 64, 'res_0', 'oid', 31, 0, 0, 0);
+insert into sys.args values (7793, 64, 'arg_1', 'oid', 31, 0, 1, 1);
+insert into sys.functions values (65, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000);
+insert into sys.args values (7794, 65, 'res_0', 'wrd', 64, 0, 0, 0);
+insert into sys.args values (7795, 65, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (66, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000);
+insert into sys.args values (7796, 66, 'res_0', 'wrd', 64, 0, 0, 0);
+insert into sys.args values (7797, 66, 'arg_1', 'wrd', 64, 0, 1, 1);
+insert into sys.args values (7798, 66, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (7799, 66, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (67, '=', '=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7800, 67, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7801, 67, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7802, 67, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (68, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7803, 68, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7804, 68, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7805, 68, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (69, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (7806, 69, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7807, 69, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (70, '>', '>', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7808, 70, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7809, 70, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7810, 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 (7811, 71, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7812, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7813, 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 (7814, 72, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7815, 72, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7816, 72, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (73, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7817, 73, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7818, 73, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7819, 73, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (77, 'in', 'in', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7820, 77, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (7821, 77, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7822, 77, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (78, 'identity', 'identity', 'calc', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7823, 78, 'res_0', 'oid', 31, 0, 0, 0);
+insert into sys.args values (7824, 78, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (79, 'rowid', 'identity', 'calc', 0, 1,
false, false, false, 2000);
+insert into sys.args values (7825, 79, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (7826, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (80, 'rowid', 'rowid', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (7827, 80, 'res_0', 'oid', 31, 0, 0, 0);
+insert into sys.args values (7828, 80, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7829, 80, 'arg_2', 'varchar', 0, 0, 1, 2);
+insert into sys.args values (7830, 80, 'arg_3', 'varchar', 0, 0, 1, 3);
+insert into sys.functions values (83, 'sql_min', 'min', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (7831, 83, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (7832, 83, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7833, 83, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (84, 'sql_max', 'max', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (7834, 84, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (7835, 84, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (7836, 84, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (85, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000);
+insert into sys.args values (7837, 85, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (7838, 85, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (7839, 85, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (7840, 85, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (107, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7841, 107, 'res_0', 'oid', 31, 0, 0, 0);
+insert into sys.args values (7842, 107, 'arg_1', 'oid', 31, 0, 1, 1);
+insert into sys.args values (7843, 107, 'arg_2', 'oid', 31, 0, 1, 2);
+insert into sys.functions values (108, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7844, 108, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (7845, 108, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (7846, 108, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (109, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7847, 109, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (7848, 109, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (7849, 109, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (110, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7850, 110, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (7851, 110, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (7852, 110, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (111, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7853, 111, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (7854, 111, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (7855, 111, 'arg_2', 'bigint', 64, 0, 1, 2);
+insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7856, 112, 'res_0', 'wrd', 64, 0, 0, 0);
+insert into sys.args values (7857, 112, 'arg_1', 'wrd', 64, 0, 1, 1);
+insert into sys.args values (7858, 112, 'arg_2', 'wrd', 64, 0, 1, 2);
+insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (7859, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (7860, 113, 'arg_1', 'hugeint', 128, 0, 1, 1);
+insert into sys.args values (7861, 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 (7862, 114, 'res_0', 'decimal', 2, 0, 0, 0);
+insert into sys.args values (7863, 114, 'arg_1', 'decimal', 2, 0, 1, 1);
+insert into sys.args values (7864, 114, 'arg_2', 'decimal', 2, 0, 1, 2);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
