Changeset: e5bd60bc9f7e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e5bd60bc9f7e Modified Files: sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 Branch: Jun2016 Log Message:
Approve output after changeset 604ae9397192. diffs (truncated from 8082 to 300 lines): diff --git a/sql/test/Tests/systemfunctions.stable.out b/sql/test/Tests/systemfunctions.stable.out --- a/sql/test/Tests/systemfunctions.stable.out +++ b/sql/test/Tests/systemfunctions.stable.out @@ -58,7 +58,7 @@ Ready. % sys.L3, sys.L3, sys.L3, sys.L3, sys.L3 # table_name % schema, function, argno, argtype, definition # name % varchar, varchar, int, varchar, varchar # type -% 8, 35, 2, 12, 608 # length +% 8, 35, 2, 14, 608 # length [ "bam", "bam_drop_file", 0, "bigint", "create procedure bam.bam_drop_file(file_id bigint, dbschema smallint)\nexternal name bam.bam_drop_file;" ] [ "bam", "bam_drop_file", 1, "smallint", "" ] [ "bam", "bam_export", 0, "clob", "create procedure bam.bam_export(output_path string)\nexternal name bam.bam_export;" ] @@ -136,8 +136,58 @@ Ready. [ "profiler", "setpoolsize", 0, "int", "create procedure profiler.setpoolsize(poolsize int) external name profiler.setpoolsize;" ] [ "profiler", "setstream", 0, "clob", "create procedure profiler.setstream(host string, port int) external name profiler.setstream;" ] [ "profiler", "setstream", 1, "int", "" ] +[ "sys", "<", 0, "boolean", "<" ] +[ "sys", "<", 1, "any", "" ] +[ "sys", "<", 2, "any", "" ] +[ "sys", "<=", 0, "boolean", "<=" ] +[ "sys", "<=", 1, "any", "" ] +[ "sys", "<=", 2, "any", "" ] +[ "sys", "<>", 0, "boolean", "!=" ] +[ "sys", "<>", 1, "any", "" ] +[ "sys", "<>", 2, "any", "" ] +[ "sys", "=", 0, "boolean", "=" ] +[ "sys", "=", 1, "any", "" ] +[ "sys", "=", 2, "any", "" ] +[ "sys", ">", 0, "boolean", ">" ] +[ "sys", ">", 1, "any", "" ] +[ "sys", ">", 2, "any", "" ] +[ "sys", ">=", 0, "boolean", ">=" ] +[ "sys", ">=", 1, "any", "" ] +[ "sys", ">=", 2, "any", "" ] [ "sys", "abbrev", 0, "clob", "create function \"abbrev\" (p inet) returns clob\n external name inet.\"abbrev\";" ] [ "sys", "abbrev", 1, "inet", "" ] +[ "sys", "abs", 0, "oid", "abs" ] +[ "sys", "abs", 1, "oid", "" ] +[ "sys", "abs", 0, "tinyint", "abs" ] +[ "sys", "abs", 1, "tinyint", "" ] +[ "sys", "abs", 0, "smallint", "abs" ] +[ "sys", "abs", 1, "smallint", "" ] +[ "sys", "abs", 0, "int", "abs" ] +[ "sys", "abs", 1, "int", "" ] +[ "sys", "abs", 0, "bigint", "abs" ] +[ "sys", "abs", 1, "bigint", "" ] +[ "sys", "abs", 0, "wrd", "abs" ] +[ "sys", "abs", 1, "wrd", "" ] +[ "sys", "abs", 0, "decimal", "abs" ] +[ "sys", "abs", 1, "decimal", "" ] +[ "sys", "abs", 0, "decimal", "abs" ] +[ "sys", "abs", 1, "decimal", "" ] +[ "sys", "abs", 0, "decimal", "abs" ] +[ "sys", "abs", 1, "decimal", "" ] +[ "sys", "abs", 0, "decimal", "abs" ] +[ "sys", "abs", 1, "decimal", "" ] +[ "sys", "abs", 0, "real", "abs" ] +[ "sys", "abs", 1, "real", "" ] +[ "sys", "abs", 0, "double", "abs" ] +[ "sys", "abs", 1, "double", "" ] +[ "sys", "abs", 0, "month_interval", "abs" ] +[ "sys", "abs", 1, "month_interval", "" ] +[ "sys", "abs", 0, "sec_interval", "abs" ] +[ "sys", "abs", 1, "sec_interval", "" ] +[ "sys", "acos", 0, "real", "acos" ] +[ "sys", "acos", 1, "real", "" ] +[ "sys", "acos", 0, "double", "acos" ] +[ "sys", "acos", 1, "double", "" ] [ "sys", "alpha", 0, "double", "create function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] [ "sys", "alpha", 1, "double", "" ] [ "sys", "alpha", 2, "double", "" ] @@ -155,6 +205,31 @@ Ready. [ "sys", "analyze", 2, "clob", "" ] [ "sys", "analyze", 3, "clob", "" ] [ "sys", "analyze", 4, "clob", "" ] +[ "sys", "and", 0, "boolean", "and" ] +[ "sys", "and", 1, "boolean", "" ] +[ "sys", "and", 2, "boolean", "" ] +[ "sys", "ascii", 0, "int", "ascii" ] +[ "sys", "ascii", 1, "char", "" ] +[ "sys", "ascii", 0, "int", "ascii" ] +[ "sys", "ascii", 1, "varchar", "" ] +[ "sys", "ascii", 0, "int", "ascii" ] +[ "sys", "ascii", 1, "clob", "" ] +[ "sys", "asin", 0, "real", "asin" ] +[ "sys", "asin", 1, "real", "" ] +[ "sys", "asin", 0, "double", "asin" ] +[ "sys", "asin", 1, "double", "" ] +[ "sys", "atan", 0, "real", "atan" ] +[ "sys", "atan", 1, "real", "" ] +[ "sys", "atan", 0, "real", "atan2" ] +[ "sys", "atan", 1, "real", "" ] +[ "sys", "atan", 2, "real", "" ] +[ "sys", "atan", 0, "double", "atan" ] +[ "sys", "atan", 1, "double", "" ] +[ "sys", "atan", 0, "double", "atan2" ] +[ "sys", "atan", 1, "double", "" ] +[ "sys", "atan", 2, "double", "" ] +[ "sys", "avg", 0, "double", "avg" ] +[ "sys", "avg", 1, "double", "" ] [ "sys", "bbp", 0, "int", "create function sys.bbp ()\n returns table (id int, name string, \n ttype string, count bigint, refcnt int, lrefcnt int,\n location string, heat int, dirty string,\n status string, kind string)\n external name bbp.get;" ] [ "sys", "bbp", 1, "clob", "" ] [ "sys", "bbp", 2, "clob", "" ] @@ -166,19 +241,198 @@ Ready. [ "sys", "bbp", 8, "clob", "" ] [ "sys", "bbp", 9, "clob", "" ] [ "sys", "bbp", 10, "clob", "" ] +[ "sys", "bit_and", 0, "oid", "and" ] +[ "sys", "bit_and", 1, "oid", "" ] +[ "sys", "bit_and", 2, "oid", "" ] +[ "sys", "bit_and", 0, "tinyint", "and" ] +[ "sys", "bit_and", 1, "tinyint", "" ] +[ "sys", "bit_and", 2, "tinyint", "" ] +[ "sys", "bit_and", 0, "smallint", "and" ] +[ "sys", "bit_and", 1, "smallint", "" ] +[ "sys", "bit_and", 2, "smallint", "" ] +[ "sys", "bit_and", 0, "int", "and" ] +[ "sys", "bit_and", 1, "int", "" ] +[ "sys", "bit_and", 2, "int", "" ] +[ "sys", "bit_and", 0, "bigint", "and" ] +[ "sys", "bit_and", 1, "bigint", "" ] +[ "sys", "bit_and", 2, "bigint", "" ] +[ "sys", "bit_and", 0, "wrd", "and" ] +[ "sys", "bit_and", 1, "wrd", "" ] +[ "sys", "bit_and", 2, "wrd", "" ] +[ "sys", "bit_and", 0, "decimal", "and" ] +[ "sys", "bit_and", 1, "decimal", "" ] +[ "sys", "bit_and", 2, "decimal", "" ] +[ "sys", "bit_and", 0, "decimal", "and" ] +[ "sys", "bit_and", 1, "decimal", "" ] +[ "sys", "bit_and", 2, "decimal", "" ] +[ "sys", "bit_and", 0, "decimal", "and" ] +[ "sys", "bit_and", 1, "decimal", "" ] +[ "sys", "bit_and", 2, "decimal", "" ] +[ "sys", "bit_and", 0, "decimal", "and" ] +[ "sys", "bit_and", 1, "decimal", "" ] +[ "sys", "bit_and", 2, "decimal", "" ] +[ "sys", "bit_not", 0, "oid", "not" ] +[ "sys", "bit_not", 1, "oid", "" ] +[ "sys", "bit_not", 0, "tinyint", "not" ] +[ "sys", "bit_not", 1, "tinyint", "" ] +[ "sys", "bit_not", 0, "smallint", "not" ] +[ "sys", "bit_not", 1, "smallint", "" ] +[ "sys", "bit_not", 0, "int", "not" ] +[ "sys", "bit_not", 1, "int", "" ] +[ "sys", "bit_not", 0, "bigint", "not" ] +[ "sys", "bit_not", 1, "bigint", "" ] +[ "sys", "bit_not", 0, "wrd", "not" ] +[ "sys", "bit_not", 1, "wrd", "" ] +[ "sys", "bit_not", 0, "decimal", "not" ] +[ "sys", "bit_not", 1, "decimal", "" ] +[ "sys", "bit_not", 0, "decimal", "not" ] +[ "sys", "bit_not", 1, "decimal", "" ] +[ "sys", "bit_not", 0, "decimal", "not" ] +[ "sys", "bit_not", 1, "decimal", "" ] +[ "sys", "bit_not", 0, "decimal", "not" ] +[ "sys", "bit_not", 1, "decimal", "" ] +[ "sys", "bit_or", 0, "oid", "or" ] +[ "sys", "bit_or", 1, "oid", "" ] +[ "sys", "bit_or", 2, "oid", "" ] +[ "sys", "bit_or", 0, "tinyint", "or" ] +[ "sys", "bit_or", 1, "tinyint", "" ] +[ "sys", "bit_or", 2, "tinyint", "" ] +[ "sys", "bit_or", 0, "smallint", "or" ] +[ "sys", "bit_or", 1, "smallint", "" ] +[ "sys", "bit_or", 2, "smallint", "" ] +[ "sys", "bit_or", 0, "int", "or" ] +[ "sys", "bit_or", 1, "int", "" ] +[ "sys", "bit_or", 2, "int", "" ] +[ "sys", "bit_or", 0, "bigint", "or" ] +[ "sys", "bit_or", 1, "bigint", "" ] +[ "sys", "bit_or", 2, "bigint", "" ] +[ "sys", "bit_or", 0, "wrd", "or" ] +[ "sys", "bit_or", 1, "wrd", "" ] +[ "sys", "bit_or", 2, "wrd", "" ] +[ "sys", "bit_or", 0, "decimal", "or" ] +[ "sys", "bit_or", 1, "decimal", "" ] +[ "sys", "bit_or", 2, "decimal", "" ] +[ "sys", "bit_or", 0, "decimal", "or" ] +[ "sys", "bit_or", 1, "decimal", "" ] +[ "sys", "bit_or", 2, "decimal", "" ] +[ "sys", "bit_or", 0, "decimal", "or" ] +[ "sys", "bit_or", 1, "decimal", "" ] +[ "sys", "bit_or", 2, "decimal", "" ] +[ "sys", "bit_or", 0, "decimal", "or" ] +[ "sys", "bit_or", 1, "decimal", "" ] +[ "sys", "bit_or", 2, "decimal", "" ] +[ "sys", "bit_xor", 0, "oid", "xor" ] +[ "sys", "bit_xor", 1, "oid", "" ] +[ "sys", "bit_xor", 2, "oid", "" ] +[ "sys", "bit_xor", 0, "tinyint", "xor" ] +[ "sys", "bit_xor", 1, "tinyint", "" ] +[ "sys", "bit_xor", 2, "tinyint", "" ] +[ "sys", "bit_xor", 0, "smallint", "xor" ] +[ "sys", "bit_xor", 1, "smallint", "" ] +[ "sys", "bit_xor", 2, "smallint", "" ] +[ "sys", "bit_xor", 0, "int", "xor" ] +[ "sys", "bit_xor", 1, "int", "" ] +[ "sys", "bit_xor", 2, "int", "" ] +[ "sys", "bit_xor", 0, "bigint", "xor" ] +[ "sys", "bit_xor", 1, "bigint", "" ] +[ "sys", "bit_xor", 2, "bigint", "" ] +[ "sys", "bit_xor", 0, "wrd", "xor" ] +[ "sys", "bit_xor", 1, "wrd", "" ] +[ "sys", "bit_xor", 2, "wrd", "" ] +[ "sys", "bit_xor", 0, "decimal", "xor" ] +[ "sys", "bit_xor", 1, "decimal", "" ] +[ "sys", "bit_xor", 2, "decimal", "" ] +[ "sys", "bit_xor", 0, "decimal", "xor" ] +[ "sys", "bit_xor", 1, "decimal", "" ] +[ "sys", "bit_xor", 2, "decimal", "" ] +[ "sys", "bit_xor", 0, "decimal", "xor" ] +[ "sys", "bit_xor", 1, "decimal", "" ] +[ "sys", "bit_xor", 2, "decimal", "" ] +[ "sys", "bit_xor", 0, "decimal", "xor" ] +[ "sys", "bit_xor", 1, "decimal", "" ] +[ "sys", "bit_xor", 2, "decimal", "" ] [ "sys", "broadcast", 0, "inet", "create function \"broadcast\" (p inet) returns inet\n external name inet.\"broadcast\";" ] [ "sys", "broadcast", 1, "inet", "" ] +[ "sys", "ceil", 0, "real", "ceil" ] +[ "sys", "ceil", 1, "real", "" ] +[ "sys", "ceil", 0, "double", "ceil" ] +[ "sys", "ceil", 1, "double", "" ] +[ "sys", "ceiling", 0, "real", "ceil" ] +[ "sys", "ceiling", 1, "real", "" ] +[ "sys", "ceiling", 0, "double", "ceil" ] +[ "sys", "ceiling", 1, "double", "" ] +[ "sys", "char_length", 0, "int", "length" ] +[ "sys", "char_length", 1, "char", "" ] +[ "sys", "char_length", 0, "int", "length" ] +[ "sys", "char_length", 1, "varchar", "" ] +[ "sys", "char_length", 0, "int", "length" ] +[ "sys", "char_length", 1, "clob", "" ] +[ "sys", "character_length", 0, "int", "length" ] +[ "sys", "character_length", 1, "char", "" ] +[ "sys", "character_length", 0, "int", "length" ] +[ "sys", "character_length", 1, "varchar", "" ] +[ "sys", "character_length", 0, "int", "length" ] +[ "sys", "character_length", 1, "clob", "" ] +[ "sys", "charindex", 0, "int", "locate" ] +[ "sys", "charindex", 1, "char", "" ] +[ "sys", "charindex", 2, "char", "" ] +[ "sys", "charindex", 0, "int", "locate" ] +[ "sys", "charindex", 1, "char", "" ] +[ "sys", "charindex", 2, "char", "" ] +[ "sys", "charindex", 3, "int", "" ] +[ "sys", "charindex", 0, "int", "locate" ] +[ "sys", "charindex", 1, "varchar", "" ] +[ "sys", "charindex", 2, "varchar", "" ] +[ "sys", "charindex", 0, "int", "locate" ] +[ "sys", "charindex", 1, "varchar", "" ] +[ "sys", "charindex", 2, "varchar", "" ] +[ "sys", "charindex", 3, "int", "" ] +[ "sys", "charindex", 0, "int", "locate" ] +[ "sys", "charindex", 1, "clob", "" ] +[ "sys", "charindex", 2, "clob", "" ] +[ "sys", "charindex", 0, "int", "locate" ] +[ "sys", "charindex", 1, "clob", "" ] +[ "sys", "charindex", 2, "clob", "" ] +[ "sys", "charindex", 3, "int", "" ] [ "sys", "chi2prob", 0, "double", "create function sys.chi2prob(chi2 double, datapoints double)\nreturns double external name gsl.\"chi2prob\";" ] [ "sys", "chi2prob", 1, "double", "" ] [ "sys", "chi2prob", 2, "double", "" ] +[ "sys", "code", 0, "char", "unicode" ] +[ "sys", "code", 1, "int", "" ] +[ "sys", "code", 0, "varchar", "unicode" ] +[ "sys", "code", 1, "int", "" ] +[ "sys", "code", 0, "clob", "unicode" ] +[ "sys", "code", 1, "int", "" ] [ "sys", "columnsize", 0, "bigint", "create function sys.columnsize(nme string, i bigint, d bigint)\nreturns bigint\nbegin\n case\n when nme = 'boolean' then return i;\n when nme = 'char' then return 2*i;\n when nme = 'smallint' then return 2 * i;\n when nme = 'int' then return 4 * i;\n when nme = 'bigint' then return 8 * i;\n when nme = 'hugeint' then return 16 * i;\n when nme = 'timestamp' then return 8 * i;\n when nme = 'varchar' then\n case\n when cast(d as bigint) << 8 then return i;\n when cast(d as bigint) << 16 then return 2 * i;\n when cast(d as bigint) << 32 then return 4 * i;\n else return 8 * i;\n end case;\n else return 8 * i;\n end case;\nend;" ] [ "sys", "columnsize", 1, "clob", "" ] [ "sys", "columnsize", 2, "bigint", "" ] [ "sys", "columnsize", 3, "bigint", "" ] +[ "sys", "concat", 0, "char", "+" ] +[ "sys", "concat", 1, "char", "" ] +[ "sys", "concat", 2, "char", "" ] +[ "sys", "concat", 0, "varchar", "+" ] +[ "sys", "concat", 1, "varchar", "" ] +[ "sys", "concat", 2, "varchar", "" ] +[ "sys", "concat", 0, "clob", "+" ] +[ "sys", "concat", 1, "clob", "" ] +[ "sys", "concat", 2, "clob", "" ] [ "sys", "contains", 0, "boolean", "create function contains(a geometry, x double, y double) returns boolean external name geom.\"Contains\";" ] [ "sys", "contains", 1, "geometry", "" ] [ "sys", "contains", 2, "double", "" ] [ "sys", "contains", 3, "double", "" ] +[ "sys", "copyfrom", 0, "table", "copy_from" ] +[ "sys", "copyfrom", 1, "varchar", "" ] +[ "sys", "copyfrom", 2, "varchar", "" ] +[ "sys", "copyfrom", 3, "varchar", "" ] +[ "sys", "copyfrom", 4, "varchar", "" ] +[ "sys", "copyfrom", 5, "varchar", "" ] +[ "sys", "copyfrom", 6, "varchar", "" ] +[ "sys", "copyfrom", 7, "bigint", "" ] +[ "sys", "copyfrom", 8, "bigint", "" ] +[ "sys", "copyfrom", 9, "int", "" ] +[ "sys", "copyfrom", 0, "table", "importTable" ] +[ "sys", "copyfrom", 1, "varchar", "" ] +[ "sys", "copyfrom", 2, "varchar", "" ] [ "sys", "corr", 0, "tinyint", "create aggregate corr(e1 tinyint, e2 tinyint) returns tinyint\n external name \"aggr\".\"corr\";" ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
