Changeset: 747cd6f5ea24 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/747cd6f5ea24 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out 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.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.int128 Branch: default Log Message:
Approvals. diffs (truncated from 430 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 @@ -1048,7 +1048,7 @@ insert into sys.functions values (284, ' insert into sys.args values (42153, 284, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (42154, 284, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (42155, 284, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (42156, 285, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (42157, 285, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (286, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1073,7 +1073,7 @@ insert into sys.functions values (291, ' insert into sys.args values (42171, 291, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (42172, 291, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (42173, 291, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (42174, 292, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (42175, 292, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (293, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1098,7 +1098,7 @@ insert into sys.functions values (298, ' insert into sys.args values (42189, 298, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (42190, 298, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (42191, 298, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (42192, 299, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (42193, 299, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (300, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); 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 @@ -953,7 +953,7 @@ insert into sys.functions values (260, ' insert into sys.args values (37245, 260, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (37246, 260, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (37247, 260, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (261, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (261, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37248, 261, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (37249, 261, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (262, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -978,7 +978,7 @@ insert into sys.functions values (267, ' insert into sys.args values (37263, 267, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (37264, 267, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (37265, 267, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (268, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (268, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37266, 268, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (37267, 268, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (269, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1003,7 +1003,7 @@ insert into sys.functions values (274, ' insert into sys.args values (37281, 274, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (37282, 274, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (37283, 274, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (275, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (275, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37284, 275, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (37285, 275, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (276, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -1048,7 +1048,7 @@ insert into sys.functions values (284, ' insert into sys.args values (37316, 284, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (37317, 284, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (37318, 284, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37319, 285, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (37320, 285, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (286, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1073,7 +1073,7 @@ insert into sys.functions values (291, ' insert into sys.args values (37334, 291, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (37335, 291, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (37336, 291, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37337, 292, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (37338, 292, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (293, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1098,7 +1098,7 @@ insert into sys.functions values (298, ' insert into sys.args values (37352, 298, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (37353, 298, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (37354, 298, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37355, 299, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (37356, 299, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (300, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 @@ -1048,7 +1048,7 @@ insert into sys.functions values (284, ' insert into sys.args values (8921, 284, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (8922, 284, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (8923, 284, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8924, 285, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (8925, 285, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (286, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1073,7 +1073,7 @@ insert into sys.functions values (291, ' insert into sys.args values (8939, 291, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (8940, 291, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (8941, 291, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8942, 292, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (8943, 292, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (293, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1098,7 +1098,7 @@ insert into sys.functions values (298, ' insert into sys.args values (8957, 298, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (8958, 298, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (8959, 298, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8960, 299, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (8961, 299, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (300, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out @@ -953,7 +953,7 @@ insert into sys.functions values (260, ' insert into sys.args values (8292, 260, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (8293, 260, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (8294, 260, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (261, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (261, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8295, 261, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (8296, 261, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (262, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -978,7 +978,7 @@ insert into sys.functions values (267, ' insert into sys.args values (8310, 267, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (8311, 267, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (8312, 267, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (268, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (268, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8313, 268, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (8314, 268, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (269, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1003,7 +1003,7 @@ insert into sys.functions values (274, ' insert into sys.args values (8328, 274, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (8329, 274, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (8330, 274, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (275, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (275, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8331, 275, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (8332, 275, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (276, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 @@ -1048,7 +1048,7 @@ insert into sys.functions values (284, ' insert into sys.args values (8363, 284, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (8364, 284, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (8365, 284, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8366, 285, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (8367, 285, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (286, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1073,7 +1073,7 @@ insert into sys.functions values (291, ' insert into sys.args values (8381, 291, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (8382, 291, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (8383, 291, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8384, 292, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (8385, 292, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (293, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1098,7 +1098,7 @@ insert into sys.functions values (298, ' insert into sys.args values (8399, 298, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (8400, 298, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (8401, 298, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (8402, 299, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (8403, 299, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (300, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -3484,16 +3484,16 @@ drop function pcre_replace(string, strin [ "sys.functions", "sys", "sql_mul", "SYSTEM", "*", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "tinyint", 8, 0, "in", "arg_2", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_mul", "SYSTEM", "*", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "tinyint", 8, 0, "in", "arg_2", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "day_interval", 4, 0, "out", "arg_1", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "day_interval", 4, 0, "out", "arg_1", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 2, 0, "out", "arg_1", "decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 4, 0, "out", "arg_1", "decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 9, 0, "out", "arg_1", "decimal", 9, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 18, 0, "out", "arg_1", "decimal", 18, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "month_interval", 3, 0, "out", "arg_1", "month_interval", 3, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "month_interval", 3, 0, "out", "arg_1", "month_interval", 3, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "sec_interval", 13, 0, "out", "arg_1", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "sec_interval", 13, 0, "out", "arg_1", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_not_anyequal", "SYSTEM", "not_anyequal", "aggr", "Internal C", "Scalar function", false, false, false, true, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit b/sql/test/emptydb/Tests/check.stable.out.32bit --- a/sql/test/emptydb/Tests/check.stable.out.32bit +++ b/sql/test/emptydb/Tests/check.stable.out.32bit @@ -3484,16 +3484,16 @@ drop function pcre_replace(string, strin [ "sys.functions", "sys", "sql_mul", "SYSTEM", "*", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "tinyint", 8, 0, "in", "arg_2", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_mul", "SYSTEM", "*", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "tinyint", 8, 0, "in", "arg_2", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "day_interval", 4, 0, "out", "arg_1", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "day_interval", 4, 0, "out", "arg_1", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 2, 0, "out", "arg_1", "decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 4, 0, "out", "arg_1", "decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 9, 0, "out", "arg_1", "decimal", 9, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 18, 0, "out", "arg_1", "decimal", 18, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "month_interval", 3, 0, "out", "arg_1", "month_interval", 3, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "month_interval", 3, 0, "out", "arg_1", "month_interval", 3, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "sec_interval", 13, 0, "out", "arg_1", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "sec_interval", 13, 0, "out", "arg_1", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_not_anyequal", "SYSTEM", "not_anyequal", "aggr", "Internal C", "Scalar function", false, false, false, true, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] diff --git a/sql/test/emptydb/Tests/check.stable.out.int128 b/sql/test/emptydb/Tests/check.stable.out.int128 --- a/sql/test/emptydb/Tests/check.stable.out.int128 +++ b/sql/test/emptydb/Tests/check.stable.out.int128 @@ -3656,7 +3656,7 @@ drop function pcre_replace(string, strin [ "sys.functions", "sys", "sql_mul", "SYSTEM", "*", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "tinyint", 8, 0, "in", "arg_2", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_mul", "SYSTEM", "*", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "tinyint", 8, 0, "in", "arg_2", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "day_interval", 4, 0, "out", "arg_1", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "day_interval", 4, 0, "out", "arg_1", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 2, 0, "out", "arg_1", "decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 4, 0, "out", "arg_1", "decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "decimal", 9, 0, "out", "arg_1", "decimal", 9, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -3665,9 +3665,9 @@ drop function pcre_replace(string, strin [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "month_interval", 3, 0, "out", "arg_1", "month_interval", 3, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "month_interval", 3, 0, "out", "arg_1", "month_interval", 3, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] -[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, true, "res_0", "sec_interval", 13, 0, "out", "arg_1", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] +[ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "sec_interval", 13, 0, "out", "arg_1", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_neg", "SYSTEM", "-", "calc", "Internal C", "Scalar function", false, false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "sql_not_anyequal", "SYSTEM", "not_anyequal", "aggr", "Internal C", "Scalar function", false, false, false, true, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -1048,7 +1048,7 @@ insert into sys.functions values (284, ' insert into sys.args values (42455, 284, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (42456, 284, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (42457, 284, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (285, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (42458, 285, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (42459, 285, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (286, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1073,7 +1073,7 @@ insert into sys.functions values (291, ' insert into sys.args values (42473, 291, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (42474, 291, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (42475, 291, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (292, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (42476, 292, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (42477, 292, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.functions values (293, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -1098,7 +1098,7 @@ insert into sys.functions values (298, ' insert into sys.args values (42491, 298, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (42492, 298, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.args values (42493, 298, 'arg_2', 'sec_interval', 13, 0, 1, 2); -insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (299, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (42494, 299, 'res_0', 'sec_interval', 13, 0, 0, 0); insert into sys.args values (42495, 299, 'arg_1', 'sec_interval', 13, 0, 1, 1); insert into sys.functions values (300, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out @@ -953,7 +953,7 @@ insert into sys.functions values (260, ' insert into sys.args values (37988, 260, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (37989, 260, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.args values (37990, 260, 'arg_2', 'month_interval', 3, 0, 1, 2); -insert into sys.functions values (261, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (261, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (37991, 261, 'res_0', 'month_interval', 3, 0, 0, 0); insert into sys.args values (37992, 261, 'arg_1', 'month_interval', 3, 0, 1, 1); insert into sys.functions values (262, 'abs', 'abs', 'calc', 0, 1, false, false, false, 2000, true, false); @@ -978,7 +978,7 @@ insert into sys.functions values (267, ' insert into sys.args values (38006, 267, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (38007, 267, 'arg_1', 'day_interval', 4, 0, 1, 1); insert into sys.args values (38008, 267, 'arg_2', 'day_interval', 4, 0, 1, 2); -insert into sys.functions values (268, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, true); +insert into sys.functions values (268, 'sql_neg', '-', 'calc', 0, 1, false, false, false, 2000, true, false); insert into sys.args values (38009, 268, 'res_0', 'day_interval', 4, 0, 0, 0); insert into sys.args values (38010, 268, 'arg_1', 'day_interval', 4, 0, 1, 1); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
