Changeset: 1d2f778ed0f8 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1d2f778ed0f8 Modified Files: sql/backends/monet5/sql_gencode.c sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.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.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out 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/dump.stable.out sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/dump.stable.out sql/test/testdb-upgrade/Tests/dump.stable.out.Windows 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: default Log Message:
Merge with Jun2016 branch. diffs (truncated from 111668 to 300 lines): diff --git a/sql/backends/monet5/sql_gencode.c b/sql/backends/monet5/sql_gencode.c --- a/sql/backends/monet5/sql_gencode.c +++ b/sql/backends/monet5/sql_gencode.c @@ -3146,8 +3146,10 @@ backend_create_sql_func(backend *be, sql int varid = 0; char *buf = GDKmalloc(MAXIDENTLEN); - if (buf == NULL) + if (buf == NULL) { + sa_destroy(sa); return -1; + } if (a->name) (void) snprintf(buf, MAXIDENTLEN, "A%s", a->name); else @@ -3160,8 +3162,10 @@ backend_create_sql_func(backend *be, sql } /* announce the transaction mode */ - if (backend_dumpstmt(be, curBlk, s, 0, 1) < 0) + if (backend_dumpstmt(be, curBlk, s, 0, 1) < 0) { + sa_destroy(sa); return -1; + } /* selectively make functions available for inlineing */ /* for the time being we only inline scalar functions */ /* and only if we see a single return value */ 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 @@ -26,9476 +26,6 @@ stdout of test 'upgrade` in directory 's 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', 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, 'lng', '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 (7584, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7585, 32, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7586, 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 (7587, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7588, 33, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7589, 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 (7590, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7591, 34, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7592, 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 (7593, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7594, 35, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7595, 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 (7596, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7597, 36, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7598, 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 (7599, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7600, 37, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7601, 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 (7602, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7603, 38, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7604, 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 (7605, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7606, 39, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7607, 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 (7608, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7609, 40, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7610, 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 (7611, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7612, 41, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7613, 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 (7614, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7615, 42, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7616, 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 (7617, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7618, 43, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7619, 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 (7620, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7621, 44, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7622, 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 (7623, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7624, 45, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7625, 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 (7626, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7627, 46, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7628, 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 (7629, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7630, 47, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7631, 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 (7632, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7633, 48, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7634, 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 (7635, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7636, 49, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7637, 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 (7638, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7639, 50, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7640, 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 (7641, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7642, 51, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7643, 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 (7644, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7645, 52, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7646, 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 (7647, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7648, 53, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7649, 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 (7650, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7651, 54, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7652, 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 (7653, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7654, 55, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7655, 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 (7656, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (7657, 56, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7658, 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 (7659, 57, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (7660, 57, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7661, 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 (7662, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7663, 58, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7664, 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 (7665, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7666, 59, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7667, 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 (7668, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7669, 60, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7670, 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 (7671, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7672, 61, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7673, 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 (7674, 63, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7675, 63, 'arg_1', 'bigint', 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 (7676, 64, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7677, 64, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (65, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000); -insert into sys.args values (7678, 65, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7679, 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 (7680, 66, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7681, 66, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (7682, 66, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (7683, 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 (7684, 67, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7685, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7686, 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 (7687, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7688, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7689, 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 (7690, 69, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7691, 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 (7692, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7693, 70, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7694, 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 (7695, 71, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7696, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7697, 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 (7698, 72, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7699, 72, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7700, 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 (7701, 73, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7702, 73, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7703, 73, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (78, 'in', 'in', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7704, 78, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7705, 78, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7706, 78, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (79, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7707, 79, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7708, 79, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (80, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7709, 80, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (7710, 80, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (81, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7711, 81, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7712, 81, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7713, 81, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (7714, 81, 'arg_3', 'varchar', 0, 0, 1, 3); -insert into sys.functions values (84, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7715, 84, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (7716, 84, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7717, 84, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (85, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7718, 85, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (7719, 85, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7720, 85, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (86, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7721, 86, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (7722, 86, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (7723, 86, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (7724, 86, '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 (7725, 107, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7726, 107, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (7727, 107, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (108, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7728, 108, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (7729, 108, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (7730, 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 (7731, 109, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (7732, 109, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (7733, 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 (7734, 110, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (7735, 110, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (7736, 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 (7737, 111, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7738, 111, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (7739, 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 (7740, 112, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (7741, 112, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (7742, 112, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7743, 113, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (7744, 113, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (7745, 113, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7746, 114, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (7747, 114, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.args values (7748, 114, 'arg_2', 'decimal', 4, 0, 1, 2); -insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7749, 115, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (7750, 115, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (7751, 115, 'arg_2', 'decimal', 9, 0, 1, 2); -insert into sys.functions values (116, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (7752, 116, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (7753, 116, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (7754, 116, 'arg_2', 'decimal', 18, 0, 1, 2); -insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list