Changeset: 820212b05122 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=820212b05122 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 upgrade tests diffs (truncated from 12192 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 @@ -2897,770 +2897,782 @@ insert into sys.args values (32979, 764, 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', 'sec_interval', 13, 0, 1, 1); +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', 'sec_interval', 13, 0, 1, 1); +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 (32985, 767, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (32986, 767, 'arg_1', 'sec_interval', 13, 0, 1, 1); -insert into sys.functions values (768, 'next_value_for', 'next_value', 'sql', 0, 1, true, false, false, 2000, true, true); +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', 'char', 0, 0, 1, 1); -insert into sys.args values (32989, 768, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (769, 'get_value_for', 'get_value', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (32990, 769, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (32991, 769, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (32992, 769, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (770, 'restart', 'restart', 'sql', 0, 1, true, false, false, 2000, true, true); -insert into sys.args values (32993, 770, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (32994, 770, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (32995, 770, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (32996, 770, 'arg_3', 'bigint', 64, 0, 1, 3); -insert into sys.functions values (771, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (32997, 771, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (32998, 771, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (32999, 771, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (772, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (33000, 772, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (33001, 772, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33002, 772, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (773, 'index', 'index', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (33003, 773, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33004, 773, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33005, 773, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (774, 'strings', 'strings', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33006, 774, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33007, 774, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (775, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33008, 775, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33009, 775, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33010, 775, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (776, 'locate', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33011, 776, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33012, 776, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33013, 776, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33014, 776, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (777, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33015, 777, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33016, 777, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33017, 777, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (778, 'charindex', 'locate', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33018, 778, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33019, 778, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33020, 778, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33021, 778, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (779, 'splitpart', 'splitpart', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33022, 779, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33023, 779, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33024, 779, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33025, 779, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (780, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33026, 780, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33027, 780, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33028, 780, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (781, 'substring', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33029, 781, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33030, 781, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33031, 781, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (33032, 781, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (782, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33033, 782, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33034, 782, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33035, 782, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (783, 'substr', 'substring', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33036, 783, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33037, 783, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33038, 783, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (33039, 783, 'arg_3', 'int', 32, 0, 1, 3); -insert into sys.functions values (784, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33040, 784, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33041, 784, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33042, 784, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (785, 'like', 'like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33043, 785, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33044, 785, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33045, 785, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33046, 785, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (786, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33047, 786, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33048, 786, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33049, 786, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (787, 'ilike', 'ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33050, 787, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33051, 787, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33052, 787, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33053, 787, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (788, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33054, 788, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33055, 788, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33056, 788, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (789, 'not_like', 'not_like', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33057, 789, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33058, 789, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33059, 789, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33060, 789, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (790, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33061, 790, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33062, 790, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33063, 790, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (791, 'not_ilike', 'not_ilike', 'algebra', 0, 4, false, false, false, 2000, true, false); -insert into sys.args values (33064, 791, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (33065, 791, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33066, 791, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.args values (33067, 791, 'arg_3', 'char', 0, 0, 1, 3); -insert into sys.functions values (792, 'patindex', 'patindex', 'pcre', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33068, 792, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33069, 792, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33070, 792, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (793, 'truncate', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33071, 793, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33072, 793, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33073, 793, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (794, 'concat', '+', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33074, 794, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33075, 794, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33076, 794, 'arg_2', 'char', 0, 0, 1, 2); -insert into sys.functions values (795, 'ascii', 'ascii', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33077, 795, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33078, 795, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (796, 'code', 'unicode', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33079, 796, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33080, 796, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.functions values (797, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33081, 797, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (33082, 797, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (798, 'right', 'stringright', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33083, 798, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33084, 798, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33085, 798, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (799, 'left', 'stringleft', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33086, 799, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33087, 799, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.args values (33088, 799, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (800, 'upper', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33089, 800, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33090, 800, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (801, 'ucase', 'toUpper', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33091, 801, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33092, 801, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (802, 'lower', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33093, 802, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33094, 802, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (803, 'lcase', 'toLower', 'str', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (33095, 803, 'res_0', 'char', 0, 0, 0, 0); -insert into sys.args values (33096, 803, 'arg_1', 'char', 0, 0, 1, 1); -insert into sys.functions values (804, 'trim', 'trim', 'str', 0, 1, false, false, false, 2000, true, false); +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 (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 (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); +insert into sys.args values (33088, 800, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.functions values (801, 'length', 'length', 'str', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (33089, 801, 'res_0', 'int', 32, 0, 0, 0); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
