Changeset: d1cc3972958a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d1cc3972958a Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: default Log Message:
Approve upgrade output. diffs (truncated from 6740 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -4357,895 +4357,904 @@ insert into sys.args values (14604, 1174 insert into sys.functions values (1175, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14605, 1175, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14606, 1175, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1176, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1176, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14607, 1176, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14608, 1176, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1177, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1177, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14609, 1177, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14610, 1177, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1178, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1178, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14611, 1178, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14612, 1178, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (1179, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14612, 1178, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1179, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14613, 1179, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14614, 1179, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (1180, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14615, 1180, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.functions values (1180, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14615, 1180, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14616, 1180, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (1181, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14617, 1181, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14618, 1181, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (1182, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1181, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14617, 1181, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.args values (14618, 1181, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (1182, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14619, 1182, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14620, 1182, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (1183, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14621, 1183, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.functions values (1183, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14621, 1183, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14622, 1183, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (1184, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14623, 1184, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14624, 1184, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1185, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1184, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14623, 1184, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.args values (14624, 1184, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (1185, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14625, 1185, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14626, 1185, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1186, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1186, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14627, 1186, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14628, 1186, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1187, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1187, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14629, 1187, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14630, 1187, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1188, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1188, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14631, 1188, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14632, 1188, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1189, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14633, 1189, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.functions values (1189, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14633, 1189, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14634, 1189, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1190, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1190, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14635, 1190, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14636, 1190, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1191, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14637, 1191, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14638, 1191, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1192, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14636, 1190, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1191, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14637, 1191, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.args values (14638, 1191, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1192, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14639, 1192, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14640, 1192, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1193, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1193, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14641, 1193, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14642, 1193, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1194, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1194, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14643, 1194, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14644, 1194, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1195, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14645, 1195, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.functions values (1195, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14645, 1195, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14646, 1195, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1196, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1196, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14647, 1196, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14648, 1196, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (1197, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14648, 1196, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1197, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14649, 1197, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14650, 1197, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (1198, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14651, 1198, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (14652, 1198, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1199, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14650, 1197, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1198, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14651, 1198, 'res_0', 'decimal', 9, 3, 0, 0); +insert into sys.args values (14652, 1198, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1199, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14653, 1199, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14654, 1199, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1200, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14654, 1199, 'arg_1', 'month_interval', 32, 0, 1, 1); +insert into sys.functions values (1200, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14655, 1200, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14656, 1200, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1201, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000); -insert into sys.args values (14657, 1201, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (14656, 1200, 'arg_1', 'month_interval', 32, 0, 1, 1); +insert into sys.functions values (1201, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14657, 1201, 'res_0', 'bigint', 64, 0, 0, 0); insert into sys.args values (14658, 1201, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1202, 'dayofyear', 'dayofyear', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1202, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14659, 1202, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14660, 1202, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1203, 'weekofyear', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14660, 1202, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1203, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14661, 1203, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14662, 1203, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1204, 'dayofweek', 'dayofweek', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14662, 1203, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1204, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14663, 1204, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14664, 1204, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1205, 'dayofmonth', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14664, 1204, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1205, 'dayofyear', 'dayofyear', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14665, 1205, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14666, 1205, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1206, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.functions values (1206, 'weekofyear', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000); insert into sys.args values (14667, 1206, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (14668, 1206, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1207, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000); -insert into sys.args values (14669, 1207, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (14670, 1207, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (14671, 1207, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (1208, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000); -insert into sys.args values (14672, 1208, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (14673, 1208, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (14674, 1208, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (1209, 'restart', 'restart', 'sql', 0, 1, false, false, false, 2000); -insert into sys.args values (14675, 1209, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (14676, 1209, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (14677, 1209, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (14678, 1209, 'arg_3', 'bigint', 64, 0, 1, 3); -insert into sys.functions values (1210, 'index', 'index', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (14679, 1210, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (14680, 1210, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14681, 1210, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (1211, 'index', 'index', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (14682, 1211, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (14683, 1211, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14684, 1211, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (1212, 'index', 'index', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (14685, 1212, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14686, 1212, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14687, 1212, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (1213, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (14688, 1213, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14689, 1213, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (1214, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14690, 1214, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14691, 1214, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14692, 1214, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1215, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14693, 1215, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14694, 1215, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14695, 1215, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (14696, 1215, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1216, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14697, 1216, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14698, 1216, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14699, 1216, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1217, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14700, 1217, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14701, 1217, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14702, 1217, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (14703, 1217, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1218, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14704, 1218, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14705, 1218, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14706, 1218, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (14707, 1218, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1219, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14708, 1219, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14709, 1219, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14710, 1219, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (1220, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14711, 1220, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14712, 1220, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14713, 1220, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (14714, 1220, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1221, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14715, 1221, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14716, 1221, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14717, 1221, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (1222, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14718, 1222, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14719, 1222, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14720, 1222, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (14721, 1222, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1223, 'not_like', 'not_like', 'algebra', 0, 1, false, false, false, 2000); -insert into sys.args values (14722, 1223, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (14723, 1223, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14724, 1223, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1224, 'not_like', 'not_like', 'algebra', 0, 1, false, false, false, 2000); -insert into sys.args values (14725, 1224, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (14726, 1224, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14727, 1224, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (14728, 1224, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (1225, 'not_ilike', 'not_ilike', 'algebra', 0, 1, false, false, false, 2000); -insert into sys.args values (14729, 1225, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (14730, 1225, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14731, 1225, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1226, 'not_ilike', 'not_ilike', 'algebra', 0, 1, false, false, false, 2000); -insert into sys.args values (14732, 1226, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (14733, 1226, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14734, 1226, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (14735, 1226, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (1227, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000); -insert into sys.args values (14736, 1227, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14737, 1227, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14738, 1227, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1228, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14739, 1228, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14740, 1228, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14741, 1228, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (1229, 'concat', '+', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (14742, 1229, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14743, 1229, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (14744, 1229, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1230, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14745, 1230, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14746, 1230, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (1231, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14747, 1231, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (14748, 1231, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.functions values (1232, 'length', 'length', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14749, 1232, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (14750, 1232, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (1233, 'right', 'stringright', 'str', 0, 1, false, false, false, 2000); -insert into sys.args values (14751, 1233, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.functions values (1207, 'dayofweek', 'dayofweek', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14669, 1207, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (14670, 1207, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1208, 'dayofmonth', 'day', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14671, 1208, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (14672, 1208, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1209, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000); +insert into sys.args values (14673, 1209, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (14674, 1209, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1210, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000); +insert into sys.args values (14675, 1210, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (14676, 1210, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (14677, 1210, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.functions values (1211, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000); +insert into sys.args values (14678, 1211, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (14679, 1211, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (14680, 1211, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.functions values (1212, 'restart', 'restart', 'sql', 0, 1, false, false, false, 2000); +insert into sys.args values (14681, 1212, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (14682, 1212, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (14683, 1212, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (14684, 1212, 'arg_3', 'bigint', 64, 0, 1, 3); +insert into sys.functions values (1213, 'index', 'index', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (14685, 1213, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (14686, 1213, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (14687, 1213, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (1214, 'index', 'index', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (14688, 1214, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (14689, 1214, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (14690, 1214, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (1215, 'index', 'index', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (14691, 1215, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (14692, 1215, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (14693, 1215, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (1216, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000); +insert into sys.args values (14694, 1216, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (14695, 1216, 'arg_1', 'char', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
