Changeset: dfd249a2aa31 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dfd249a2aa31 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 Branch: default Log Message:
approved output now that the F_FUNC version of like/ilike isn't needed anymore diffs (280 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 @@ -2012,12 +2012,6 @@ drop function pcre_replace(string, strin [ "sys", "ifthenelse", "ifthenelse", "calc", 0, 1, false, false, false ] [ "sys", "ilike", "create filter function \"ilike\"(val string, pat string) external name algebra.\"ilike\";", "algebra", 1, 4, true, false, false ] [ "sys", "ilike", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";", "algebra", 1, 4, true, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] [ "sys", "imprintsize", "create function sys.imprintsize(i bigint, nme string) returns bigint begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int' or nme = 'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme = 'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as bigint); end if ; return 0; end;", "user", 2, 1, false, false, false ] [ "sys", "in", "in", "calc", 0, 1, false, false, false ] [ "sys", "index", "index", "calc", 0, 1, false, false, false ] @@ -2066,12 +2060,6 @@ drop function pcre_replace(string, strin [ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1, false, false, false ] [ "sys", "like", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", 1, 4, true, false, false ] [ "sys", "like", "create filter function \"like\"(val string, pat string, esc string) external name algebra.\"like\";", "algebra", 1, 4, true, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] [ "sys", "listdir", "create procedure listdir(dirname string) external name fits.listdir;", "fits", 1, 2, true, false, false ] [ "sys", "listdirpat", "create procedure listdirpat(dirname string,pat string) external name fits.listdirpattern;", "fits", 1, 2, true, false, false ] [ "sys", "local_timezone", "local_timezone", "mtime", 0, 1, false, false, false ] @@ -3566,12 +3554,6 @@ drop function pcre_replace(string, strin [ "sys", "hour", "arg_1", "timetz", 7, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "identity", "arg_1", "any", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ifthenelse", "arg_1", "boolean", 1, 0, 1, "arg_2", "any", 0, 0, 1, "arg_3", "any", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, "arg_3", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, "arg_3", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, "arg_3", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "pat", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "pat", "clob", 0, 0, 1, "esc", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "imprintsize", "i", "bigint", 64, 0, 1, "nme", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -3620,12 +3602,6 @@ drop function pcre_replace(string, strin [ "sys", "levenshtein", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, "arg_3", "int", 32, 0, 1, "arg_4", "int", 32, 0, 1, "arg_5", "int", 32, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "levenshtein", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "levenshtein", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, "arg_3", "int", 32, 0, 1, "arg_4", "int", 32, 0, 1, "arg_5", "int", 32, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, "arg_3", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, "arg_3", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, "arg_3", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "pat", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "pat", "clob", 0, 0, 1, "esc", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "listdir", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -5576,12 +5552,6 @@ drop function pcre_replace(string, strin [ "ifthenelse" ] [ "ilike" ] [ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] [ "imprintsize" ] [ "in" ] [ "index" ] @@ -5639,12 +5609,6 @@ drop function pcre_replace(string, strin [ "levenshtein" ] [ "like" ] [ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] [ "listdir" ] [ "listdirpat" ] [ "local_timezone" ] 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 @@ -2034,12 +2034,6 @@ drop function pcre_replace(string, strin [ "sys", "ifthenelse", "ifthenelse", "calc", 0, 1, false, false, false ] [ "sys", "ilike", "create filter function \"ilike\"(val string, pat string) external name algebra.\"ilike\";", "algebra", 1, 4, true, false, false ] [ "sys", "ilike", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";", "algebra", 1, 4, true, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] -[ "sys", "ilike", "ilike", "algebra", 0, 1, false, false, false ] [ "sys", "imprintsize", "create function sys.imprintsize(i bigint, nme string) returns bigint begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int' or nme = 'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme = 'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as bigint); end if ; return 0; end;", "user", 2, 1, false, false, false ] [ "sys", "in", "in", "calc", 0, 1, false, false, false ] [ "sys", "index", "index", "calc", 0, 1, false, false, false ] @@ -2090,12 +2084,6 @@ drop function pcre_replace(string, strin [ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1, false, false, false ] [ "sys", "like", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", 1, 4, true, false, false ] [ "sys", "like", "create filter function \"like\"(val string, pat string, esc string) external name algebra.\"like\";", "algebra", 1, 4, true, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] -[ "sys", "like", "like", "algebra", 0, 1, false, false, false ] [ "sys", "listdir", "create procedure listdir(dirname string) external name fits.listdir;", "fits", 1, 2, true, false, false ] [ "sys", "listdirpat", "create procedure listdirpat(dirname string,pat string) external name fits.listdirpattern;", "fits", 1, 2, true, false, false ] [ "sys", "local_timezone", "local_timezone", "mtime", 0, 1, false, false, false ] @@ -3769,12 +3757,6 @@ drop function pcre_replace(string, strin [ "sys", "hour", "arg_1", "timetz", 7, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "identity", "arg_1", "any", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ifthenelse", "arg_1", "boolean", 1, 0, 1, "arg_2", "any", 0, 0, 1, "arg_3", "any", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, "arg_3", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, "arg_3", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, "arg_3", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "pat", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "ilike", "pat", "clob", 0, 0, 1, "esc", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "imprintsize", "i", "bigint", 64, 0, 1, "nme", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -3825,12 +3807,6 @@ drop function pcre_replace(string, strin [ "sys", "levenshtein", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, "arg_3", "int", 32, 0, 1, "arg_4", "int", 32, 0, 1, "arg_5", "int", 32, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "levenshtein", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "levenshtein", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, "arg_3", "int", 32, 0, 1, "arg_4", "int", 32, 0, 1, "arg_5", "int", 32, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "char", 0, 0, 1, "arg_2", "char", 0, 0, 1, "arg_3", "char", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "clob", 0, 0, 1, "arg_2", "clob", 0, 0, 1, "arg_3", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "arg_1", "varchar", 0, 0, 1, "arg_2", "varchar", 0, 0, 1, "arg_3", "varchar", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "pat", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "like", "pat", "clob", 0, 0, 1, "esc", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "listdir", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] @@ -5961,12 +5937,6 @@ drop function pcre_replace(string, strin [ "ifthenelse" ] [ "ilike" ] [ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] -[ "ilike" ] [ "imprintsize" ] [ "in" ] [ "index" ] @@ -6026,12 +5996,6 @@ drop function pcre_replace(string, strin [ "levenshtein" ] [ "like" ] [ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] -[ "like" ] [ "listdir" ] [ "listdirpat" ] [ "local_timezone" ] 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 @@ -733,27 +733,6 @@ Ready. [ "sys", "ifthenelse", 1, "boolean", "" ] [ "sys", "ifthenelse", 2, "any", "" ] [ "sys", "ifthenelse", 3, "any", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "char", "" ] -[ "sys", "ilike", 2, "char", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "char", "" ] -[ "sys", "ilike", 2, "char", "" ] -[ "sys", "ilike", 3, "char", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "varchar", "" ] -[ "sys", "ilike", 2, "varchar", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "varchar", "" ] -[ "sys", "ilike", 2, "varchar", "" ] -[ "sys", "ilike", 3, "varchar", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "clob", "" ] -[ "sys", "ilike", 2, "clob", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "clob", "" ] -[ "sys", "ilike", 2, "clob", "" ] -[ "sys", "ilike", 3, "clob", "" ] [ "sys", "ilike", 0, "clob", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";" ] [ "sys", "ilike", 1, "clob", "" ] [ "sys", "ilike", 2, "clob", "" ] @@ -906,27 +885,6 @@ Ready. [ "sys", "levenshtein", 3, "int", "" ] [ "sys", "levenshtein", 4, "int", "" ] [ "sys", "levenshtein", 5, "int", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "char", "" ] -[ "sys", "like", 2, "char", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "char", "" ] -[ "sys", "like", 2, "char", "" ] -[ "sys", "like", 3, "char", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "varchar", "" ] -[ "sys", "like", 2, "varchar", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "varchar", "" ] -[ "sys", "like", 2, "varchar", "" ] -[ "sys", "like", 3, "varchar", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "clob", "" ] -[ "sys", "like", 2, "clob", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "clob", "" ] -[ "sys", "like", 2, "clob", "" ] -[ "sys", "like", 3, "clob", "" ] [ "sys", "like", 0, "clob", "create filter function \"like\"(val string, pat string, esc string) external name algebra.\"like\";" ] [ "sys", "like", 1, "clob", "" ] [ "sys", "like", 2, "clob", "" ] diff --git a/sql/test/Tests/systemfunctions.stable.out.int128 b/sql/test/Tests/systemfunctions.stable.out.int128 --- a/sql/test/Tests/systemfunctions.stable.out.int128 +++ b/sql/test/Tests/systemfunctions.stable.out.int128 @@ -777,27 +777,6 @@ Ready. [ "sys", "ifthenelse", 1, "boolean", "" ] [ "sys", "ifthenelse", 2, "any", "" ] [ "sys", "ifthenelse", 3, "any", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "char", "" ] -[ "sys", "ilike", 2, "char", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "char", "" ] -[ "sys", "ilike", 2, "char", "" ] -[ "sys", "ilike", 3, "char", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "varchar", "" ] -[ "sys", "ilike", 2, "varchar", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "varchar", "" ] -[ "sys", "ilike", 2, "varchar", "" ] -[ "sys", "ilike", 3, "varchar", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "clob", "" ] -[ "sys", "ilike", 2, "clob", "" ] -[ "sys", "ilike", 0, "boolean", "ilike" ] -[ "sys", "ilike", 1, "clob", "" ] -[ "sys", "ilike", 2, "clob", "" ] -[ "sys", "ilike", 3, "clob", "" ] [ "sys", "ilike", 0, "clob", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";" ] [ "sys", "ilike", 1, "clob", "" ] [ "sys", "ilike", 2, "clob", "" ] @@ -956,27 +935,6 @@ Ready. [ "sys", "levenshtein", 3, "int", "" ] [ "sys", "levenshtein", 4, "int", "" ] [ "sys", "levenshtein", 5, "int", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "char", "" ] -[ "sys", "like", 2, "char", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "char", "" ] -[ "sys", "like", 2, "char", "" ] -[ "sys", "like", 3, "char", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "varchar", "" ] -[ "sys", "like", 2, "varchar", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "varchar", "" ] -[ "sys", "like", 2, "varchar", "" ] -[ "sys", "like", 3, "varchar", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "clob", "" ] -[ "sys", "like", 2, "clob", "" ] -[ "sys", "like", 0, "boolean", "like" ] -[ "sys", "like", 1, "clob", "" ] -[ "sys", "like", 2, "clob", "" ] -[ "sys", "like", 3, "clob", "" ] [ "sys", "like", 0, "clob", "create filter function \"like\"(val string, pat string, esc string) external name algebra.\"like\";" ] [ "sys", "like", 1, "clob", "" ] [ "sys", "like", 2, "clob", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list