Changeset: 6939123d7753 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6939123d7753 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 Branch: default Log Message:
Approve after adding sys.all function. diffs (truncated from 360 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -415,6 +415,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1775,6 +1776,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3400,6 +3402,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8492,6 +8496,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/clients/Tests/SQL-dump.stable.out.int128 b/clients/Tests/SQL-dump.stable.out.int128 --- a/clients/Tests/SQL-dump.stable.out.int128 +++ b/clients/Tests/SQL-dump.stable.out.int128 @@ -411,6 +411,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1784,6 +1785,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3598,6 +3600,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -9240,6 +9244,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1621,6 +1622,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3428,6 +3430,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8981,6 +8985,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1608,6 +1609,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3226,6 +3228,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8229,6 +8233,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1621,6 +1622,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3428,6 +3430,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8981,6 +8985,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1621,6 +1622,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3428,6 +3430,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8981,6 +8985,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/sql/test/emptydb-upgrade/Tests/check.stable.out b/sql/test/emptydb-upgrade/Tests/check.stable.out --- a/sql/test/emptydb-upgrade/Tests/check.stable.out +++ b/sql/test/emptydb-upgrade/Tests/check.stable.out @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1608,6 +1609,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3226,6 +3228,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8229,6 +8233,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] diff --git a/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1621,6 +1622,7 @@ drop function pcre_replace(string, strin [ "sys", "abs", "abs", "calc", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] [ "sys", "acos", "acos", "mmath", 0, 1, false, false, false ] +[ "sys", "all", "all", "sql", 0, 3, false, false, false ] [ "sys", "alpha", "create function alpha(pdec double, pradius double) returns double external name sql.alpha;", "sql", 1, 1, false, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint) external name sql.analyze;", "sql", 1, 2, true, false, false ] [ "sys", "analyze", "create procedure sys.analyze(minmax int, \"sample\" bigint, sch string) external name sql.analyze;", "sql", 1, 2, true, false, false ] @@ -3428,6 +3430,8 @@ drop function pcre_replace(string, strin [ "acos", "arg_1", "real", 24, 0, 1, 1 ] [ "acos", "res_0", "double", 53, 0, 0, 0 ] [ "acos", "arg_1", "double", 53, 0, 1, 1 ] +[ "all", "res", "any", 0, 0, 0, 0 ] +[ "all", "arg", "any", 0, 0, 1, 1 ] [ "alpha", "result", "double", 53, 0, 0, 0 ] [ "alpha", "pdec", "double", 53, 0, 1, 1 ] [ "alpha", "pradius", "double", 53, 0, 1, 2 ] @@ -8981,6 +8985,7 @@ drop function pcre_replace(string, strin [ "abs" ] [ "acos" ] [ "acos" ] +[ "all" ] [ "alpha" ] [ "analyze" ] [ "analyze" ] 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 @@ -362,6 +362,7 @@ SYSTEM FUNCTION sys.>= SYSTEM FUNCTION sys.abbrev SYSTEM FUNCTION sys.abs SYSTEM FUNCTION sys.acos +SYSTEM FUNCTION sys.all SYSTEM FUNCTION sys.alpha SYSTEM FUNCTION sys.analyze SYSTEM FUNCTION sys.and @@ -1608,6 +1609,7 @@ drop function pcre_replace(string, strin _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
