Changeset: ef76e9701106 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ef76e9701106 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit 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 sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: Oct2020 Log Message:
Approved upgrade diffs (truncated from 14153 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 @@ -3447,865 +3447,886 @@ insert into sys.args values (37304, 894, insert into sys.functions values (895, 'week', 'weekofyear', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37305, 895, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37306, 895, 'arg_1', 'date', 0, 0, 1, 1); -insert into sys.functions values (896, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37307, 896, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37308, 896, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (897, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (896, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37307, 896, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37308, 896, 'arg_1', 'date', 0, 0, 1, 1); +insert into sys.functions values (897, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37309, 897, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37310, 897, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (898, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37311, 898, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (898, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37311, 898, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37312, 898, 'arg_1', 'time', 7, 0, 1, 1); -insert into sys.functions values (899, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37313, 899, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37314, 899, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (900, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37315, 900, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37316, 900, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (901, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37317, 901, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (899, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37313, 899, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37314, 899, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (900, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37315, 900, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37316, 900, 'arg_1', 'time', 7, 0, 1, 1); +insert into sys.functions values (901, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37317, 901, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37318, 901, 'arg_1', 'timetz', 7, 0, 1, 1); -insert into sys.functions values (902, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (902, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37319, 902, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37320, 902, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (903, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37321, 903, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37322, 903, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (904, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37323, 904, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37324, 904, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (905, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37320, 902, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (903, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37321, 903, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37322, 903, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (904, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37323, 904, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37324, 904, 'arg_1', 'timetz', 7, 0, 1, 1); +insert into sys.functions values (905, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37325, 905, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37326, 905, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (906, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (906, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37327, 906, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37328, 906, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (907, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (907, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37329, 907, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37330, 907, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (908, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (908, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37331, 908, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37332, 908, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (909, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (909, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37333, 909, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37334, 909, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (910, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37335, 910, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (910, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37335, 910, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37336, 910, 'arg_1', 'timestamp', 7, 0, 1, 1); -insert into sys.functions values (911, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (911, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37337, 911, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37338, 911, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (912, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37338, 911, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (912, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37339, 912, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37340, 912, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (913, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37341, 913, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37342, 913, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (914, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37343, 914, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37344, 914, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (915, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37340, 912, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (913, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37341, 913, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37342, 913, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (914, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37343, 914, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37344, 914, 'arg_1', 'timestamp', 7, 0, 1, 1); +insert into sys.functions values (915, 'century', 'century', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37345, 915, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37346, 915, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (916, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (916, 'decade', 'decade', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37347, 916, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37348, 916, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (917, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (917, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37349, 917, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37350, 917, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (918, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (918, 'quarter', 'quarter', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37351, 918, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37352, 918, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (919, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37353, 919, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.functions values (919, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37353, 919, 'res_0', 'int', 32, 0, 0, 0); insert into sys.args values (37354, 919, 'arg_1', 'timestamptz', 7, 0, 1, 1); -insert into sys.functions values (920, 'year', 'year', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.functions values (920, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37355, 920, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37356, 920, 'arg_1', 'month_interval', 3, 0, 1, 1); -insert into sys.functions values (921, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37356, 920, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (921, 'hour', 'hours', 'mtime', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37357, 921, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (37358, 921, 'arg_1', 'month_interval', 3, 0, 1, 1); -insert into sys.functions values (922, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (37359, 922, 'res_0', 'bigint', 64, 0, 0, 0); -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', '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', '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 (37358, 921, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (922, 'minute', 'minutes', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37359, 922, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37360, 922, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (923, 'second', 'sql_seconds', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37361, 923, 'res_0', 'decimal', 9, 6, 0, 0); +insert into sys.args values (37362, 923, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (924, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37363, 924, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37364, 924, 'arg_1', 'timestamptz', 7, 0, 1, 1); +insert into sys.functions values (925, 'year', 'year', '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', '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', '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 (37366, 925, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (926, 'month', 'month', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37367, 926, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (37368, 926, 'arg_1', 'month_interval', 3, 0, 1, 1); +insert into sys.functions values (927, 'day', 'day', 'mtime', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (37369, 927, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (37370, 927, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (928, 'hour', 'hours', '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 (37372, 928, 'arg_1', 'day_interval', 4, 0, 1, 1); +insert into sys.functions values (929, 'minute', 'minutes', '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); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
