Mercurial > hg > monetdb-java

comparison src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 363:34ce6e1b1be8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove support for deprecated MD5 encryption algorithm in MapiSocket.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 10 Sep 2020 18:56:36 +0200 (2020-09-10)
parents eabbc5bf7cdb
children 63cccacad468
comparison
equal deleted inserted replaced
362:2f72b89e1686 363:34ce6e1b1be8
420 " AND \"type\" = 1" + // only scalar functions 420 " AND \"type\" = 1" + // only scalar functions
421 // exclude sql functions: get_value_for, next_value_for, restart 421 // exclude sql functions: get_value_for, next_value_for, restart
422 " AND \"mod\" <> 'sql')" + 422 " AND \"mod\" <> 'sql')" +
423 // include specific functions code(int) and space(int) which belong to the 'str' module 423 // include specific functions code(int) and space(int) which belong to the 'str' module
424 " OR \"mod\" = 'str'" + 424 " OR \"mod\" = 'str'" +
425 // include 3 specific json functions and udf reverse which accept a string arg 425 // include 3 specific json functions, md5() and udf reverse() which all accept a string arg
426 " OR f.\"name\" IN ('isarray','isobject','isvalid','reverse')"; 426 " OR f.\"name\" IN ('isarray','isobject','isvalid','md5','reverse')";
427 final String unionPart = 427 final String unionPart =
428 // add functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y) 428 // add functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
429 " UNION SELECT 'position'"; 429 " UNION SELECT 'position'";
430 return getConcatenatedStringFromQuery(FunctionsSelect + FunctionsWhere + match + OrFunctionsMaxMin + unionPart + FunctionsOrderBy1); 430 return getConcatenatedStringFromQuery(FunctionsSelect + FunctionsWhere + match + OrFunctionsMaxMin + unionPart + FunctionsOrderBy1);
431 } 431 }
433 @Override 433 @Override
434 public String getSystemFunctions() { 434 public String getSystemFunctions() {
435 final String wherePart = 435 final String wherePart =
436 "f.\"name\" IN ('columnsize','debug','get_value_for','hash','hashsize','heapsize'" + 436 "f.\"name\" IN ('columnsize','debug','get_value_for','hash','hashsize','heapsize'" +
437 ",'ifthenelse','imprintsize','isaurl','isauuid','isnull','masterclock','mastertick'" + 437 ",'ifthenelse','imprintsize','isaurl','isauuid','isnull','masterclock','mastertick'" +
438 ",'md5','newurl','next_value_for','password_hash','replicaclock','replicatick','uuid')" + 438 ",'newurl','next_value_for','password_hash','replicaclock','replicatick','uuid')" +
439 // add functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y) 439 // add functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
440 " UNION ALL SELECT * FROM (VALUES('cast'),('coalesce'),('convert'),('nullif')) as sf"; 440 " UNION ALL SELECT * FROM (VALUES('cast'),('coalesce'),('convert'),('nullif')) as sf";
441 return getConcatenatedStringFromQuery(FunctionsSelect + wherePart + FunctionsOrderBy1); 441 return getConcatenatedStringFromQuery(FunctionsSelect + wherePart + FunctionsOrderBy1);
442 } 442 }
443 443
3704 "SELECT 'password', 128, '', 'password for user name to login to MonetDB server' UNION ALL " + 3704 "SELECT 'password', 128, '', 'password for user name to login to MonetDB server' UNION ALL " +
3705 "SELECT 'language', 16, 'sql', 'language (sql or mal) used to parse commands in MonetDB server' UNION ALL " + 3705 "SELECT 'language', 16, 'sql', 'language (sql or mal) used to parse commands in MonetDB server' UNION ALL " +
3706 "SELECT 'database', 1024, 'demo', 'name of database. It matches the dbfarm subdirectory name' UNION ALL " + 3706 "SELECT 'database', 1024, 'demo', 'name of database. It matches the dbfarm subdirectory name' UNION ALL " +
3707 "SELECT 'debug', 5, 'false', 'boolean flag true or false' UNION ALL " + 3707 "SELECT 'debug', 5, 'false', 'boolean flag true or false' UNION ALL " +
3708 "SELECT 'logfile', 1024, 'monet_######.log', 'name of logfile used when debug is enabled' UNION ALL " + 3708 "SELECT 'logfile', 1024, 'monet_######.log', 'name of logfile used when debug is enabled' UNION ALL " +
3709 "SELECT 'hash', 128, '', 'hash methods list to use in server connection. Supported are SHA512, SHA384, SHA256, SHA1 and MD5' UNION ALL " + 3709 "SELECT 'hash', 128, '', 'hash methods list to use in server connection. Supported are SHA512, SHA384, SHA256 and SHA1' UNION ALL " +
3710 "SELECT 'treat_blob_as_binary', 5, 'false', 'should blob columns be mapped to Types.VARBINARY instead of default Types.BLOB in ResultSets and PreparedStatements' UNION ALL " + 3710 "SELECT 'treat_blob_as_binary', 5, 'false', 'should blob columns be mapped to Types.VARBINARY instead of default Types.BLOB in ResultSets and PreparedStatements' UNION ALL " +
3711 "SELECT 'treat_clob_as_varchar', 5, 'false', 'should clob columns be mapped to Types.VARCHAR instead of default Types.CLOB in ResultSets and PreparedStatements' UNION ALL " + 3711 "SELECT 'treat_clob_as_varchar', 5, 'false', 'should clob columns be mapped to Types.VARCHAR instead of default Types.CLOB in ResultSets and PreparedStatements' UNION ALL " +
3712 "SELECT 'so_timeout', 10, '0', 'timeout (in milliseconds) of communication socket. 0 means no timeout is set' " + 3712 "SELECT 'so_timeout', 10, '0', 'timeout (in milliseconds) of communication socket. 0 means no timeout is set' " +
3713 "ORDER BY \"NAME\""; 3713 "ORDER BY \"NAME\"";
3714 3714