Changeset: 65cb235531d4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=65cb235531d4 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit Branch: Oct2020 Log Message:
Approved 32-bit outputs diffs (truncated from 13736 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out @@ -2814,865 +2814,886 @@ insert into sys.args values (32924, 736, insert into sys.functions values (737, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32925, 737, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32926, 737, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (738, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32927, 738, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32928, 738, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (739, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (738, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32927, 738, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (32928, 738, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (739, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32929, 739, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32930, 739, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (740, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32931, 740, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (740, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32931, 740, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32932, 740, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (741, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32933, 741, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32934, 741, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (742, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32935, 742, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32936, 742, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (743, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32937, 743, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (741, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32933, 741, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (32934, 741, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (742, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32935, 742, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (32936, 742, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (743, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32937, 743, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32938, 743, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (744, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (744, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32939, 744, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32940, 744, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (745, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32941, 745, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32942, 745, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (746, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32943, 746, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32944, 746, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (747, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32940, 744, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (745, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32941, 745, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (32942, 745, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (746, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32943, 746, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (32944, 746, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (747, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32945, 747, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32946, 747, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (748, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (748, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32947, 748, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32948, 748, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (749, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (749, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32949, 749, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32950, 749, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (750, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (750, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32951, 750, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32952, 750, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (751, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (751, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32953, 751, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32954, 751, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (752, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32955, 752, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (752, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32955, 752, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32956, 752, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (753, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (753, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32957, 753, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32958, 753, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (754, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32958, 753, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (754, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32959, 754, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32960, 754, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (755, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32961, 755, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32962, 755, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (756, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32963, 756, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32964, 756, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (757, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32960, 754, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (755, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32961, 755, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (32962, 755, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (756, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32963, 756, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (32964, 756, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (757, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32965, 757, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32966, 757, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (758, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (758, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32967, 758, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32968, 758, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (759, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (759, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32969, 759, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32970, 759, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (760, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (760, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32971, 760, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32972, 760, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (761, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32973, 761, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (761, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32973, 761, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (32974, 761, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (762, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (762, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32975, 762, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32976, 762, 'arg_1', 'month_interval', 3, 0, 1, 1); -insert into sys.functions values (763, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32976, 762, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (763, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32977, 763, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32978, 763, 'arg_1', 'month_interval', 3, 0, 1, 1); -insert into sys.functions values (764, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32979, 764, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (32980, 764, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.functions values (765, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32981, 765, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32982, 765, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.functions values (766, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32983, 766, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32984, 766, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.functions values (767, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32978, 763, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (764, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32979, 764, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (32980, 764, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (765, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32981, 765, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (32982, 765, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (766, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32983, 766, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (32984, 766, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (767, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32985, 767, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32986, 767, 'arg_1', 'day_interval', 4, 0, 1, 1); -insert into sys.functions values (768, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32987, 768, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (32988, 768, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (769, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (32989, 769, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32990, 769, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (770, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32986, 767, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (768, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32987, 768, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (32988, 768, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (769, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32989, 769, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (32990, 769, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (770, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32991, 770, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32992, 770, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (771, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (32992, 770, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (771, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (32993, 771, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32994, 771, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (772, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (32995, 772, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (32996, 772, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (32997, 772, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (773, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (32998, 773, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (32999, 773, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33000, 773, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (774, 'restart', 'restart', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (33001, 774, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (33002, 774, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33003, 774, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33004, 774, 'arg_3', 'bigint', 64, 0, 1, 3); -insert into sys.functions values (775, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (33005, 775, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (33006, 775, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33007, 775, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (776, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (33008, 776, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (33009, 776, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33010, 776, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (777, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (33011, 777, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33012, 777, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33013, 777, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (778, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33014, 778, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33015, 778, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (779, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33016, 779, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33017, 779, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33018, 779, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (780, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33019, 780, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33020, 780, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33021, 780, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33022, 780, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (781, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33023, 781, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33024, 781, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33025, 781, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (782, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33026, 782, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33027, 782, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33028, 782, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33029, 782, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (783, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33030, 783, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33031, 783, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33032, 783, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33033, 783, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (784, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33034, 784, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33035, 784, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33036, 784, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (785, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33037, 785, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33038, 785, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33039, 785, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (33040, 785, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (786, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33041, 786, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33042, 786, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33043, 786, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (787, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33044, 787, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33045, 787, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33046, 787, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (33047, 787, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (788, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33048, 788, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33049, 788, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33050, 788, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (789, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33051, 789, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33052, 789, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33053, 789, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33054, 789, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (790, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33055, 790, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33056, 790, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33057, 790, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (791, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33058, 791, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33059, 791, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33060, 791, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33061, 791, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (792, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33062, 792, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33063, 792, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33064, 792, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (793, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33065, 793, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33066, 793, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33067, 793, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33068, 793, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (794, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33069, 794, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33070, 794, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33071, 794, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (795, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33072, 795, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33073, 795, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33074, 795, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33075, 795, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (796, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33076, 796, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33077, 796, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33078, 796, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (797, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33079, 797, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33080, 797, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33081, 797, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (798, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33082, 798, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33083, 798, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33084, 798, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (799, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33085, 799, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33086, 799, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (800, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33087, 800, 'res_0', 'char', 0, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
