Changeset: 8fc91596dd29 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8fc91596dd29 Branch: Oct2020 Log Message:
merged diffs (truncated from 12297 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 @@ -3530,770 +3530,782 @@ insert into sys.args values (37359, 922, insert into sys.args values (37360, 922, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (923, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37361, 923, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37362, 923, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.args values (37362, 923, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (924, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37363, 924, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37364, 924, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.args values (37364, 924, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (925, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37365, 925, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37366, 925, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (926, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true, true); +insert into sys.args values (37366, 925, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (926, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37367, 926, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37368, 926, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37369, 926, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (927, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37370, 927, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37371, 927, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37372, 927, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (928, 'restart', 'restart', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (37373, 928, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (37374, 928, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37375, 928, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37376, 928, 'arg_3', 'bigint', 64, 0, 1, 3); -insert into sys.functions values (929, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37377, 929, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (37378, 929, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37379, 929, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (930, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37380, 930, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (37381, 930, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37382, 930, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (931, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (37383, 931, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37384, 931, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37385, 931, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (932, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37386, 932, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37387, 932, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (933, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37388, 933, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37389, 933, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37390, 933, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (934, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37391, 934, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37392, 934, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37393, 934, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37394, 934, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (935, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37395, 935, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37396, 935, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37397, 935, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (936, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37398, 936, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37399, 936, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37400, 936, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37401, 936, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (937, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37402, 937, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37403, 937, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37404, 937, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37405, 937, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (938, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37406, 938, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37407, 938, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37408, 938, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (939, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37409, 939, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37410, 939, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37411, 939, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (37412, 939, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (940, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37413, 940, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37414, 940, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37415, 940, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (941, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37416, 941, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37417, 941, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37418, 941, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (37419, 941, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (942, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37420, 942, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37421, 942, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37422, 942, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (943, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37423, 943, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37424, 943, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37425, 943, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37426, 943, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (944, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37427, 944, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37428, 944, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37429, 944, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (945, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37430, 945, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37431, 945, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37432, 945, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37433, 945, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (946, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37434, 946, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37435, 946, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37436, 946, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (947, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37437, 947, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37438, 947, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37439, 947, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37440, 947, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (948, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37441, 948, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37442, 948, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37443, 948, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (949, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (37444, 949, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (37445, 949, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37446, 949, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (37447, 949, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (950, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37448, 950, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37449, 950, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37450, 950, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (951, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37451, 951, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37452, 951, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37453, 951, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (952, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37454, 952, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37455, 952, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37456, 952, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (953, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37457, 953, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37458, 953, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (954, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37459, 954, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37460, 954, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.functions values (955, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37461, 955, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37462, 955, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (956, 'right', 'stringright', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37463, 956, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37464, 956, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37465, 956, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (957, 'left', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37466, 957, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37467, 957, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (37468, 957, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (958, 'upper', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37469, 958, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37470, 958, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (959, 'ucase', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37471, 959, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37472, 959, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (960, 'lower', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37473, 960, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37474, 960, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (961, 'lcase', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37475, 961, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (37476, 961, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (962, 'trim', 'trim', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37368, 926, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (927, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37369, 927, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37370, 927, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (928, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37371, 928, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37372, 928, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (929, 'second', 'seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37373, 929, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37374, 929, 'arg_1', 'sec_interval', 13, 0, 1, 1); +insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true, true); +insert into sys.args values (37375, 930, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37376, 930, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37377, 930, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (931, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (37378, 931, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37379, 931, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37380, 931, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (932, 'restart', 'restart', 'sql', 0, 1, true, false, false, 2000, true, true); +insert into sys.args values (37381, 932, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37382, 932, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37383, 932, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37384, 932, 'arg_3', 'bigint', 64, 0, 1, 3); +insert into sys.functions values (933, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (37385, 933, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (37386, 933, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37387, 933, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (934, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (37388, 934, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (37389, 934, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37390, 934, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (935, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (37391, 935, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37392, 935, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37393, 935, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.functions values (936, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37394, 936, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37395, 936, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.functions values (937, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37396, 937, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37397, 937, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37398, 937, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (938, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37399, 938, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37400, 938, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37401, 938, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37402, 938, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.functions values (939, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37403, 939, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37404, 939, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37405, 939, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (940, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37406, 940, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37407, 940, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37408, 940, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37409, 940, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.functions values (941, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37410, 941, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37411, 941, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37412, 941, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37413, 941, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.functions values (942, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37414, 942, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37415, 942, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37416, 942, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (943, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37417, 943, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37418, 943, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37419, 943, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (37420, 943, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.functions values (944, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37421, 944, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37422, 944, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37423, 944, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (945, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37424, 945, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37425, 945, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37426, 945, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (37427, 945, 'arg_3', 'int', 32, 0, 1, 3); +insert into sys.functions values (946, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37428, 946, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37429, 946, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37430, 946, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (947, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37431, 947, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37432, 947, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37433, 947, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37434, 947, 'arg_3', 'char', 0, 0, 1, 3); +insert into sys.functions values (948, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37435, 948, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37436, 948, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37437, 948, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (949, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37438, 949, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37439, 949, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37440, 949, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37441, 949, 'arg_3', 'char', 0, 0, 1, 3); +insert into sys.functions values (950, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37442, 950, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37443, 950, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37444, 950, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (951, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37445, 951, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37446, 951, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37447, 951, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37448, 951, 'arg_3', 'char', 0, 0, 1, 3); +insert into sys.functions values (952, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37449, 952, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37450, 952, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37451, 952, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (953, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); +insert into sys.args values (37452, 953, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (37453, 953, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37454, 953, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.args values (37455, 953, 'arg_3', 'char', 0, 0, 1, 3); +insert into sys.functions values (954, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37456, 954, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37457, 954, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37458, 954, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (955, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37459, 955, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37460, 955, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37461, 955, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (956, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37462, 956, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37463, 956, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.args values (37464, 956, 'arg_2', 'char', 0, 0, 1, 2); +insert into sys.functions values (957, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37465, 957, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37466, 957, 'arg_1', 'char', 0, 0, 1, 1); +insert into sys.functions values (958, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37467, 958, 'res_0', 'char', 0, 0, 0, 0); +insert into sys.args values (37468, 958, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.functions values (959, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37469, 959, 'res_0', 'int', 32, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
