Changeset: 5d5ec4116f33 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5d5ec4116f33 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 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.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 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.int128 Branch: mtime Log Message:
Approve output. diffs (truncated from 13648 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 @@ -4982,914 +4982,920 @@ insert into sys.args values (28899, 1305 insert into sys.functions values (1306, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28900, 1306, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28901, 1306, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1307, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.functions values (1307, 'dayofyear', 'dayofyear', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28902, 1307, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28903, 1307, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (1308, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28903, 1307, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1308, 'weekofyear', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28904, 1308, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28905, 1308, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (1309, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28906, 1309, 'res_0', 'decimal', 9, 6, 0, 0); -insert into sys.args values (28907, 1309, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (1310, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28905, 1308, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1309, 'dayofweek', 'dayofweek', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28906, 1309, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (28907, 1309, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1310, 'dayofmonth', 'day', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28908, 1310, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28909, 1310, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (1311, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28909, 1310, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1311, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28910, 1311, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28911, 1311, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (1312, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28912, 1312, 'res_0', 'decimal', 9, 6, 0, 0); -insert into sys.args values (28913, 1312, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (1313, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28911, 1311, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (1312, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28912, 1312, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (28913, 1312, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (1313, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28914, 1313, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28915, 1313, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1314, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28916, 1314, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28917, 1314, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1315, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28915, 1313, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (1314, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28916, 1314, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (28917, 1314, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (1315, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28918, 1315, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28919, 1315, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1316, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28919, 1315, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (1316, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28920, 1316, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28921, 1316, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1317, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28922, 1317, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28923, 1317, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1318, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28921, 1316, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (1317, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28922, 1317, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (28923, 1317, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (1318, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28924, 1318, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28925, 1318, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1319, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.functions values (1319, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28926, 1319, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28927, 1319, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1320, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.functions values (1320, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28928, 1320, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28929, 1320, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1321, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28930, 1321, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (1321, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28930, 1321, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28931, 1321, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (1322, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.functions values (1322, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28932, 1322, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28933, 1322, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1323, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28933, 1322, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1323, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28934, 1323, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28935, 1323, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1324, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28935, 1323, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1324, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28936, 1324, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28937, 1324, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1325, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28937, 1324, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1325, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28938, 1325, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28939, 1325, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1326, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28940, 1326, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28941, 1326, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1327, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28939, 1325, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1326, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28940, 1326, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (28941, 1326, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (1327, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28942, 1327, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28943, 1327, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (1328, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28944, 1328, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (1328, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28944, 1328, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (28945, 1328, 'arg_1', 'timestamptz', 7, 0, 1, 1); insert into sys.functions values (1329, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28946, 1329, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28947, 1329, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (1330, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28947, 1329, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1330, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28948, 1330, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28949, 1330, 'arg_1', 'month_interval', 32, 0, 1, 1); -insert into sys.functions values (1331, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28950, 1331, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (28951, 1331, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1332, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28949, 1330, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1331, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28950, 1331, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (28951, 1331, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1332, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28952, 1332, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28953, 1332, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1333, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28953, 1332, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1333, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28954, 1333, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28955, 1333, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1334, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28955, 1333, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1334, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28956, 1334, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28957, 1334, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (1335, 'dayofyear', 'dayofyear', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28958, 1335, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28959, 1335, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1336, 'weekofyear', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28957, 1334, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1335, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28958, 1335, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (28959, 1335, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (1336, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28960, 1336, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28961, 1336, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1337, 'dayofweek', 'dayofweek', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28961, 1336, 'arg_1', 'month_interval', 32, 0, 1, 1); +insert into sys.functions values (1337, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28962, 1337, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28963, 1337, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1338, 'dayofmonth', 'day', 'mtime', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28964, 1338, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28965, 1338, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1339, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28963, 1337, 'arg_1', 'month_interval', 32, 0, 1, 1); +insert into sys.functions values (1338, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28964, 1338, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (28965, 1338, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1339, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true); insert into sys.args values (28966, 1339, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28967, 1339, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (1340, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true); -insert into sys.args values (28968, 1340, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (28969, 1340, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (28970, 1340, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (1341, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28971, 1341, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (28972, 1341, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (28973, 1341, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.functions values (1342, 'restart', 'restart', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28974, 1342, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (28975, 1342, 'arg_1', 'varchar', 0, 0, 1, 1); -insert into sys.args values (28976, 1342, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (28977, 1342, 'arg_3', 'bigint', 64, 0, 1, 3); -insert into sys.functions values (1343, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28978, 1343, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (28979, 1343, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (28980, 1343, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (1344, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28981, 1344, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (28982, 1344, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (28983, 1344, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (28967, 1339, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1340, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28968, 1340, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (28969, 1340, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1341, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28970, 1341, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (28971, 1341, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (1342, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true); +insert into sys.args values (28972, 1342, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (28973, 1342, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (28974, 1342, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.functions values (1343, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28975, 1343, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (28976, 1343, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (28977, 1343, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.functions values (1344, 'restart', 'restart', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (28978, 1344, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (28979, 1344, 'arg_1', 'varchar', 0, 0, 1, 1); +insert into sys.args values (28980, 1344, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (28981, 1344, 'arg_3', 'bigint', 64, 0, 1, 3); insert into sys.functions values (1345, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28984, 1345, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28985, 1345, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (28986, 1345, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (1346, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28987, 1346, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (28988, 1346, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (1347, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28989, 1347, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28990, 1347, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (28991, 1347, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1348, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28992, 1348, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28993, 1348, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (28994, 1348, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (28995, 1348, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1349, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28996, 1349, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (28997, 1349, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (28998, 1349, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1350, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (28999, 1350, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29000, 1350, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29001, 1350, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (29002, 1350, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1351, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29003, 1351, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29004, 1351, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29005, 1351, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (29006, 1351, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1352, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29007, 1352, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29008, 1352, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29009, 1352, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (1353, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29010, 1353, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29011, 1353, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29012, 1353, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (29013, 1353, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1354, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29014, 1354, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29015, 1354, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29016, 1354, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (1355, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29017, 1355, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29018, 1355, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29019, 1355, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (29020, 1355, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (1356, 'not_like', 'not_like', 'algebra', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29021, 1356, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29022, 1356, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29023, 1356, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1357, 'not_like', 'not_like', 'algebra', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29024, 1357, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29025, 1357, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29026, 1357, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (29027, 1357, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (1358, 'not_ilike', 'not_ilike', 'algebra', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29028, 1358, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29029, 1358, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29030, 1358, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1359, 'not_ilike', 'not_ilike', 'algebra', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29031, 1359, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (29032, 1359, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29033, 1359, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (29034, 1359, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (1360, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29035, 1360, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29036, 1360, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29037, 1360, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1361, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29038, 1361, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29039, 1361, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29040, 1361, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (1362, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29041, 1362, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29042, 1362, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (29043, 1362, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (1363, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29044, 1363, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (29045, 1363, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (1364, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true); -insert into sys.args values (29046, 1364, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (29047, 1364, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.functions values (1365, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
