+
−/*
+
− * SPDX-License-Identifier: MPL-2.0
+
− *
+
− * This Source Code Form is subject to the terms of the Mozilla Public
+
− * License, v. 2.0.  If a copy of the MPL was not distributed with this
+
− * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+
− *
+
− * Copyright 2024 MonetDB Foundation;
+
− * Copyright August 2008 - 2023 MonetDB B.V.;
+
− * Copyright 1997 - July 2008 CWI.
+
− */
+
−
+
−package org.monetdb.jdbc;
+
−
+
−import org.monetdb.mcl.net.ClientInfo;
+
−
+
−import java.sql.Connection;
+
−import java.sql.DatabaseMetaData;
+
−import java.sql.Statement;
+
−import java.sql.SQLException;
+
−import java.sql.ResultSet;
+
−import java.sql.ResultSetMetaData;
+
−import java.sql.RowIdLifetime;
+
−import java.sql.Types;
+
−
+
−/**
+
− * A DatabaseMetaData object suitable for the MonetDB database.
+
− *
+
− * @author Fabian Groffen
+
− * @author Martin van Dinther
+
− * @version 1.0
+
− */
+
−public final class MonetDatabaseMetaData
+
−	extends MonetWrapper
+
−	implements DatabaseMetaData
+
−{
+
−	private final MonetConnection con;
+
−
+
−	/**
+
−	 * Constructor
+
−	 * @param parent the parent MonetConnection object.
+
−	 */
+
−	public MonetDatabaseMetaData(final MonetConnection parent) {
+
−		con = parent;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether the current user can call all the procedures
+
−	 * returned by the method getProcedures.
+
−	 *
+
−	 * @return false because we currently return all procedures from sys.functions
+
−	 *    and do not filter on EXECUTE privilege or procedure ownership.
+
−	 */
+
−	@Override
+
−	public boolean allProceduresAreCallable() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether the current user can use all the tables
+
−	 * returned by the method getTables in a SELECT statement.
+
−	 *
+
−	 * @return false because we currently return all tables from sys.tables
+
−	 *    and do not filter on SELECT privilege or table ownership.
+
−	 */
+
−	@Override
+
−	public boolean allTablesAreSelectable() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * What is the URL for this database?
+
−	 *
+
−	 * @return a reconstructed connection string
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public String getURL() throws SQLException {
+
−		return con.getJDBCURL();
+
−	}
+
−
+
−	/**
+
−	 * What is our user name as known to the database?
+
−	 *
+
−	 * @return sql user
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public String getUserName() throws SQLException {
+
−		return con.getUserName();
+
−	}
+
−
+
−	/**
+
−	 * Is the database in read-only mode?
+
−	 *
+
−	 * @return always false for now
+
−	 */
+
−	@Override
+
−	public boolean isReadOnly() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether NULL values are sorted high. Sorted high means
+
−	 * that NULL values sort higher than any other value in a domain.
+
−	 * In an ascending order, if this method returns true, NULL values will appear at the end.
+
−	 * By contrast, the method nullsAreSortedAtEnd indicates whether NULL values are sorted at the end regardless of sort order.
+
−	 *
+
−	 * @return false because MonetDB shows NULL values at the beginning upon ORDER BY .. ASC, not at the end
+
−	 * @see #nullsAreSortedLow()
+
−	 */
+
−	@Override
+
−	public boolean nullsAreSortedHigh() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether NULL values are sorted low. Sorted low means
+
−	 * that NULL values sort lower than any other value in a domain.
+
−	 * In an ascending order, if this method returns true, NULL values will appear at the beginning.
+
−	 * By contrast, the method nullsAreSortedAtStart indicates whether NULL values are sorted at the beginning regardless of sort order.
+
−	 *
+
−	 * @return true because MonetDB shows NULL values at the beginning upon ORDER BY .. ASC
+
−	 * @see #nullsAreSortedHigh()
+
−	 */
+
−	@Override
+
−	public boolean nullsAreSortedLow() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are NULL values sorted at the start regardless of sort order?
+
−	 *
+
−	 * @return false, since MonetDB doesn't do this
+
−	 */
+
−	@Override
+
−	public boolean nullsAreSortedAtStart() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Are NULL values sorted at the end regardless of sort order?
+
−	 *
+
−	 * @return false, since MonetDB doesn't do this
+
−	 */
+
−	@Override
+
−	public boolean nullsAreSortedAtEnd() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * What is the name of this database product - this should be MonetDB
+
−	 * of course, so we return that explicitly.
+
−	 *
+
−	 * @return the database product name
+
−	 */
+
−	@Override
+
−	public String getDatabaseProductName() {
+
−		return "MonetDB";
+
−	}
+
−
+
−	/**
+
−	 * What is the version of this database product.
+
−	 *
+
−	 * @return the mserver5 version number string
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public String getDatabaseProductVersion() throws SQLException {
+
−		return con.getDatabaseProductVersion();
+
−	}
+
−
+
−	/**
+
−	 * What is the name of this JDBC driver?
+
−	 *
+
−	 * @return the JDBC driver name
+
−	 */
+
−	@Override
+
−	public String getDriverName() {
+
−		return "MonetDB Native Driver";
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the version number of this JDBC driver as a String.
+
−	 *
+
−	 * @return the JDBC driver version string
+
−	 */
+
−	@Override
+
−	public String getDriverVersion() {
+
−		return MonetVersion.driverVersion;
+
−	}
+
−
+
−	/**
+
−	 * What is this JDBC driver's major version number?
+
−	 *
+
−	 * @return the JDBC driver major version number
+
−	 */
+
−	@Override
+
−	public int getDriverMajorVersion() {
+
−		return MonetVersion.majorVersion;
+
−	}
+
−
+
−	/**
+
−	 * What is this JDBC driver's minor version number?
+
−	 *
+
−	 * @return the JDBC driver minor version number
+
−	 */
+
−	@Override
+
−	public int getDriverMinorVersion() {
+
−		return MonetVersion.minorVersion;
+
−	}
+
−
+
−	/**
+
−	 * Does the database store tables in a local file?
+
−	 * No, it stores them in files on the server.
+
−	 *
+
−	 * @return false because that's what MonetDB is for
+
−	 */
+
−	@Override
+
−	public boolean usesLocalFiles() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database use a local file for each table?
+
−	 *
+
−	 * @return false for it doesn't
+
−	 */
+
−	@Override
+
−	public boolean usesLocalFilePerTable() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case unquoted SQL identifiers
+
−	 * as case sensitive and as a result store them in mixed case?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns false.
+
−	 *
+
−	 * @return false
+
−	 */
+
−	@Override
+
−	public boolean supportsMixedCaseIdentifiers() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case unquoted SQL identifiers as
+
−	 * case insensitive and store them in upper case?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean storesUpperCaseIdentifiers() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case unquoted SQL identifiers as
+
−	 * case insensitive and store them in lower case?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean storesLowerCaseIdentifiers() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case unquoted SQL identifiers as
+
−	 * case insensitive and store them in mixed case?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean storesMixedCaseIdentifiers() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case quoted SQL identifiers as
+
−	 * case sensitive and as a result store them in mixed case?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsMixedCaseQuotedIdentifiers() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case quoted SQL identifiers as
+
−	 * case insensitive and store them in upper case?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean storesUpperCaseQuotedIdentifiers() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case quoted SQL identifiers as case
+
−	 * insensitive and store them in lower case?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean storesLowerCaseQuotedIdentifiers() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does the database treat mixed case quoted SQL identifiers as case
+
−	 * insensitive and store them in mixed case?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean storesMixedCaseQuotedIdentifiers() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * What is the string used to quote SQL identifiers?
+
−	 * This returns a space if identifier quoting isn't supported.
+
−	 * A JDBC Compliant <sup>TM</sup> driver
+
−	 * will always use a double quote character.
+
−	 *
+
−	 * @return the quoting string
+
−	 */
+
−	@Override
+
−	public String getIdentifierQuoteString() {
+
−		return "\"";
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a comma-separated list of all of this database's
+
−	 * SQL keywords that are NOT also SQL:2003 keywords.
+
−	 *
+
−	 * @return a comma separated list of MonetDB keywords that are not also SQL:2003 keywords
+
−	 */
+
−	@Override
+
−	public String getSQLKeywords() {
+
−		return getConcatenatedStringFromQuery(
+
−			"SELECT \"keyword\" FROM \"sys\".\"keywords\" " +
+
−			// exclude all SQL:2003 keywords
+
−			"WHERE \"keyword\" NOT IN (" +
+
−			"'ABS','ALL','ALLOCATE','ALTER','AND','ANY','ARE','ARRAY','AS'," +
+
−			"'ASENSITIVE','ASYMMETRIC','AT','ATOMIC','AUTHORIZATION','AVG'," +
+
−			"'BEGIN','BETWEEN','BIGINT','BINARY','BLOB','BOOLEAN','BOTH','BY'," +
+
−			"'CALL','CALLED','CARDINALITY','CASCADED','CASE','CAST','CEIL','CEILING'," +
+
−			"'CHAR','CHARACTER','CHARACTER_LENGTH','CHAR_LENGTH','CHECK','CLOB'," +
+
−			"'CLOSE','COALESCE','COLLATE','COLLECT','COLUMN','COMMIT','CONDITION'," +
+
−			"'CONNECT','CONSTRAINT','CONVERT','CORR','CORRESPONDING','COUNT'," +
+
−			"'COVAR_POP','COVAR_SAMP','CREATE','CROSS','CUBE','CUME_DIST','CURRENT','CURRENT_DATE'," +
+
−			"'CURRENT_DEFAULT_TRANSFORM_GROUP','CURRENT_PATH','CURRENT_ROLE','CURRENT_TIME'," +
+
−			"'CURRENT_TIMESTAMP','CURRENT_TRANSFORM_GROUP_FOR_TYPE','CURRENT_USER','CURSOR','CYCLE'," +
+
−			"'DATE','DAY','DEALLOCATE','DEC','DECIMAL','DECLARE','DEFAULT','DELETE','DENSE_RANK','DEREF'," +
+
−			"'DESCRIBE','DETERMINISTIC','DISCONNECT','DISTINCT','DOUBLE','DROP','DYNAMIC'," +
+
−			"'EACH','ELEMENT','ELSE','END','END-EXEC','ESCAPE','EVERY','EXCEPT','EXEC','EXECUTE','EXISTS','EXP','EXTERNAL','EXTRACT'," +
+
−			"'FALSE','FETCH','FILTER','FLOAT','FLOOR','FOR','FOREIGN','FREE','FROM','FULL','FUNCTION','FUSION'," +
+
−			"'GET','GLOBAL','GRANT','GROUP','GROUPING','HAVING','HOLD','HOUR'," +
+
−			"'IDENTITY','IN','INDICATOR','INNER','INOUT','INSENSITIVE','INSERT'," +
+
−			"'INT','INTEGER','INTERSECT','INTERSECTION','INTERVAL','INTO','IS','JOIN'," +
+
−			"'LANGUAGE','LARGE','LATERAL','LEADING','LEFT','LIKE','LN','LOCAL','LOCALTIME','LOCALTIMESTAMP','LOWER'," +
+
−			"'MATCH','MAX','MEMBER','MERGE','METHOD','MIN','MINUTE','MOD','MODIFIES','MODULE','MONTH','MULTISET'," +
+
−			"'NATIONAL','NATURAL','NCHAR','NCLOB','NEW','NO','NONE','NORMALIZE','NOT','NULL','NULLIF','NUMERIC'," +
+
−			"'OCTET_LENGTH','OF','OLD','ON','ONLY','OPEN','OR','ORDER','OUT','OUTER','OVER','OVERLAPS','OVERLAY'," +
+
−			"'PARAMETER','PARTITION','PERCENTILE_CONT','PERCENTILE_DISC','PERCENT_RANK'," +
+
−			"'POSITION','POWER','PRECISION','PREPARE','PRIMARY','PROCEDURE'," +
+
−			"'RANGE','RANK','READS','REAL','RECURSIVE','REF','REFERENCES','REFERENCING'," +
+
−			"'REGR_AVGX','REGR_AVGY','REGR_COUNT','REGR_INTERCEPT','REGR_R2','REGR_SLOPE','REGR_SXX','REGR_SXY','REGR_SYY'," +
+
−			"'RELEASE','RESULT','RETURN','RETURNS','REVOKE','RIGHT','ROLLBACK','ROLLUP','ROW','ROWS','ROW_NUMBER'," +
+
−			"'SAVEPOINT','SCOPE','SCROLL','SEARCH','SECOND','SELECT','SENSITIVE','SESSION_USER','SET'," +
+
−			"'SIMILAR','SMALLINT','SOME','SPECIFIC','SPECIFICTYPE','SQL','SQLEXCEPTION','SQLSTATE','SQLWARNING'," +
+
−			"'SQRT','START','STATIC','STDDEV_POP','STDDEV_SAMP','SUBMULTISET','SUBSTRING','SUM'," +
+
−			"'SYMMETRIC','SYSTEM','SYSTEM_USER'," +
+
−			"'TABLE','TABLESAMPLE','THEN','TIME','TIMESTAMP','TIMEZONE_HOUR','TIMEZONE_MINUTE'," +
+
−			"'TO','TRAILING','TRANSLATE','TRANSLATION','TREAT','TRIGGER','TRIM','TRUE'," +
+
−			"'UESCAPE','UNION','UNIQUE','UNKNOWN','UNNEST','UPDATE','UPPER','USER','USING'," +
+
−			"'VALUE','VALUES','VARCHAR','VARYING','VAR_POP','VAR_SAMP'," +
+
−			"'WHEN','WHENEVER','WHERE','WIDTH_BUCKET','WINDOW','WITH','WITHIN','WITHOUT','YEAR'" +
+
−			") ORDER BY 1");
+
−	}
+
−
+
−	/**
+
−	 * Internal utility method getConcatenatedStringFromQuery(String query)
+
−	 * @param query the SQL SELECT query. Only the output of the first column is fetched and concatenated.
+
−	 * @return a String of query result values concatenated into one string, and values separated by comma's
+
−	 */
+
−	private String getConcatenatedStringFromQuery(final String query) {
+
−		final StringBuilder sb = new StringBuilder(1200);
+
−		Statement st = null;
+
−		ResultSet rs = null;
+
−		try {
+
−			st = con.createStatement();
+
−			rs = st.executeQuery(query);
+
−			// Fetch the first column output and concatenate the values into a StringBuilder separated by comma's
+
−			boolean isfirst = true;
+
−			while (rs.next()) {
+
−				String value = rs.getString(1);
+
−				if (value != null) {
+
−					if (isfirst) {
+
−						isfirst = false;
+
−					} else {
+
−						sb.append(',');
+
−					}
+
−					sb.append(value);
+
−				}
+
−			}
+
−		} catch (SQLException e) {
+
−			/* ignore */
+
−		} finally {
+
−			MonetConnection.closeResultsetStatement(rs, st);
+
−		}
+
−		// for debug: System.out.println("SQL (len " + query.length() + "): " + query + "\nResult string(len " + sb.length() + "): " + sb.toString());
+
−		return sb.toString();
+
−	}
+
−
+
−	// SQL query parts shared by four get<Type>Functions() below
+
−	private static final String FunctionsSelect = "SELECT DISTINCT CASE WHEN f.\"language\" > 0 THEN s.\"name\"||'.'||f.\"name\" ELSE f.\"name\" END" +
+
−					" FROM \"sys\".\"functions\" f JOIN \"sys\".\"schemas\" s ON f.\"schema_id\" = s.\"id\" WHERE ";
+
−	private static final String FunctionsWhere = "(f.\"id\" IN (SELECT \"func_id\" FROM \"sys\".\"args\" WHERE \"number\" = 1 AND \"name\" = 'arg_1' AND \"type\" IN ";
+
−	// Scalar functions sql_max(x,y), sql_min(x,y), greatest(x,y) and least(x,y) are defined in sys.args for type 'any' and usable as num, str and timedate functions.
+
−	private static final String OrFunctionsMaxMin = " OR f.\"name\" IN ('sql_max','sql_min','least','greatest')";
+
−	private static final String FunctionsOrderBy1 = " ORDER BY 1";
+
−
+
−	@Override
+
−	public String getNumericFunctions() {
+
−		final String match =
+
−			"('tinyint','smallint','int','bigint','hugeint','decimal','double','real'))" +
+
−			" AND \"type\" = 1" +	// only scalar functions
+
−			// exclude functions which do not work or belong to string functions (code(int) and space(int))
+
−			" AND f.\"name\" NOT IN ('code','not_uniques','rotate_xor_hash','space'))" +
+
−			// include specific functions which have no arguments (pi()) or are numeric. Actually ms_str is a conversion function from float to str.
+
−			" OR f.\"name\" IN ('alpha','degrees','fuse','ms_round','ms_str','ms_trunc','pi','radians')";
+
−		return getConcatenatedStringFromQuery(FunctionsSelect + FunctionsWhere + match + OrFunctionsMaxMin + FunctionsOrderBy1);
+
−	}
+
−
+
−	@Override
+
−	public String getStringFunctions() {
+
−		final String match =
+
−			"('char','varchar','clob','json','url'))" +
+
−			" AND \"type\" = 1" +	// only scalar functions
+
−			// exclude sql functions: get_value_for, next_value_for, restart
+
−			" AND \"mod\" <> 'sql')" +
+
−			// include specific functions code(int) and space(int) which belong to the 'str' module
+
−			// include functions (difference, editdistance, editdistance2, levenshtein, qgramnormalize, similarity, soundex) which since Jun2023 are in the 'txtsim' module
+
−			" OR (\"mod\" IN ('str','txtsim') AND \"type\" = 1)" +
+
−			// include 3 specific json functions and md5(), ms_stuff() and udf reverse() which all accept a string arg
+
−			" OR f.\"name\" IN ('isarray','isobject','isvalid','md5','ms_stuff','reverse')";
+
−		final String unionPart =
+
−			// add functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
+
−			" UNION SELECT 'position'";
+
−		return getConcatenatedStringFromQuery(FunctionsSelect + FunctionsWhere + match + OrFunctionsMaxMin + unionPart + FunctionsOrderBy1);
+
−	}
+
−
+
−	@Override
+
−	public String getSystemFunctions() {
+
−		final String wherePart =
+
−			"f.\"name\" IN ('columnsize','current_sessionid','database','debug'" +
+
−			",'get_value_for','greatest','hash','hashsize','heapsize'" +
+
−			",'ifthenelse','imprintsize','isaurl','isauuid','isnull','least'" +
+
−			",'masterclock','mastertick'" +		// wlc/wlr functions
+
−			",'newurl','next_value_for','password_hash'" +
+
−			",'replicaclock','replicatick'" +	// wlc/wlr functions
+
−			",'sql_max','sql_min','uuid')";
+
−		String unionPart =
+
−			// add functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
+
−			" UNION SELECT * FROM (VALUES('cast'),('coalesce'),('convert'),('ifnull'),('nullif')) as sf";
+
−		// from release 11.47.1 we support function: ifnull, but only with odbc escape notation, so {fn ifnull(null, 2)}. See issue: 6933.
+
−		// from release 11.49.1 we support function: ifnull also without odbc escape notation.
+
−		if (! con.checkMinimumDBVersion(11, 47))
+
−			// release 11.45 (Sep2022) or older did not support function: ifnull. remove it.
+
−			unionPart = unionPart.replace(",('ifnull')", "");
+
−		return getConcatenatedStringFromQuery(FunctionsSelect + wherePart + unionPart + FunctionsOrderBy1);
+
−	}
+
−
+
−	@Override
+
−	public String getTimeDateFunctions() {
+
−		final String wherePart =
+
−			 "\"mod\" IN ('mtime','timestamp')" +
+
−			// include Date/Time functions which are located in 'str' module
+
−			" OR f.\"name\" IN ('localtime','localtimestamp','date_trunc')";
+
−		final String unionPart =
+
−			// add time date functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
+
−			" UNION SELECT 'extract'" +
+
−			" UNION SELECT 'now'";
+
−			// ToDo: from release 11.47.1 we also support functions: dayname and monthname, but only with odbc escape notation, so {fn dayname(current_date)}. Related issue: 7300.
+
−		return getConcatenatedStringFromQuery(FunctionsSelect + wherePart + OrFunctionsMaxMin + unionPart + FunctionsOrderBy1);
+
−	}
+
−
+
−	/**
+
−	 * This is the string that can be used to escape '_' and '%' in
+
−	 * a search string pattern style catalog search parameters
+
−	 *
+
−	 * @return the string used to escape wildcard characters
+
−	 */
+
−	@Override
+
−	public String getSearchStringEscape() {
+
−		return "\\";
+
−	}
+
−
+
−	/**
+
−	 * Get all the "extra" characters that can be used in unquoted
+
−	 * identifier names (those beyond a-zA-Z0-9 and _)
+
−	 *
+
−	 * @return a string containing the extra characters
+
−	 */
+
−	@Override
+
−	public String getExtraNameCharacters() {
+
−		// MonetDB has no extra characters. Verified it for chars: !@#$%^&*()~{}[]?
+
−		return "";
+
−	}
+
−
+
−	/**
+
−	 * Is "ALTER TABLE" with an add column supported?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsAlterTableWithAddColumn() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is "ALTER TABLE" with a drop column supported?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsAlterTableWithDropColumn() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is column aliasing supported?
+
−	 *
+
−	 * <p>If so, the SQL AS clause can be used to provide names for
+
−	 * computed columns or to provide alias names for columns as required.
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * <p>e.g.
+
−	 *
+
−	 * <br><pre>
+
−	 * select count(C) as C_COUNT from T group by C;
+
−	 *
+
−	 * </pre><br>
+
−	 * should return a column named as C_COUNT instead of count(C)
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsColumnAliasing() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are concatenations between NULL and non-NULL values NULL?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean nullPlusNonNullIsNull() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports the JDBC scalar function
+
−	 * CONVERT for the conversion of one JDBC type to another.
+
−	 * The JDBC types are the generic SQL data types defined in java.sql.Types.
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsConvert() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports the JDBC scalar function
+
−	 * CONVERT for conversions between the JDBC types fromType and toType.
+
−	 * The JDBC types are the generic SQL data types defined in java.sql.Types.
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsConvert(final int fromType, final int toType) {
+
−		switch (fromType) {
+
−		case Types.BOOLEAN:
+
−			switch (toType) {
+
−			case Types.BOOLEAN:
+
−		/*	case Types.BIT: is not supported by MonetDB and will fail */
+
−			case Types.TINYINT:
+
−			case Types.SMALLINT:
+
−			case Types.INTEGER:
+
−			case Types.BIGINT:
+
−		/* conversion to FLOAT, REAL, DOUBLE, NUMERIC and DECIMAL is not supported by MonetDB */
+
−			case Types.CHAR:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−	/*	case Types.BIT: is not supported by MonetDB and will fail */
+
−	/*	case Types.BINARY: is not supported by MonetDB and will fail */
+
−	/*	case Types.VARBINARY: is not supported by MonetDB and will fail */
+
−	/*	case Types.LONGVARBINARY: is not supported by MonetDB and will fail */
+
−		case Types.BLOB:
+
−			switch (toType) {
+
−		/*	case Types.BINARY: is not supported by MonetDB and will fail */
+
−		/*	case Types.VARBINARY: is not supported by MonetDB and will fail */
+
−		/*	case Types.LONGVARBINARY: is not supported by MonetDB and will fail */
+
−			case Types.BLOB:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−		case Types.TINYINT:
+
−		case Types.SMALLINT:
+
−		case Types.INTEGER:
+
−		case Types.BIGINT:
+
−		case Types.FLOAT:
+
−		case Types.REAL:
+
−		case Types.DOUBLE:
+
−		case Types.NUMERIC:
+
−		case Types.DECIMAL:
+
−			switch (toType) {
+
−			case Types.BOOLEAN:
+
−		/*	case Types.BIT: is not supported by MonetDB and will fail */
+
−			case Types.TINYINT:
+
−			case Types.SMALLINT:
+
−			case Types.INTEGER:
+
−			case Types.BIGINT:
+
−			case Types.FLOAT:
+
−			case Types.REAL:
+
−			case Types.DOUBLE:
+
−			case Types.NUMERIC:
+
−			case Types.DECIMAL:
+
−			case Types.CHAR:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−		case Types.CHAR:
+
−		case Types.VARCHAR:
+
−	/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−		case Types.CLOB:
+
−			switch (toType) {
+
−			case Types.BOOLEAN:
+
−		/*	case Types.BIT: is not supported by MonetDB and will fail */
+
−			case Types.TINYINT:
+
−			case Types.SMALLINT:
+
−			case Types.INTEGER:
+
−			case Types.BIGINT:
+
−			case Types.FLOAT:
+
−			case Types.REAL:
+
−			case Types.DOUBLE:
+
−			case Types.NUMERIC:
+
−			case Types.DECIMAL:
+
−			case Types.CHAR:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−			case Types.BLOB:
+
−			case Types.DATE:
+
−			case Types.TIME:
+
−			case Types.TIME_WITH_TIMEZONE:
+
−			case Types.TIMESTAMP:
+
−			case Types.TIMESTAMP_WITH_TIMEZONE:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−		case Types.DATE:
+
−			switch (toType) {
+
−			case Types.CHAR:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−			case Types.DATE:
+
−			case Types.TIMESTAMP:
+
−			case Types.TIMESTAMP_WITH_TIMEZONE:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−		case Types.TIME:
+
−		case Types.TIME_WITH_TIMEZONE:
+
−			switch (toType) {
+
−			case Types.CHAR:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−			case Types.TIME:
+
−			case Types.TIME_WITH_TIMEZONE:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−		case Types.TIMESTAMP:
+
−		case Types.TIMESTAMP_WITH_TIMEZONE:
+
−			switch (toType) {
+
−			case Types.CHAR:
+
−			case Types.VARCHAR:
+
−		/*	case Types.LONGVARCHAR: is not supported by MonetDB and will fail */
+
−			case Types.CLOB:
+
−			case Types.DATE:
+
−			case Types.TIME:
+
−			case Types.TIME_WITH_TIMEZONE:
+
−			case Types.TIMESTAMP:
+
−			case Types.TIMESTAMP_WITH_TIMEZONE:
+
−				return true;
+
−			}
+
−			// conversion to all other types is not supported
+
−			return false;
+
−		}
+
−
+
−		// conversion from all other JDBC SQL types are not supported
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Are table correlation names supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsTableCorrelationNames() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * If table correlation names are supported, are they restricted to
+
−	 * be different from the names of the tables?
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsDifferentTableCorrelationNames() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Are expressions in "ORDER BY" lists supported?
+
−	 * e.g. select * from t order by a + b;
+
−	 *
+
−	 * MonetDB supports this, try:
+
−	 *  select (radix * 1000) + digits as comp, * from types order by (radix * 1000) + digits, -id;
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsExpressionsInOrderBy() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can an "ORDER BY" clause use columns not in the SELECT?
+
−	 * MonetDB differs from SQL03 =&gt; true
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsOrderByUnrelated() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is some form of "GROUP BY" clause supported?
+
−	 *
+
−	 * @return true since MonetDB supports it
+
−	 */
+
−	@Override
+
−	public boolean supportsGroupBy() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can a "GROUP BY" clause use columns not in the SELECT?
+
−	 *
+
−	 * @return true since that also is supported
+
−	 */
+
−	@Override
+
−	public boolean supportsGroupByUnrelated() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can a "GROUP BY" clause add columns not in the SELECT provided
+
−	 * it specifies all the columns in the SELECT?
+
−	 *
+
−	 * (MonetDB already supports the more difficult supportsGroupByUnrelated(),
+
−	 * so this is a piece of cake)
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsGroupByBeyondSelect() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is the escape character in "LIKE" clauses supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsLikeEscapeClause() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are multiple ResultSets from a single execute supported?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsMultipleResultSets() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can we have multiple transactions open at once (on different
+
−	 * connections?)
+
−	 * This is the main idea behind the Connection, is it?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsMultipleTransactions() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can columns be defined as non-nullable.
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsNonNullableColumns() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does this driver support the minimum ODBC SQL grammar.  This
+
−	 * grammar is defined at:
+
−	 *
+
−	 * http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odappcpr.asp
+
−	 * From this description, we seem to support the ODBC minimal (Level 0) grammar.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsMinimumSQLGrammar() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does this driver support the Core ODBC SQL grammar.	We need
+
−	 * SQL-92 conformance for this.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsCoreSQLGrammar() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does this driver support the Extended (Level 2) ODBC SQL
+
−	 * grammar.  We don't conform to the Core (Level 1), so we can't
+
−	 * conform to the Extended SQL Grammar.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsExtendedSQLGrammar() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does this driver support the ANSI-92 entry level SQL grammar?
+
−	 * All JDBC Compliant <sup>TM</sup> drivers must return true.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsANSI92EntryLevelSQL() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does this driver support the ANSI-92 intermediate level SQL
+
−	 * grammar?
+
−	 * probably not
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsANSI92IntermediateSQL() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does this driver support the ANSI-92 full SQL grammar?
+
−	 * Would be good if it was like that
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsANSI92FullSQL() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Is the SQL Integrity Enhancement Facility supported?
+
−	 *
+
−	 * The SQL Integrity Enhancement facility offers additional tools for referential integrity,
+
−	 * CHECK constraint clauses, and DEFAULT clauses. Referential integrity allows specification of
+
−	 * primary and foreign keys with the requirement that no foreign key row may be inserted or
+
−	 * updated unless a matching primary key row exists. Check clauses allow specification of
+
−	 * inter-column constraints to be maintained by the database system.
+
−	 * Default clauses provide optional default values for missing data.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsIntegrityEnhancementFacility() {
+
−		// Starting with release Aug2024 (11.51.1) MonetDB now also supports CHECK constraints (ref issue 3335, 3568).
+
−		return con.checkMinimumDBVersion(11, 51);
+
−	}
+
−
+
−	/**
+
−	 * Is some form of outer join supported?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsOuterJoins(){
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are full nested outer joins supported?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsFullOuterJoins() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is there limited support for outer joins?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsLimitedOuterJoins() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * What is the database vendor's preferred term for "schema"?
+
−	 * MonetDB uses the term "schema".
+
−	 *
+
−	 * @return the vendor term
+
−	 */
+
−	@Override
+
−	public String getSchemaTerm() {
+
−		return "schema";
+
−	}
+
−
+
−	/**
+
−	 * What is the database vendor's preferred term for "procedure"?
+
−	 *
+
−	 * @return the vendor term
+
−	 */
+
−	@Override
+
−	public String getProcedureTerm() {
+
−		return "procedure";
+
−	}
+
−
+
−	/**
+
−	 * What is the database vendor's preferred term for "catalog"?
+
−	 *
+
−	 * MonetDB doesn't support the SQL catalog naming concept.
+
−	 * Only SQL schemas are supported.
+
−	 * We also do not allow the name of a database to be included in
+
−	 * a fully qualified name, so we shouldn't return "database" here.
+
−	 * A database is a different concept than an SQL catalog.
+
−	 *
+
−	 * @return the vendor term
+
−	 */
+
−	@Override
+
−	public String getCatalogTerm() {
+
−		// MonetDB does NOT support catalogs, so also no catalog term
+
−		// Some generic SQL clients (e.g. DbVisualiser) use this string in their GUI
+
−		// To avoid NPE, just return an abrev string: "cat" (we like cats)
+
−		return "cat";
+
−	}
+
−
+
−	/**
+
−	 * Does a catalog appear at the start of a qualified table name?
+
−	 * (Otherwise it appears at the end).
+
−	 * Currently there is no catalog support at all in MonetDB
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean isCatalogAtStart() {
+
−		// return true here; we return false for every other catalog function
+
−		// so it won't matter what we return here
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * What is the Catalog separator.
+
−	 *
+
−	 * @return the catalog separator string
+
−	 */
+
−	@Override
+
−	public String getCatalogSeparator() {
+
−		// MonetDB does NOT support catalogs, so also no catalog separator
+
−		return null;
+
−	}
+
−
+
−	/**
+
−	 * Can a schema name be used in a data manipulation statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsSchemasInDataManipulation() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can a schema name be used in a procedure call statement?
+
−	 * Ohw probably, but I don't know of procedures in MonetDB
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsSchemasInProcedureCalls() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can a schema be used in a table definition statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsSchemasInTableDefinitions() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can a schema name be used in an index definition statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsSchemasInIndexDefinitions() {
+
−		// we currently do NOT support: create index sch.tblidx on sch.tbl(col);
+
−		// only: create index tblidx on sch.tbl(col);
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Can a schema name be used in a privilege definition statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsSchemasInPrivilegeDefinitions() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can a catalog name be used in a data manipulation statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsCatalogsInDataManipulation() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Can a catalog name be used in a procedure call statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsCatalogsInProcedureCalls() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Can a catalog name be used in a table definition statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsCatalogsInTableDefinitions() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Can a catalog name be used in an index definition?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsCatalogsInIndexDefinitions() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Can a catalog name be used in a privilege definition statement?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsCatalogsInPrivilegeDefinitions() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * MonetDB doesn't support positioned DELETEs I guess
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsPositionedDelete() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Is positioned UPDATE supported? (same as above)
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsPositionedUpdate() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Is SELECT FOR UPDATE supported?
+
−	 * My test resulted in a negative answer
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsSelectForUpdate(){
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Are stored procedure calls using the stored procedure escape
+
−	 * syntax supported?
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsStoredProcedures() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are subqueries in comparison expressions supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 * MonetDB also supports this
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsSubqueriesInComparisons() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are subqueries in 'exists' expressions supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsSubqueriesInExists() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are subqueries in 'in' statements supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsSubqueriesInIns() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are subqueries in quantified expressions supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * (No idea what this is, but we support a good deal of
+
−	 * subquerying.)
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsSubqueriesInQuantifieds() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are correlated subqueries supported?
+
−	 * A JDBC Compliant <sup>TM</sup> driver always returns true.
+
−	 *
+
−	 * (a.k.a. subselect in from?)
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsCorrelatedSubqueries() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is SQL UNION supported?
+
−	 * since 2004-03-20
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsUnion() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Is SQL UNION ALL supported?
+
−	 * since 2004-03-20
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsUnionAll() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * ResultSet objects (cursors) are not closed upon explicit or
+
−	 * implicit commit.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsOpenCursorsAcrossCommit() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Same as above
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsOpenCursorsAcrossRollback() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can statements remain open across commits?  They may, but
+
−	 * this driver cannot guarentee that.  In further reflection.
+
−	 * we are taking a Statement object here, so the answer is
+
−	 * yes, since the Statement is only a vehicle to execute some SQL
+
−	 *
+
−	 * @return true if they always remain open; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsOpenStatementsAcrossCommit() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Can statements remain open across rollbacks?  They may, but
+
−	 * this driver cannot guarentee that.  In further contemplation,
+
−	 * we are taking a Statement object here, so the answer is yes again.
+
−	 *
+
−	 * @return true if they always remain open; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsOpenStatementsAcrossRollback() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * How many hex characters can you have in an inline binary literal
+
−	 *
+
−	 * @return the max literal length
+
−	 */
+
−	@Override
+
−	public int getMaxBinaryLiteralLength() {
+
−		return 0x7ffffffe;	// MonetDB supports null terminated strings of max 2GB, see function: int UTF8_strlen()
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length for a character literal
+
−	 *
+
−	 * @return the max literal length
+
−	 */
+
−	@Override
+
−	public int getMaxCharLiteralLength() {
+
−		return 0x7ffffffe;	// MonetDB supports null terminated strings of max 2GB, see function: int UTF8_strlen()
+
−	}
+
−
+
−	/**
+
−	 * Whats the limit on column name length.
+
−	 * I take some safety here, but it's just a varchar in MonetDB
+
−	 *
+
−	 * @return the maximum column name length
+
−	 */
+
−	@Override
+
−	public int getMaxColumnNameLength() {
+
−		return 1024;	// In MonetDB the max length of column sys._columns.name is defined as 1024
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum number of columns in a "GROUP BY" clause?
+
−	 *
+
−	 * @return the max number of columns
+
−	 */
+
−	@Override
+
−	public int getMaxColumnsInGroupBy() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * What's the maximum number of columns allowed in an index?
+
−	 *
+
−	 * @return max number of columns
+
−	 */
+
−	@Override
+
−	public int getMaxColumnsInIndex() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * What's the maximum number of columns in an "ORDER BY clause?
+
−	 *
+
−	 * @return the max columns
+
−	 */
+
−	@Override
+
−	public int getMaxColumnsInOrderBy() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum number of columns in a "SELECT" list?
+
−	 *
+
−	 * @return the max columns
+
−	 */
+
−	@Override
+
−	public int getMaxColumnsInSelect() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum number of columns in a table?
+
−	 *
+
−	 * The theoretical max value of int column sys._columns.id is 2^31 -1
+
−	 * but this is for all columns of all tables in all schemas (including all data dictionary columns).
+
−	 * For one table we should reduce it to a more practical soft limit of say 100 thousand
+
−	 *
+
−	 * @return the max columns
+
−	 */
+
−	@Override
+
−	public int getMaxColumnsInTable() {
+
−		return 100*1000;	// soft limit it to 100 thousand
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the maximum number of concurrent connections to this database that are possible.
+
−	 *
+
−	 * @return the maximum number of active connections possible at one time; a result of zero means that there is no limit or the limit is not known
+
−	 */
+
−	@Override
+
−	public int getMaxConnections() throws SQLException {
+
−		return con.getMaxConnections();
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum cursor name length
+
−	 * Actually we do not do named cursors, so I keep the value small as
+
−	 * a precaution for maybe the future.
+
−	 *
+
−	 * @return max cursor name length in bytes
+
−	 */
+
−	@Override
+
−	public int getMaxCursorNameLength() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the maximum number of bytes for an index, including all
+
−	 * of the parts of the index.
+
−	 *
+
−	 * @return max index length in bytes, which includes the composite
+
−	 *         of all the constituent parts of the index; a result of zero
+
−	 *         means that there is no limit or the limit is not known
+
−	 */
+
−	@Override
+
−	public int getMaxIndexLength() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the maximum number of characters that this database
+
−	 * allows in a schema name.
+
−	 *
+
−	 * @return the number of characters or 0 if there is no limit, or the
+
−	 *         limit is unknown.
+
−	 */
+
−	@Override
+
−	public int getMaxSchemaNameLength() {
+
−		return 1024;	// In MonetDB the max length of column sys.schemas.name is defined as 1024
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length of a procedure name
+
−	 *
+
−	 * @return the max name length in bytes
+
−	 */
+
−	@Override
+
−	public int getMaxProcedureNameLength() {
+
−		return 256;	// In MonetDB the max length of column sys.functions.name is defined as 256
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length of a catalog
+
−	 *
+
−	 * @return the maximum number of characters allowed in a catalog name;
+
−	 * a result of zero means that there is no limit or the limit is not known
+
−	 */
+
−	@Override
+
−	public int getMaxCatalogNameLength() {
+
−		return 0;  // MonetDB does not support catalog names
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length of a single row?
+
−	 *
+
−	 * @return max row size in bytes
+
−	 */
+
−	@Override
+
−	public int getMaxRowSize() {
+
−		return 0;	// very long I hope...
+
−	}
+
−
+
−	/**
+
−	 * Did getMaxRowSize() include the SQL data types LONGVARCHAR and LONGVARBINARY
+
−	 * blobs?
+
−	 * Yes I thought so...
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean doesMaxRowSizeIncludeBlobs() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length of a SQL statement?
+
−	 *
+
−	 * @return max length in bytes
+
−	 */
+
−	@Override
+
−	public int getMaxStatementLength() {
+
−		return 0x7ffffffe;	// MonetDB supports null terminated strings of max 2GB, see function: int UTF8_strlen()
+
−	}
+
−
+
−	/**
+
−	 * How many active statements can we have open at one time to
+
−	 * this database?  Basically, since each Statement downloads
+
−	 * the results as the query is executed, we can have many.
+
−	 *
+
−	 * @return the maximum
+
−	 */
+
−	@Override
+
−	public int getMaxStatements() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length of a table name
+
−	 *
+
−	 * @return max name length in bytes
+
−	 */
+
−	@Override
+
−	public int getMaxTableNameLength() {
+
−		return 1024;	// In MonetDB the max length of column sys._tables.name is defined as 1024
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum number of tables that can be specified
+
−	 * in a SELECT?
+
−	 *
+
−	 * @return the maximum
+
−	 */
+
−	@Override
+
−	public int getMaxTablesInSelect() {
+
−		return 0;	// no specific limit known
+
−	}
+
−
+
−	/**
+
−	 * What is the maximum length of a user name
+
−	 *
+
−	 * @return the max name length in bytes
+
−	 */
+
−	@Override
+
−	public int getMaxUserNameLength() {
+
−		return 1024;	// In MonetDB the max length of column sys.db_user_info.name is defined as 1024
+
−	}
+
−
+
−	/**
+
−	 * What is the database's default transaction isolation level?
+
−	 * We only see commited data, nonrepeatable reads and phantom
+
−	 * reads can occur.
+
−	 *
+
−	 * @return the default isolation level
+
−	 * @see Connection
+
−	 */
+
−	@Override
+
−	public int getDefaultTransactionIsolation() {
+
−		return Connection.TRANSACTION_SERIALIZABLE;
+
−	}
+
−
+
−	/**
+
−	 * Are transactions supported?	If not, commit and rollback are noops
+
−	 * and the isolation level is TRANSACTION_NONE.  We do support
+
−	 * transactions.
+
−	 *
+
−	 * @return true if transactions are supported
+
−	 */
+
−	@Override
+
−	public boolean supportsTransactions() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Does the database support the given transaction isolation level?
+
−	 * We only support TRANSACTION_SERIALIZABLE as far as I know
+
−	 *
+
−	 * @param level the values are defined in java.sql.Connection
+
−	 * @return true if so
+
−	 * @see Connection
+
−	 */
+
−	@Override
+
−	public boolean supportsTransactionIsolationLevel(final int level) {
+
−		return level == Connection.TRANSACTION_SERIALIZABLE;
+
−	}
+
−
+
−	/**
+
−	 * Are both data definition and data manipulation transactions
+
−	 * supported?
+
−	 * Supposedly that data definition is like CREATE or ALTER TABLE
+
−	 * yes it is.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsDataDefinitionAndDataManipulationTransactions() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Are only data manipulation statements within a transaction
+
−	 * supported?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean supportsDataManipulationTransactionsOnly() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Does a data definition statement within a transaction force
+
−	 * the transaction to commit?  I think this means something like:
+
−	 *
+
−	 * <pre>
+
−	 * CREATE TABLE T (A INT);
+
−	 * INSERT INTO T (A) VALUES (2);
+
−	 * BEGIN TRANSACTION;
+
−	 * UPDATE T SET A = A + 1;
+
−	 * DROP TABLE IF EXISTS X;
+
−	 * CREATE TABLE X (A INT);
+
−	 * INSERT INTO X AS SELECT A FROM T;
+
−	 * SELECT A FROM X;
+
−	 * ROLLBACK;
+
−	 * SELECT A FROM T;
+
−	 * </pre>
+
−	 *
+
−	 * does the CREATE TABLE call cause a commit?  The answer is no.
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean dataDefinitionCausesTransactionCommit() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Is a data definition statement within a transaction ignored?
+
−	 *
+
−	 * @return true if so
+
−	 */
+
−	@Override
+
−	public boolean dataDefinitionIgnoredInTransactions() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Get a description of stored procedures available in a catalog
+
−	 *
+
−	 * <p>Only procedure descriptions matching the schema and procedure
+
−	 * name criteria are returned.	They are ordered by PROCEDURE_SCHEM,
+
−	 *  PROCEDURE_NAME and SPECIFIC_NAME.
+
−	 *
+
−	 * <p>Each procedure description has the following columns:
+
−	 * <ol>
+
−	 * <li><b>PROCEDURE_CAT</b> String =&gt; procedure catalog (may be null)
+
−	 * <li><b>PROCEDURE_SCHEM</b> String =&gt; procedure schema (may be null)
+
−	 * <li><b>PROCEDURE_NAME</b> String =&gt; procedure name
+
−	 * <li><b>Field4</b> reserved (make it null)
+
−	 * <li><b>Field5</b> reserved (make it null)
+
−	 * <li><b>Field6</b> reserved (make it null)
+
−	 * <li><b>REMARKS</b> String =&gt; explanatory comment on the procedure
+
−	 * <li><b>PROCEDURE_TYPE</b> short =&gt; kind of procedure
+
−	 *	<ul>
+
−	 *	  <li> procedureResultUnknown - May return a result
+
−	 *	  <li> procedureNoResult - Does not return a result
+
−	 *	  <li> procedureReturnsResult - Returns a result
+
−	 *	</ul>
+
−	 * <li><b>SPECIFIC_NAME</b> String =&gt; The name which uniquely identifies this procedure within its schema.
+
−	 * </ol>
+
−	 *
+
−	 * @param catalog - a catalog name; must match the catalog name as it is stored in the database;
+
−	 *	"" retrieves those without a catalog;
+
−	 *	null means that the catalog name should not be used to narrow the search
+
−	 * @param schemaPattern - a schema name pattern; must match the schema name as it is stored in the database;
+
−	 *	"" retrieves those without a schema;
+
−	 *	null means that the schema name should not be used to narrow the search
+
−	 * @param procedureNamePattern - a procedure name pattern; must match the procedure name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet - each row is a procedure description
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getProcedures(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String procedureNamePattern
+
−	) throws SQLException
+
−	{
+
−		final boolean useCommentsTable = con.commentsTableExists();
+
−		final StringBuilder query = new StringBuilder(980);
+
−		query.append("SELECT cast(null as char(1)) AS \"PROCEDURE_CAT\", " +
+
−			"s.\"name\" AS \"PROCEDURE_SCHEM\", " +
+
−			"f.\"name\" AS \"PROCEDURE_NAME\", " +
+
−			"cast(null as char(1)) AS \"Field4\", " +
+
−			"cast(null as char(1)) AS \"Field5\", " +
+
−			"cast(null as char(1)) AS \"Field6\", ")
+
−			.append(useCommentsTable ? "COALESCE(cm.\"remark\", cast(f.\"func\" as varchar(9999)))" : "cast(f.\"func\" as varchar(9999))").append(" AS \"REMARKS\", " +
+
−			// in MonetDB procedures have no return value by design.
+
−			"cast(" + DatabaseMetaData.procedureNoResult + " AS smallint) AS \"PROCEDURE_TYPE\", " +
+
−			// only the id value uniquely identifies a procedure. Include it to be able to differentiate between multiple overloaded procedures with the same name
+
−			"cast(f.\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " +
+
−		"FROM \"sys\".\"functions\" f " +
+
−		"JOIN \"sys\".\"schemas\" s ON f.\"schema_id\" = s.\"id\" ");
+
−		if (useCommentsTable) {
+
−			query.append("LEFT OUTER JOIN \"sys\".\"comments\" cm ON f.\"id\" = cm.\"id\" ");
+
−		}
+
−		// include procedures only (type = 2). Others will be returned via getFunctions()
+
−		query.append("WHERE f.\"type\" = 2");
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append(" AND s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−			}
+
−			if (procedureNamePattern != null && !procedureNamePattern.equals("%")) {
+
−				query.append(" AND f.\"name\" ").append(composeMatchPart(procedureNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"PROCEDURE_SCHEM\", \"PROCEDURE_NAME\", \"SPECIFIC_NAME\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of a catalog's stored procedure parameters
+
−	 * and result columns.
+
−	 *
+
−	 * <p>Only descriptions matching the schema, procedure and parameter name
+
−	 * criteria are returned. They are ordered by PROCEDURE_SCHEM, PROCEDURE_NAME
+
−	 * and SPECIFIC_NAME. Within this, the return value, if any, is first.
+
−	 * Next are the parameter descriptions in call order. The
+
−	 * column descriptions follow in column number order.
+
−	 *
+
−	 * <p>Each row in the ResultSet is a parameter description or column
+
−	 * description with the following fields:
+
−	 * <ol>
+
−	 * <li><b>PROCEDURE_CAT</b> String =&gt; procedure catalog (may be null)
+
−	 * <li><b>PROCEDURE_SCHEM</b> String =&gt; procedure schema (may be null)
+
−	 * <li><b>PROCEDURE_NAME</b> String =&gt; procedure name
+
−	 * <li><b>COLUMN_NAME</b> String =&gt; column/parameter name
+
−	 * <li><b>COLUMN_TYPE</b> Short =&gt; kind of column/parameter:
+
−	 * <ul><li>procedureColumnUnknown - nobody knows
+
−	 * <li>procedureColumnIn - IN parameter
+
−	 * <li>procedureColumnInOut - INOUT parameter
+
−	 * <li>procedureColumnOut - OUT parameter
+
−	 * <li>procedureColumnReturn - procedure return value
+
−	 * <li>procedureColumnResult - result column in ResultSet
+
−	 * </ul>
+
−	 * <li><b>DATA_TYPE</b> int =&gt; SQL type from java.sql.Types
+
−	 * <li><b>TYPE_NAME</b> String =&gt; SQL type name, for a UDT type the type name is fully qualified
+
−	 * <li><b>PRECISION</b> int =&gt; precision
+
−	 * <li><b>LENGTH</b> int =&gt; length in bytes of data
+
−	 * <li><b>SCALE</b> short =&gt; scale - null is returned for data types where SCALE is not applicable.
+
−	 * <li><b>RADIX</b> short =&gt; radix
+
−	 * <li><b>NULLABLE</b> short =&gt; can it contain NULL?
+
−	 * <ul><li>procedureNoNulls - does not allow NULL values
+
−	 * <li>procedureNullable - allows NULL values
+
−	 * <li>procedureNullableUnknown - nullability unknown
+
−	 * </ul>
+
−	 * <li><b>REMARKS</b> String =&gt; comment describing parameter/column
+
−	 * <li><b>COLUMN_DEF</b> String =&gt; default value for the column, which should be interpreted as a string when the value is enclosed in single quotes (may be null)
+
−	 *         The string NULL (not enclosed in quotes) - if NULL was specified as the default value
+
−	 *         TRUNCATE (not enclosed in quotes) - if the specified default value cannot be represented without truncation
+
−	 *         NULL - if a default value was not specified
+
−	 * <li><b>SQL_DATA_TYPE</b> int =&gt; reserved for future use
+
−	 * <li><b>SQL_DATETIME_SUB</b> int =&gt; reserved for future use
+
−	 * <li><b>CHAR_OCTET_LENGTH</b> int =&gt; the maximum length of binary and character based columns. For any other datatype the returned value is a NULL
+
−	 * <li><b>ORDINAL_POSITION</b> int =&gt; the ordinal position, starting from 1, for the input and output parameters for a procedure.
+
−	 *	A value of 0 is returned if this row describes the procedure's return value. For result set columns, it is the ordinal position of the
+
−	 *	column in the result set starting from 1. If there are multiple result sets, the column ordinal positions are implementation defined.
+
−	 * <li><b>IS_NULLABLE</b> String =&gt; ISO rules are used to determine the nullability for a column.
+
−	 * <ul><li>YES --- if the parameter can include NULLs
+
−	 * <li>NO --- if the parameter cannot include NULLs
+
−	 * <li>empty string --- if the nullability for the parameter is unknown
+
−	 * </ul>
+
−	 * <li><b>SPECIFIC_NAME</b> String =&gt; the name which uniquely identifies this procedure within its schema.
+
−	 * </ol>
+
−	 * @param catalog - a catalog name; must match the catalog name as it is stored in the database;
+
−	 *	"" retrieves those without a catalog;
+
−	 *	null means that the catalog name should not be used to narrow the search
+
−	 * @param schemaPattern - a schema name pattern; must match the schema name as it is stored in the database;
+
−	 *	"" retrieves those without a schema;
+
−	 *	null means that the schema name should not be used to narrow the search
+
−	 * @param procedureNamePattern - a procedure name pattern; must match the procedure name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param columnNamePattern - a column name pattern; must match the column name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet - each row describes a stored procedure parameter or column
+
−	 * @throws SQLException if a database-access error occurs
+
−	 * @see #getSearchStringEscape
+
−	 */
+
−	@Override
+
−	public ResultSet getProcedureColumns(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String procedureNamePattern,
+
−		final String columnNamePattern
+
−	) throws SQLException {
+
−		final StringBuilder query = new StringBuilder(2900);
+
−		query.append("SELECT cast(null as char(1)) AS \"PROCEDURE_CAT\", " +
+
−			"s.\"name\" AS \"PROCEDURE_SCHEM\", " +
+
−			"f.\"name\" AS \"PROCEDURE_NAME\", " +
+
−			"a.\"name\" AS \"COLUMN_NAME\", " +
+
−			"cast(CASE a.\"inout\"" +
+
−				" WHEN 0 THEN (CASE a.\"number\" WHEN 0 THEN " + DatabaseMetaData.procedureColumnReturn + " ELSE " + DatabaseMetaData.procedureColumnOut + " END)" +
+
−				" WHEN 1 THEN " + DatabaseMetaData.procedureColumnIn +
+
−				" ELSE " + DatabaseMetaData.procedureColumnUnknown + " END AS smallint) AS \"COLUMN_TYPE\", " +
+
−			"cast(").append(MonetDriver.getSQLTypeMap("a.\"type\"")).append(" AS int) AS \"DATA_TYPE\", " +
+
−			"a.\"type\" AS \"TYPE_NAME\", " +
+
−			"CASE a.\"type\" WHEN 'tinyint' THEN 3 WHEN 'smallint' THEN 5 WHEN 'int' THEN 10 WHEN 'bigint' THEN 19" +
+
−				" WHEN 'hugeint' THEN 38 WHEN 'oid' THEN 19 WHEN 'wrd' THEN 19 ELSE a.\"type_digits\" END AS \"PRECISION\", " +
+
−			"CASE a.\"type\" WHEN 'tinyint' THEN 1 WHEN 'smallint' THEN 2 WHEN 'int' THEN 4 WHEN 'bigint' THEN 8" +
+
−				" WHEN 'hugeint' THEN 16 WHEN 'oid' THEN 8 WHEN 'wrd' THEN 8 ELSE a.\"type_digits\" END AS \"LENGTH\", " +
+
−			"cast(CASE WHEN a.\"type\" IN ('tinyint','smallint','int','bigint','hugeint','oid','wrd','decimal','numeric'," +
+
−				"'time','timetz','timestamp','timestamptz','day_interval','month_interval','sec_interval') THEN a.\"type_scale\" ELSE NULL END AS smallint) AS \"SCALE\", " +
+
−			"cast(CASE WHEN a.\"type\" IN ('tinyint','smallint','int','bigint','hugeint','oid','wrd','decimal','numeric','day_interval','month_interval','sec_interval') THEN 10" +
+
−				" WHEN a.\"type\" IN ('real','float','double') THEN 2 ELSE NULL END AS smallint) AS \"RADIX\", " +
+
−			// mvd: do not remove next append. The String above is same as used by getFunctionColumns, so shared in class file.
+
−			"cast(").append(DatabaseMetaData.procedureNullableUnknown).append(" AS smallint) AS \"NULLABLE\", " +
+
−			"cast(null as char(1)) AS \"REMARKS\", " +
+
−			"cast(null as char(1)) AS \"COLUMN_DEF\", " +
+
−			"cast(0 as int) AS \"SQL_DATA_TYPE\", " +
+
−			"cast(0 as int) AS \"SQL_DATETIME_SUB\", " +
+
−			"cast(CASE WHEN a.\"type\" IN ('varchar','clob','char','json','url','xml') THEN 4 * cast(a.\"type_digits\" as bigint) WHEN a.\"type\" = 'blob' THEN a.\"type_digits\" ELSE NULL END as bigint) AS \"CHAR_OCTET_LENGTH\", " +
+
−			// in MonetDB procedures have no return value by design. The arguments in sys.args are numbered from 0 so we must add 1 to comply with the API specification.
+
−			"cast(a.\"number\" + 1 as int) AS \"ORDINAL_POSITION\", " +
+
−			"cast('' as varchar(3)) AS \"IS_NULLABLE\", " +
+
−			// the specific name contains the function id, in order to be able to match the args to the correct overloaded procedure name
+
−			"cast(f.\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " +
+
−		"FROM \"sys\".\"args\" a " +
+
−		"JOIN \"sys\".\"functions\" f ON a.\"func_id\" = f.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON f.\"schema_id\" = s.\"id\" " +
+
−		// include procedures only (type = 2). Others will be returned via getFunctionColumns()
+
−		"WHERE f.\"type\" = 2");
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append(" AND s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−			}
+
−			if (procedureNamePattern != null && !procedureNamePattern.equals("%")) {
+
−				query.append(" AND f.\"name\" ").append(composeMatchPart(procedureNamePattern));
+
−			}
+
−			if (columnNamePattern != null && !columnNamePattern.equals("%")) {
+
−				query.append(" AND a.\"name\" ").append(composeMatchPart(columnNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"PROCEDURE_SCHEM\", \"PROCEDURE_NAME\", \"SPECIFIC_NAME\", \"ORDINAL_POSITION\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the tables available in the given catalog.
+
−	 * Only table descriptions matching the catalog, schema, table name and type criteria are returned.
+
−	 * They are ordered by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM and TABLE_NAME.
+
−	 *
+
−	 * <p>Each table description has the following columns:
+
−	 *
+
−	 * <ol>
+
−	 * <li><b>TABLE_CAT</b> String =&gt; table catalog (may be null)
+
−	 * <li><b>TABLE_SCHEM</b> String =&gt; table schema (may be null)
+
−	 * <li><b>TABLE_NAME</b> String =&gt; table name
+
−	 * <li><b>TABLE_TYPE</b> String =&gt; table type. Typical types are "TABLE",
+
−	 * "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
+
−	 * <li><b>REMARKS</b> String =&gt; explanatory comment on the table
+
−	 * <li><b>TYPE_CAT</b> String =&gt; the types catalog (may be null)
+
−	 * <li><b>TYPE_SCHEM</b> String =&gt; the types schema (may be null)
+
−	 * <li><b>TYPE_NAME</b> String =&gt; type name (may be null)
+
−	 * <li><b>SELF_REFERENCING_COL_NAME</b> String =&gt; name of the designated "identifier" column of a typed table (may be null)
+
−	 * <li><b>REF_GENERATION</b> String =&gt; specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null)
+
−	 * </ol>
+
−	 *
+
−	 * @param catalog - a catalog name; must match the catalog name as it is stored in the database;
+
−	 *	"" retrieves those without a catalog; null means that the
+
−	 *	catalog name should not be used to narrow the search
+
−	 * @param schemaPattern - a schema name pattern; must match the schema name as it is stored
+
−	 *	in the database; "" retrieves those without a schema;
+
−	 *	null means that the schema name should not be used to narrow the search
+
−	 * @param tableNamePattern - a table name pattern; must match the table name as it is stored in the database
+
−	 *	For all tables this should be "%"
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param types - a list of table types, which must be from the list of table types returned
+
−	 *	from getTableTypes(),to include; null returns all types
+
−	 * @return ResultSet - each row is a table description
+
−	 * @throws SQLException if a database-access error occurs.
+
−	 */
+
−	@Override
+
−	public ResultSet getTables(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String tableNamePattern,
+
−		final String types[]
+
−	) throws SQLException
+
−	{
+
−		final boolean useCommentsTable = con.commentsTableExists();
+
−		final StringBuilder query = new StringBuilder(1600);
+
−		query.append("SELECT cast(null as char(1)) AS \"TABLE_CAT\", " +
+
−			"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−			"t.\"name\" AS \"TABLE_NAME\", " +
+
−			"tt.\"table_type_name\" AS \"TABLE_TYPE\", ")
+
−		.append(useCommentsTable ? "COALESCE(cm.\"remark\", t.\"query\")" : "t.\"query\"")
+
−		.append(" AS \"REMARKS\", " +
+
−			"cast(null as char(1)) AS \"TYPE_CAT\", " +
+
−			"cast(null as char(1)) AS \"TYPE_SCHEM\", " +
+
−			"cast(null as char(1)) AS \"TYPE_NAME\", " +
+
−			"cast(null as char(1)) AS \"SELF_REFERENCING_COL_NAME\", " +
+
−			"cast(null as char(1)) AS \"REF_GENERATION\" " +
+
−			"FROM \"sys\".\"tables\" t " +
+
−			"JOIN \"sys\".\"table_types\" tt ON t.\"type\" = tt.\"table_type_id\" " +
+
−			"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" ");
+
−		if (useCommentsTable) {
+
−			query.append("LEFT OUTER JOIN \"sys\".\"comments\" cm ON t.\"id\" = cm.\"id\" ");
+
−		}
+
−
+
−		boolean needWhere = true;
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append("WHERE 1=0");
+
−			needWhere = false;
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append("WHERE s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−				needWhere = false;
+
−			}
+
−			if (tableNamePattern != null && !tableNamePattern.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" t.\"name\" ").append(composeMatchPart(tableNamePattern));
+
−				needWhere = false;
+
−			}
+
−		}
+
−
+
−		if (types != null && types.length > 0) {
+
−			boolean foundType = false;
+
−			query.append(needWhere ? "WHERE" : " AND").append(" tt.\"table_type_name\" IN (");
+
−			for (int i = 0; i < types.length; i++) {
+
−				String tabletype = types[i];
+
−				if (tabletype != null && !tabletype.isEmpty()) {
+
−					/* Some JDBC applications use different table type names.
+
−					 * Replace some SQL synonyms to valid MonetDB
+
−					 * table type names as defined in sys.table_types */
+
−					if ("BASE TABLE".equals(tabletype)) {
+
−						tabletype = "TABLE";
+
−					} else
+
−					if ("GLOBAL TEMPORARY".equals(tabletype)) {
+
−						tabletype = "GLOBAL TEMPORARY TABLE";
+
−					} else
+
−					if ("LOCAL TEMPORARY".equals(tabletype)) {
+
−						tabletype = "LOCAL TEMPORARY TABLE";
+
−					}
+
−					if (foundType) {
+
−						query.append(',');
+
−					}
+
−					query.append('\'').append(tabletype).append('\'');
+
−					foundType = true;
+
−				}
+
−			}
+
−			if (!foundType) {
+
−				// we need to have at least one literal in the SQL IN-list else we get a syntax error
+
−				query.append("''");
+
−			}
+
−			query.append(')');
+
−			// for debug: System.out.println("SQL (len " + query.length() + "): " + query);
+
−		}
+
−
+
−		query.append(" ORDER BY \"TABLE_TYPE\", \"TABLE_SCHEM\", \"TABLE_NAME\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get the schema names available in this database.  The results
+
−	 * are ordered by schema name.
+
−	 *
+
−	 * <P>The schema column is:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; schema name
+
−	 *	<LI><B>TABLE_CATALOG</B> String =&gt; catalog name (may be null)
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; must match the catalog name as it
+
−	 *        is stored in the database;"" retrieves those without a
+
−	 *        catalog; null means catalog name should not be used to
+
−	 *        narrow down the search.
+
−	 * @param schemaPattern a schema name; must match the schema name as
+
−	 *        it is stored in the database; null means schema name
+
−	 *        should not be used to narrow down the search.
+
−	 * @return ResultSet each row has a single String column that is a
+
−	 *         schema name
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getSchemas(final String catalog, final String schemaPattern)
+
−		throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(170);
+
−		query.append("SELECT \"name\" AS \"TABLE_SCHEM\", " +
+
−				"cast(null as char(1)) AS \"TABLE_CATALOG\" " +
+
−			"FROM \"sys\".\"schemas\" ");
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append("WHERE 1=0");
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append("WHERE \"name\" ").append(composeMatchPart(schemaPattern));
+
−			}
+
−		}
+
−		query.append(" ORDER BY \"TABLE_SCHEM\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get the catalog names available in this database.  The results
+
−	 * are ordered by catalog name.
+
−	 *
+
−	 * <P>The catalog column is:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; catalog name
+
−	 *	</OL>
+
−	 *
+
−	 *
+
−	 * @return ResultSet each row has a single String column that is a
+
−	 *         catalog name
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getCatalogs() throws SQLException {
+
−		// MonetDB does NOT support catalogs.
+
−		// Return a resultset with no rows
+
−		return executeMetaDataQuery("SELECT cast(null as char(1)) AS \"TABLE_CAT\" WHERE 1=0");
+
−	}
+
−
+
−	/**
+
−	 * Get the table types available in this database.
+
−	 * The results are ordered by table type.
+
−	 *
+
−	 * <P>The table type is:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_TYPE</B> String =&gt; table type.  Typical types are "TABLE",
+
−	 *			"VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY",
+
−	 *			"LOCAL TEMPORARY", "ALIAS", "SYNONYM".
+
−	 *	</OL>
+
−	 *
+
−	 * @return ResultSet each row has a single String column that is a table type
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getTableTypes() throws SQLException {
+
−		return executeMetaDataQuery("SELECT \"table_type_name\" AS \"TABLE_TYPE\" FROM \"sys\".\"table_types\" ORDER BY 1");
+
−	}
+
−
+
−	/**
+
−	 * Get a description of table columns available in a catalog.
+
−	 *
+
−	 * <P>Only column descriptions matching the catalog, schema, table
+
−	 * and column name criteria are returned.  They are ordered by
+
−	 * TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
+
−	 *
+
−	 * <P>Each column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null)
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
+
−	 *	<LI><B>TABLE_NAME</B> String =&gt; table name
+
−	 *	<LI><B>COLUMN_NAME</B> String =&gt; column name
+
−	 *	<LI><B>DATA_TYPE</B> int =&gt; SQL type from java.sql.Types
+
−	 *	<LI><B>TYPE_NAME</B> String =&gt; Data source dependent type name
+
−	 *	<LI><B>COLUMN_SIZE</B> int =&gt; column size.	For char or date
+
−	 *		types this is the maximum number of characters, for numeric or
+
−	 *		decimal types this is precision.
+
−	 *	<LI><B>BUFFER_LENGTH</B> is not used.
+
−	 *	<LI><B>DECIMAL_DIGITS</B> int =&gt; the number of fractional digits
+
−	 *	<LI><B>NUM_PREC_RADIX</B> int =&gt; Radix (typically either 10 or 2)
+
−	 *	<LI><B>NULLABLE</B> int =&gt; is NULL allowed?
+
−	 *		<UL>
+
−	 *		<LI> columnNoNulls - might not allow NULL values
+
−	 *		<LI> columnNullable - definitely allows NULL values
+
−	 *		<LI> columnNullableUnknown - nullability unknown
+
−	 *		</UL>
+
−	 *	<LI><B>REMARKS</B> String =&gt; comment describing column (may be null)
+
−	 *	<LI><B>COLUMN_DEF</B> String =&gt; default value (may be null)
+
−	 *	<LI><B>SQL_DATA_TYPE</B> int =&gt; unused
+
−	 *	<LI><B>SQL_DATETIME_SUB</B> int =&gt; unused
+
−	 *	<LI><B>CHAR_OCTET_LENGTH</B> int =&gt; for char types the
+
−	 *		 maximum number of bytes in the column
+
−	 *	<LI><B>ORDINAL_POSITION</B> int =&gt; index of column in table
+
−	 *		(starting at 1)
+
−	 *	<LI><B>IS_NULLABLE</B> String =&gt; "NO" means column definitely
+
−	 *		does not allow NULL values; "YES" means the column might
+
−	 *		allow NULL values.	An empty string means nobody knows.
+
−	 *	<LI><B>SCOPE_CATALOG</B> String =&gt; catalog of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
+
−	 *	<LI><B>SCOPE_SCHEMA</B> String =&gt; schema of table that is the scope of a reference attribute (null if the DATA_TYPE isn't REF)
+
−	 *	<LI><B>SCOPE_TABLE</B> String =&gt; table name that this the scope of a reference attribute (null if the DATA_TYPE isn't REF)
+
−	 *	<LI><B>SOURCE_DATA_TYPE</B> short =&gt; source type of a distinct type or user-generated Ref type,
+
−	 *		SQL type from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)
+
−	 *	<LI><B>IS_AUTOINCREMENT</B> String =&gt; Indicates whether this column is auto incremented
+
−	 *		<UL>
+
−	 *		<LI> YES --- if the column is auto incremented
+
−	 *		<LI> NO --- if the column is not auto incremented
+
−	 *		<LI> empty string --- if it cannot be determined whether the column is auto incremented
+
−	 *		</UL>
+
−	 *	<LI><B>IS_GENERATEDCOLUMN</B> String =&gt; Indicates whether this is a generated column
+
−	 *		<UL>
+
−	 *		<LI> YES --- if this a generated column
+
−	 *		<LI> NO --- if this not a generated column
+
−	 *		<LI> empty string --- if it cannot be determined whether this is a generated column
+
−	 *		</UL>
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog - a catalog name; must match the catalog name as it is stored in the database;
+
−	 *	"" retrieves those without a catalog; null means that the
+
−	 *	catalog name should not be used to narrow the search
+
−	 * @param schemaPattern - a schema name pattern; must match the schema name as it is stored
+
−	 *	in the database; "" retrieves those without a schema;
+
−	 *	null means that the schema name should not be used to narrow the search
+
−	 * @param tableNamePattern - a table name pattern; must match the table name as it is stored in the database
+
−	 *	For all tables this should be "%"
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param columnNamePattern - a column name pattern; must match the column name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet - each row is a column description
+
−	 * @throws SQLException if a database error occurs
+
−	 * @see #getSearchStringEscape
+
−	 */
+
−	@Override
+
−	public ResultSet getColumns(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String tableNamePattern,
+
−		final String columnNamePattern
+
−	) throws SQLException
+
−	{
+
−		final boolean useCommentsTable = con.commentsTableExists();
+
−		final StringBuilder query = new StringBuilder(2450);
+
−		query.append("SELECT cast(null as char(1)) AS \"TABLE_CAT\", " +
+
−			"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−			"t.\"name\" AS \"TABLE_NAME\", " +
+
−			"c.\"name\" AS \"COLUMN_NAME\", " +
+
−			"cast(").append(MonetDriver.getSQLTypeMap("c.\"type\"")).append(" AS int) AS \"DATA_TYPE\", " +
+
−			"c.\"type\" AS \"TYPE_NAME\", " +
+
−			"c.\"type_digits\" AS \"COLUMN_SIZE\", " +
+
−			"cast(0 as int) AS \"BUFFER_LENGTH\", " +
+
−			"c.\"type_scale\" AS \"DECIMAL_DIGITS\", " +
+
−			"cast(CASE WHEN c.\"type\" IN ('decimal','numeric','day_interval','month_interval','sec_interval') THEN 10 " +
+
−				"WHEN c.\"type\" IN ('int','smallint','tinyint','bigint','hugeint','float','real','double','oid','wrd') THEN 2 " +
+
−				"ELSE 0 END AS int) AS \"NUM_PREC_RADIX\", " +
+
−			"cast(CASE c.\"null\" WHEN true THEN " + ResultSetMetaData.columnNullable +
+
−				" WHEN false THEN " + ResultSetMetaData.columnNoNulls +
+
−				" ELSE " + ResultSetMetaData.columnNullableUnknown +
+
−				" END AS int) AS \"NULLABLE\", ")
+
−			.append(useCommentsTable ? "cm.\"remark\"" : "cast(null AS varchar(9999))").append(" AS \"REMARKS\", " +
+
−			"c.\"default\" AS \"COLUMN_DEF\", " +
+
−			"cast(0 as int) AS \"SQL_DATA_TYPE\", " +
+
−			"cast(0 as int) AS \"SQL_DATETIME_SUB\", " +
+
−			"cast(CASE WHEN c.\"type\" IN ('varchar','clob','char','json','url','xml') THEN 4 * cast(c.\"type_digits\" as bigint) ELSE NULL END as bigint) AS \"CHAR_OCTET_LENGTH\", " +
+
−			"cast(c.\"number\" + 1 as int) AS \"ORDINAL_POSITION\", " +
+
−			"cast(CASE c.\"null\" WHEN true THEN 'YES' WHEN false THEN 'NO' ELSE '' END AS varchar(3)) AS \"IS_NULLABLE\", " +
+
−			"cast(null AS char(1)) AS \"SCOPE_CATALOG\", " +
+
−			"cast(null AS char(1)) AS \"SCOPE_SCHEMA\", " +
+
−			"cast(null AS char(1)) AS \"SCOPE_TABLE\", " +
+
−			"cast(null AS smallint) AS \"SOURCE_DATA_TYPE\", " +
+
−			"cast(CASE WHEN c.\"default\" IS NOT NULL AND c.\"default\" LIKE 'next value for %' THEN 'YES' ELSE 'NO' END AS varchar(3)) AS \"IS_AUTOINCREMENT\", " +
+
−			"cast('NO' AS varchar(3)) AS \"IS_GENERATEDCOLUMN\" " +
+
−		"FROM \"sys\".\"columns\" c " +
+
−		"JOIN \"sys\".\"tables\" t ON c.\"table_id\" = t.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" ");
+
−		if (useCommentsTable) {
+
−			query.append("LEFT OUTER JOIN \"sys\".\"comments\" cm ON c.\"id\" = cm.\"id\" ");
+
−		}
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append("WHERE 1=0");
+
−		} else {
+
−			boolean needWhere = true;
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append("WHERE s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−				needWhere = false;
+
−			}
+
−			if (tableNamePattern != null && !tableNamePattern.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" t.\"name\" ").append(composeMatchPart(tableNamePattern));
+
−				needWhere = false;
+
−			}
+
−			if (columnNamePattern != null && !columnNamePattern.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" c.\"name\" ").append(composeMatchPart(columnNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"TABLE_SCHEM\", \"TABLE_NAME\", \"ORDINAL_POSITION\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of the access rights for a table's columns.
+
−	 * MonetDB doesn't have this level of access rights.
+
−	 *
+
−	 * <P>Only privileges matching the column name criteria are
+
−	 * returned.  They are ordered by COLUMN_NAME and PRIVILEGE.
+
−	 *
+
−	 * <P>Each privilige description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null)
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
+
−	 *	<LI><B>TABLE_NAME</B> String =&gt; table name
+
−	 *	<LI><B>COLUMN_NAME</B> String =&gt; column name
+
−	 *	<LI><B>GRANTOR</B> =&gt; grantor of access (may be null)
+
−	 *	<LI><B>GRANTEE</B> String =&gt; grantee of access
+
−	 *	<LI><B>PRIVILEGE</B> String =&gt; name of access (SELECT,
+
−	 *		INSERT, UPDATE, REFRENCES, ...)
+
−	 *	<LI><B>IS_GRANTABLE</B> String =&gt; "YES" if grantee is permitted
+
−	 *		to grant to others; "NO" if not; null if unknown
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schemaPattern a schema name; "" retrieves those without a schema
+
−	 * @param tableNamePattern a table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param columnNamePattern a column name pattern
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a column privilege description
+
−	 * @see #getSearchStringEscape
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getColumnPrivileges(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String tableNamePattern,
+
−		final String columnNamePattern
+
−	) throws SQLException
+
−	{
+
−		final boolean usePrivilege_codesTable = con.privilege_codesTableExists();
+
−		final StringBuilder query = new StringBuilder(1100);
+
−		query.append("SELECT cast(null as char(1)) AS \"TABLE_CAT\", " +
+
−			"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−			"t.\"name\" AS \"TABLE_NAME\", " +
+
−			"c.\"name\" AS \"COLUMN_NAME\", " +
+
−			"grantors.\"name\" AS \"GRANTOR\", " +
+
−			"grantees.\"name\" AS \"GRANTEE\", ")
+
−		.append(usePrivilege_codesTable ? "pc.\"privilege_code_name\"" :
+
−			"cast(CASE p.\"privileges\" " +
+
−				"WHEN 1 THEN 'SELECT' " +
+
−				"WHEN 2 THEN 'UPDATE' " +
+
−				"WHEN 4 THEN 'INSERT' " +
+
−				"WHEN 8 THEN 'DELETE' " +
+
−				"WHEN 16 THEN 'EXECUTE' " +
+
−				"WHEN 32 THEN 'GRANT' " +
+
−				"ELSE NULL " +
+
−			"END AS varchar(7))").append(" AS \"PRIVILEGE\", " +
+
−			"cast(CASE p.\"grantable\" " +
+
−				"WHEN 0 THEN 'NO' " +
+
−				"WHEN 1 THEN 'YES' " +
+
−				"ELSE NULL " +
+
−			"END AS varchar(3)) AS \"IS_GRANTABLE\" " +
+
−		"FROM \"sys\".\"privileges\" p " +
+
−		"JOIN \"sys\".\"columns\" c ON p.\"obj_id\" = c.\"id\" " +
+
−		"JOIN \"sys\".\"tables\" t ON c.\"table_id\" = t.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−		"JOIN \"sys\".\"auths\" grantors ON p.\"grantor\" = grantors.\"id\" " +
+
−		"JOIN \"sys\".\"auths\" grantees ON p.\"auth_id\" = grantees.\"id\" ");
+
−		if (usePrivilege_codesTable) {
+
−			query.append("JOIN \"sys\".\"privilege_codes\" pc ON p.\"privileges\" = pc.\"privilege_code_id\" ");
+
−		}
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append("WHERE 1=0");
+
−		} else {
+
−			boolean needWhere = true;
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append("WHERE s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−				needWhere = false;
+
−			}
+
−			if (tableNamePattern != null && !tableNamePattern.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" t.\"name\" ").append(composeMatchPart(tableNamePattern));
+
−				needWhere = false;
+
−			}
+
−			if (columnNamePattern != null && !columnNamePattern.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" c.\"name\" ").append(composeMatchPart(columnNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"TABLE_SCHEM\", \"TABLE_NAME\", \"COLUMN_NAME\", \"PRIVILEGE\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of the access rights for each table available
+
−	 * in a catalog.
+
−	 *
+
−	 * <P>Only privileges matching the schema and table name
+
−	 * criteria are returned.  They are ordered by TABLE_SCHEM,
+
−	 * TABLE_NAME, and PRIVILEGE.
+
−	 *
+
−	 * <P>Each privilege description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null)
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
+
−	 *	<LI><B>TABLE_NAME</B> String =&gt; table name
+
−	 *	<LI><B>GRANTOR</B> =&gt; grantor of access (may be null)
+
−	 *	<LI><B>GRANTEE</B> String =&gt; grantee of access
+
−	 *	<LI><B>PRIVILEGE</B> String =&gt; name of access (SELECT,
+
−	 *		INSERT, UPDATE, REFRENCES, ...)
+
−	 *	<LI><B>IS_GRANTABLE</B> String =&gt; "YES" if grantee is permitted
+
−	 *		to grant to others; "NO" if not; null if unknown
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schemaPattern a schema name pattern; "" retrieves those without a schema
+
−	 * @param tableNamePattern a table name pattern
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a table privilege description
+
−	 * @see #getSearchStringEscape
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getTablePrivileges(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String tableNamePattern
+
−	) throws SQLException
+
−	{
+
−		final boolean usePrivilege_codesTable = con.privilege_codesTableExists();
+
−		final StringBuilder query = new StringBuilder(1000);
+
−		query.append("SELECT cast(null as char(1)) AS \"TABLE_CAT\", " +
+
−			"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−			"t.\"name\" AS \"TABLE_NAME\", " +
+
−			"grantors.\"name\" AS \"GRANTOR\", " +
+
−			"grantees.\"name\" AS \"GRANTEE\", ")
+
−		.append(usePrivilege_codesTable ? "pc.\"privilege_code_name\"" :
+
−			"cast(CASE p.\"privileges\" " +
+
−				"WHEN 1 THEN 'SELECT' " +
+
−				"WHEN 2 THEN 'UPDATE' " +
+
−				"WHEN 4 THEN 'INSERT' " +
+
−				"WHEN 8 THEN 'DELETE' " +
+
−				"WHEN 16 THEN 'EXECUTE' " +
+
−				"WHEN 32 THEN 'GRANT' " +
+
−				"ELSE NULL " +
+
−			"END AS varchar(7))").append(" AS \"PRIVILEGE\", " +
+
−			"cast(CASE p.\"grantable\" " +
+
−				"WHEN 0 THEN 'NO' " +
+
−				"WHEN 1 THEN 'YES' " +
+
−				"ELSE NULL " +
+
−			"END AS varchar(3)) AS \"IS_GRANTABLE\" " +
+
−		"FROM \"sys\".\"privileges\" p " +
+
−		"JOIN \"sys\".\"tables\" t ON p.\"obj_id\" = t.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−		"JOIN \"sys\".\"auths\" grantors ON p.\"grantor\" = grantors.\"id\" " +
+
−		"JOIN \"sys\".\"auths\" grantees ON p.\"auth_id\" = grantees.\"id\" ");
+
−		if (usePrivilege_codesTable) {
+
−			query.append("JOIN \"sys\".\"privilege_codes\" pc ON p.\"privileges\" = pc.\"privilege_code_id\" ");
+
−		}
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append("WHERE 1=0");
+
−		} else {
+
−			boolean needWhere = true;
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append("WHERE s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−				needWhere = false;
+
−			}
+
−			if (tableNamePattern != null && !tableNamePattern.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" t.\"name\" ").append(composeMatchPart(tableNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"TABLE_SCHEM\", \"TABLE_NAME\", \"PRIVILEGE\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of a table's optimal set of columns that
+
−	 * uniquely identifies a row. They are ordered by SCOPE.
+
−	 *
+
−	 * <P>Each column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>SCOPE</B> short =&gt; actual scope of result
+
−	 *		<UL>
+
−	 *		<LI> bestRowTemporary - very temporary, while using row
+
−	 *		<LI> bestRowTransaction - valid for remainder of current transaction
+
−	 *		<LI> bestRowSession - valid for remainder of current session
+
−	 *		</UL>
+
−	 *	<LI><B>COLUMN_NAME</B> String =&gt; column name
+
−	 *	<LI><B>DATA_TYPE</B> int =&gt; SQL data type from java.sql.Types
+
−	 *	<LI><B>TYPE_NAME</B> String =&gt; Data source dependent type name
+
−	 *	<LI><B>COLUMN_SIZE</B> int =&gt; precision
+
−	 *	<LI><B>BUFFER_LENGTH</B> int =&gt; not used
+
−	 *	<LI><B>DECIMAL_DIGITS</B> short  =&gt; scale
+
−	 *	<LI><B>PSEUDO_COLUMN</B> short =&gt; is this a pseudo column
+
−	 *		like an Oracle ROWID
+
−	 *		<UL>
+
−	 *		<LI> bestRowUnknown - may or may not be pseudo column
+
−	 *		<LI> bestRowNotPseudo - is NOT a pseudo column
+
−	 *		<LI> bestRowPseudo - is a pseudo column
+
−	 *		</UL>
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schema a schema name; "" retrieves those without a schema
+
−	 * @param table a table name
+
−	 * @param scope the scope of interest; use same values as SCOPE
+
−	 * @param nullable include columns that are nullable?
+
−	 * @return ResultSet each row is a column description
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getBestRowIdentifier(
+
−		final String catalog,
+
−		final String schema,
+
−		final String table,
+
−		final int scope,
+
−		final boolean nullable
+
−	) throws SQLException
+
−	{
+
−		/* determine if we need to include a query against the tmp.* tables also */
+
−		final boolean incltmpkey = (schema == null)
+
−					|| (schema != null && ("tmp".equals(schema) || schema.contains("%") || schema.contains("_")));
+
−
+
−		/* When there is a PK for the table we return the pkey columns
+
−		 * When there is No PK but there are multiple unique constraints, we need to pick one.
+
−		 * In the current implementation we return the first uc (lowest sys.keys.id).
+
−		 * Instead of the first (in case of multiple) we should potentially use the uc which has
+
−		 *  a) the least number of columns and
+
−		 *  b) the smallest total(size in bytes).
+
−		 * That's much more complex to do in SQL than the current implementation, which is fast and gives a correct result.
+
−		 */
+
−
+
−		final StringBuilder query = new StringBuilder(3000);
+
−		// 1st cte: syskeys
+
−		query.append("with syskeys as (" +
+
−			// all pkeys
+
−			"SELECT \"id\", \"table_id\" FROM \"sys\".\"keys\" WHERE \"type\" = 0 " +
+
−			"UNION ALL " +
+
−			// and first unique constraint of a table when table has no pkey
+
−			"SELECT \"id\", \"table_id\" FROM \"sys\".\"keys\" WHERE \"type\" IN (1, 3) " +
+
−			"AND \"table_id\" NOT IN (select \"table_id\" from \"sys\".\"keys\" where \"type\" = 0) " +
+
−			"AND (\"table_id\", \"id\") IN (select \"table_id\", min(\"id\") from \"sys\".\"keys\" where \"type\" IN (1, 3) group by \"table_id\"))");
+
−		if (incltmpkey) {
+
−			// we must also include the primary key or unique constraint of local temporary tables which are stored in tmp.keys
+
−		// 2nd cte: tmpkeys
+
−			query.append(", tmpkeys as (" +
+
−			"SELECT \"id\", \"table_id\" FROM \"tmp\".\"keys\" WHERE \"type\" = 0 " +
+
−			"UNION ALL " +
+
−			"SELECT \"id\", \"table_id\" FROM \"tmp\".\"keys\" WHERE \"type\" IN (1, 3) " +
+
−			"AND \"table_id\" NOT IN (select \"table_id\" from \"tmp\".\"keys\" where \"type\" = 0) " +
+
−			"AND (\"table_id\", \"id\") IN (select \"table_id\", min(\"id\") from \"tmp\".\"keys\" where \"type\" IN (1, 3) group by \"table_id\"))");
+
−		}
+
−		// 3rd cte: tableids
+
−		query.append(", tableids as (" +
+
−			"SELECT t.\"id\" " +
+
−			"FROM \"sys\".\"tables\" t " +
+
−			"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−			"WHERE t.\"type\" NOT IN (1, 11)");	// exclude all VIEWs and SYSTEM VIEWs
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (scope == DatabaseMetaData.bestRowSession
+
−			 || scope == DatabaseMetaData.bestRowTransaction
+
−			 || scope == DatabaseMetaData.bestRowTemporary) {
+
−				if (schema != null) {
+
−					// do not allow wildcard matching with LIKE, as the resultset does not include the schema info
+
−					query.append(" AND s.\"name\" = ").append(MonetWrapper.sq(schema));
+
−				}
+
−				if (table != null) {
+
−					// do not allow wildcard matching with LIKE, as the resultset does not include the table info
+
−					query.append(" AND t.\"name\" = ").append(MonetWrapper.sq(table));
+
−				}
+
−			} else {
+
−				query.append(" AND 1=0");
+
−			}
+
−		}
+
−		// 4th cte: cols, this unions 2 (or 4 when incltmpkey == true) select queries
+
−		query.append("), cols as (" +
+
−			"SELECT c.\"name\", c.\"type\", c.\"type_digits\", c.\"type_scale\", o.\"nr\" " +
+
−			"FROM syskeys k " +
+
−			"JOIN tableids t ON k.\"table_id\" = t.\"id\" " +
+
−			"JOIN \"sys\".\"objects\" o ON k.\"id\" = o.\"id\" " +
+
−			"JOIN \"sys\".\"_columns\" c ON (k.\"table_id\" = c.\"table_id\" AND o.\"name\" = c.\"name\")");
+
−		if (!nullable) {
+
−			query.append(" WHERE c.\"null\" = false");
+
−		}
+
−		if (incltmpkey) {
+
−			// we must also include the primary key or unique constraint of local temporary tables
+
−			// which are stored in tmp.keys, tmp.objects, tmp._tables and tmp._columns
+
−			query.append(" UNION ALL " +
+
−			"SELECT c.\"name\", c.\"type\", c.\"type_digits\", c.\"type_scale\", o.\"nr\" " +
+
−			"FROM tmpkeys k " +
+
−			"JOIN tableids t ON k.\"table_id\" = t.\"id\" " +
+
−			"JOIN \"tmp\".\"objects\" o ON k.\"id\" = o.\"id\" " +
+
−			"JOIN \"tmp\".\"_columns\" c ON (k.\"table_id\" = c.\"table_id\" AND o.\"name\" = c.\"name\")");
+
−			if (!nullable) {
+
−				query.append(" WHERE c.\"null\" = false");
+
−			}
+
−		}
+
−		// when there is No PK and No unique constraints, we should return all columns of the table
+
−		// (else in SQuirreL no header is shown in the "Row IDs" tab)
+
−		query.append(" UNION ALL " +
+
−			"SELECT c.\"name\", c.\"type\", c.\"type_digits\", c.\"type_scale\", c.\"number\" " +
+
−			"FROM tableids t " +
+
−			"JOIN \"sys\".\"_columns\" c ON t.\"id\" = c.\"table_id\" " +
+
−			"WHERE t.\"id\" NOT IN (SELECT \"table_id\" FROM \"sys\".\"keys\" WHERE \"type\" in (0, 1, 3))");
+
−		if (!nullable) {
+
−			query.append(" AND c.\"null\" = false");
+
−		}
+
−		if (incltmpkey) {
+
−			query.append(" UNION ALL " +
+
−			"SELECT c.\"name\", c.\"type\", c.\"type_digits\", c.\"type_scale\", c.\"number\" " +
+
−			"FROM tableids t " +
+
−			"JOIN \"tmp\".\"_columns\" c ON t.\"id\" = c.\"table_id\" " +
+
−			"WHERE t.\"id\" NOT IN (SELECT \"table_id\" FROM \"tmp\".\"keys\" WHERE \"type\" in (0, 1, 3))");
+
−			if (!nullable) {
+
−				query.append(" AND c.\"null\" = false");
+
−			}
+
−		}
+
−		// the final select query
+
−		query.append(") SELECT " +
+
−			"cast(" + DatabaseMetaData.bestRowSession + " AS smallint) AS \"SCOPE\", " +
+
−			"c.\"name\" AS \"COLUMN_NAME\", " +
+
−			"cast(").append(MonetDriver.getSQLTypeMap("c.\"type\"")).append(" AS int) AS \"DATA_TYPE\", " +
+
−			"c.\"type\" AS \"TYPE_NAME\", " +
+
−			"c.\"type_digits\" AS \"COLUMN_SIZE\", " +
+
−			"cast(0 as int) AS \"BUFFER_LENGTH\", " +
+
−			"cast(c.\"type_scale\" AS smallint) AS \"DECIMAL_DIGITS\", " +
+
−			"cast(" + DatabaseMetaData.bestRowNotPseudo + " AS smallint) AS \"PSEUDO_COLUMN\" " +
+
−			"FROM cols c " +
+
−			"ORDER BY \"SCOPE\", c.\"nr\", \"COLUMN_NAME\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of a table's columns that are automatically
+
−	 * updated when any value in a row is updated. They are unordered.
+
−	 *
+
−	 * <P>Each column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>SCOPE</B> short =&gt; is not used
+
−	 *	<LI><B>COLUMN_NAME</B> String =&gt; column name
+
−	 *	<LI><B>DATA_TYPE</B> int =&gt; SQL data type from java.sql.Types
+
−	 *	<LI><B>TYPE_NAME</B> String =&gt; Data source dependent type name
+
−	 *	<LI><B>COLUMN_SIZE</B> int =&gt; precision
+
−	 *	<LI><B>BUFFER_LENGTH</B> int =&gt; length of column value in bytes
+
−	 *	<LI><B>DECIMAL_DIGITS</B> short =&gt; scale
+
−	 *	<LI><B>PSEUDO_COLUMN</B> short =&gt; is this a pseudo column like an Oracle ROWID
+
−	 *		<UL>
+
−	 *		<LI> versionColumnUnknown - may or may not be pseudo column
+
−	 *		<LI> versionColumnNotPseudo - is NOT a pseudo column
+
−	 *		<LI> versionColumnPseudo - is a pseudo column
+
−	 *		</UL>
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schema a schema name; "" retrieves those without a schema
+
−	 * @param table a table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a column description
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getVersionColumns(
+
−		final String catalog,
+
−		final String schema,
+
−		final String table
+
−	) throws SQLException
+
−	{
+
−		// MonetDB currently does not have columns which update themselves, so return an empty ResultSet
+
−		final String query =
+
−		"SELECT cast(0 as smallint) AS \"SCOPE\", " +
+
−			"cast(null as char(1)) AS \"COLUMN_NAME\", " +
+
−			"cast(0 as int) AS \"DATA_TYPE\", " +
+
−			"cast(null as char(1)) AS \"TYPE_NAME\", " +
+
−			"cast(0 as int) AS \"COLUMN_SIZE\", " +
+
−			"cast(0 as int) AS \"BUFFER_LENGTH\", " +
+
−			"cast(0 as smallint) AS \"DECIMAL_DIGITS\", " +
+
−			"cast(0 as smallint) AS \"PSEUDO_COLUMN\" " +
+
−		"WHERE 1=0";
+
−
+
−		return executeMetaDataQuery(query);
+
−	}
+
−
+
−	/**
+
−	 * Get a description of a table's primary key columns.  They
+
−	 * are ordered by COLUMN_NAME.
+
−	 *
+
−	 * <P>Each column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null)
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
+
−	 *	<LI><B>TABLE_NAME</B> String =&gt; table name
+
−	 *	<LI><B>COLUMN_NAME</B> String =&gt; column name
+
−	 *	<LI><B>KEY_SEQ</B> short =&gt; sequence number within primary key
+
−	 *	<LI><B>PK_NAME</B> String =&gt; primary key name (may be null)
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schema a schema name pattern; "" retrieves those without a schema
+
−	 * @param table a table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a primary key column description
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getPrimaryKeys(
+
−		final String catalog,
+
−		final String schema,
+
−		final String table
+
−	) throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(1200);
+
−		query.append("SELECT cast(null AS char(1)) AS \"TABLE_CAT\", " +
+
−			"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−			"t.\"name\" AS \"TABLE_NAME\", " +
+
−			"o.\"name\" AS \"COLUMN_NAME\", " +
+
−			"cast(1 + o.\"nr\" AS smallint) AS \"KEY_SEQ\", " +
+
−			"k.\"name\" AS \"PK_NAME\" " +
+
−		"FROM \"sys\".\"keys\" k " +
+
−		"JOIN \"sys\".\"objects\" o ON k.\"id\" = o.\"id\" " +
+
−		"JOIN \"sys\".\"_tables\" t ON k.\"table_id\" = t.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−		"WHERE k.\"type\" = 0");	// only primary keys (type = 0)
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schema != null && !schema.equals("%")) {
+
−				query.append(" AND s.\"name\" ").append(composeMatchPart(schema));
+
−			}
+
−			if (table != null && !table.equals("%")) {
+
−				query.append(" AND t.\"name\" ").append(composeMatchPart(table));
+
−			}
+
−		}
+
−
+
−		final boolean includetmp = (schema == null)
+
−					|| (schema != null && ("tmp".equals(schema) || schema.contains("%") || schema.contains("_")));
+
−		if (includetmp) {
+
−			// we must also include the keys of local temporary tables which are stored in tmp.keys, tmp.objects and tmp._tables
+
−			query.append(" UNION ALL ");
+
−			query.append("SELECT cast(null AS char(1)) AS \"TABLE_CAT\", " +
+
−				"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−				"t.\"name\" AS \"TABLE_NAME\", " +
+
−				"o.\"name\" AS \"COLUMN_NAME\", " +
+
−				"cast(1 + o.\"nr\" AS smallint) AS \"KEY_SEQ\", " +
+
−				"k.\"name\" AS \"PK_NAME\" " +
+
−			"FROM \"tmp\".\"keys\" k " +
+
−			"JOIN \"tmp\".\"objects\" o ON k.\"id\" = o.\"id\" " +
+
−			"JOIN \"tmp\".\"_tables\" t ON k.\"table_id\" = t.\"id\" " +
+
−			"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−			"WHERE k.\"type\" = 0");	// only primary keys (type = 0)
+
−
+
−			if (catalog != null && !catalog.isEmpty()) {
+
−				// non-empty catalog selection.
+
−				// as we do not support catalogs this always results in no rows returned
+
−				query.append(" AND 1=0");
+
−			} else {
+
−				if (schema != null && !schema.equals("%")) {
+
−					query.append(" AND s.\"name\" ").append(composeMatchPart(schema));
+
−				}
+
−				if (table != null && !table.equals("%")) {
+
−					query.append(" AND t.\"name\" ").append(composeMatchPart(table));
+
−				}
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"TABLE_SCHEM\", \"TABLE_NAME\", \"COLUMN_NAME\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	// same SQL query used by getImportedKeys(), getExportedKeys() and getCrossReference()
+
−	private static final String keyQuery =
+
−	"SELECT cast(null AS char(1)) AS \"PKTABLE_CAT\", " +
+
−		"pkschema.\"name\" AS \"PKTABLE_SCHEM\", " +
+
−		"pktable.\"name\" AS \"PKTABLE_NAME\", " +
+
−		"pkkeycol.\"name\" AS \"PKCOLUMN_NAME\", " +
+
−		"cast(null AS char(1)) AS \"FKTABLE_CAT\", " +
+
−		"fkschema.\"name\" AS \"FKTABLE_SCHEM\", " +
+
−		"fktable.\"name\" AS \"FKTABLE_NAME\", " +
+
−		"fkkeycol.\"name\" AS \"FKCOLUMN_NAME\", " +
+
−		"cast(1 + \"pkkeycol\".\"nr\" AS smallint) AS \"KEY_SEQ\", " +
+
−		"cast(CASE ((fkkey.\"action\" >> 8) & 255)" +	// logic pulled from clients/mapiclient/dump.c dump_foreign_keys()
+
−			" WHEN 0 THEN " + DatabaseMetaData.importedKeyNoAction +
+
−			" WHEN 1 THEN " + DatabaseMetaData.importedKeyCascade +
+
−			" WHEN 2 THEN " + DatabaseMetaData.importedKeyRestrict +
+
−			" WHEN 3 THEN " + DatabaseMetaData.importedKeySetNull +
+
−			" WHEN 4 THEN " + DatabaseMetaData.importedKeySetDefault +
+
−			" ELSE " + DatabaseMetaData.importedKeyNoAction +
+
−			" END AS smallint) AS \"UPDATE_RULE\", " +
+
−		"cast(CASE (fkkey.\"action\" & 255)" +	// logic pulled from clients/mapiclient/dump.c dump_foreign_keys()
+
−			" WHEN 0 THEN " + DatabaseMetaData.importedKeyNoAction +
+
−			" WHEN 1 THEN " + DatabaseMetaData.importedKeyCascade +
+
−			" WHEN 2 THEN " + DatabaseMetaData.importedKeyRestrict +
+
−			" WHEN 3 THEN " + DatabaseMetaData.importedKeySetNull +
+
−			" WHEN 4 THEN " + DatabaseMetaData.importedKeySetDefault +
+
−			" ELSE " + DatabaseMetaData.importedKeyNoAction +
+
−			" END AS smallint) AS \"DELETE_RULE\", " +
+
−		"fkkey.\"name\" AS \"FK_NAME\", " +
+
−		"pkkey.\"name\" AS \"PK_NAME\", " +
+
−		"cast(" + DatabaseMetaData.importedKeyNotDeferrable + " AS smallint) AS \"DEFERRABILITY\" " +
+
−	"FROM \"sys\".\"keys\" pkkey " +
+
−	"JOIN \"sys\".\"objects\" pkkeycol ON pkkey.\"id\" = pkkeycol.\"id\" " +
+
−	"JOIN \"sys\".\"tables\" pktable ON pktable.\"id\" = pkkey.\"table_id\" " +
+
−	"JOIN \"sys\".\"schemas\" pkschema ON pkschema.\"id\" = pktable.\"schema_id\" " +
+
−	"JOIN \"sys\".\"keys\" fkkey ON fkkey.\"rkey\" = pkkey.\"id\" " +
+
−	"JOIN \"sys\".\"objects\" fkkeycol ON (fkkey.\"id\" = fkkeycol.\"id\" AND fkkeycol.\"nr\" = pkkeycol.\"nr\") " +
+
−	"JOIN \"sys\".\"tables\" fktable ON fktable.\"id\" = fkkey.\"table_id\" " +
+
−	"JOIN \"sys\".\"schemas\" fkschema ON fkschema.\"id\" = fktable.\"schema_id\" " +
+
−	"WHERE fkkey.\"rkey\" > 0";	// exclude invalid key references, such as -1
+
−
+
−	/**
+
−	 * Get a description of the primary key columns that are
+
−	 * referenced by a table's foreign key columns (the primary keys
+
−	 * imported by a table). They are ordered by PKTABLE_CAT,
+
−	 * PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
+
−	 *
+
−	 * <P>Each primary key column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>PKTABLE_CAT</B> String =&gt; primary key table catalog
+
−	 *		being imported (may be null)
+
−	 *	<LI><B>PKTABLE_SCHEM</B> String =&gt; primary key table schema
+
−	 *		being imported (may be null)
+
−	 *	<LI><B>PKTABLE_NAME</B> String =&gt; primary key table name
+
−	 *		being imported
+
−	 *	<LI><B>PKCOLUMN_NAME</B> String =&gt; primary key column name
+
−	 *		being imported
+
−	 *	<LI><B>FKTABLE_CAT</B> String =&gt; foreign key table catalog (may be null)
+
−	 *	<LI><B>FKTABLE_SCHEM</B> String =&gt; foreign key table schema (may be null)
+
−	 *	<LI><B>FKTABLE_NAME</B> String =&gt; foreign key table name
+
−	 *	<LI><B>FKCOLUMN_NAME</B> String =&gt; foreign key column name
+
−	 *	<LI><B>KEY_SEQ</B> short =&gt; sequence number within foreign key
+
−	 *		(a value of 1 represents the first column of the foreign key, a value of 2 would represent the second column within the foreign key).
+
−	 *	<LI><B>UPDATE_RULE</B> short =&gt; What happens to foreign key when primary is updated:
+
−	 *		<UL>
+
−	 *		<LI> importedKeyNoAction - do not allow update of primary key if it has been imported
+
−	 *		<LI> importedKeyCascade - change imported key to agree with primary key update
+
−	 *		<LI> importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
+
−	 *		<LI> importedKeySetNull - change imported key to NULL if its primary key has been updated
+
−	 *		<LI> importedKeySetDefault - change imported key to the default values if its primary key has been updated
+
−	 *		</UL>
+
−	 *	<LI><B>DELETE_RULE</B> short =&gt; What happens to the foreign key when primary is deleted.
+
−	 *		<UL>
+
−	 *		<LI> importedKeyNoAction - do not allow delete of primary key if it has been imported
+
−	 *		<LI> importedKeyCascade - delete rows that import a deleted key
+
−	 *		<LI> importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
+
−	 *		<LI> importedKeySetNull - change imported key to NULL if its primary key has been deleted
+
−	 *		<LI> importedKeySetDefault - change imported key to the default values if its primary key has been deleted
+
−	 *		</UL>
+
−	 *	<LI><B>FK_NAME</B> String =&gt; foreign key name (may be null)
+
−	 *	<LI><B>PK_NAME</B> String =&gt; primary key name (may be null)
+
−	 *	<LI><B>DEFERRABILITY</B> short =&gt; can the evaluation of foreign key constraints be deferred until commit
+
−	 *		<UL>
+
−	 *		<LI> importedKeyInitiallyDeferred - see SQL92 for definition
+
−	 *		<LI> importedKeyInitiallyImmediate - see SQL92 for definition
+
−	 *		<LI> importedKeyNotDeferrable - see SQL92 for definition
+
−	 *		</UL>
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schema a schema name pattern; "" retrieves those without a schema
+
−	 * @param table a table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a primary key column description
+
−	 * @see #getExportedKeys
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getImportedKeys(
+
−		final String catalog,
+
−		final String schema,
+
−		final String table
+
−	) throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(keyQuery.length() + 250);
+
−		query.append(keyQuery);
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schema != null && !schema.equals("%")) {
+
−				query.append(" AND fkschema.\"name\" ").append(composeMatchPart(schema));
+
−			}
+
−			if (table != null && !table.equals("%")) {
+
−				query.append(" AND fktable.\"name\" ").append(composeMatchPart(table));
+
−			}
+
−		}
+
−
+
−		// Note: the extra \"FKTABLE_SCHEM\", \"FKTABLE_NAME\", \"FK_NAME\" in the ordering is important
+
−		// else we do not get the correct column order when multiple fks exist to the same pk in 1 table or query multiple tables.
+
−		query.append(" ORDER BY \"PKTABLE_SCHEM\", \"PKTABLE_NAME\", \"PK_NAME\", \"FKTABLE_SCHEM\", \"FKTABLE_NAME\", \"FK_NAME\", \"KEY_SEQ\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of a foreign key columns that reference a
+
−	 * table's primary key columns (the foreign keys exported by a table).
+
−	 * They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
+
−	 *
+
−	 * <P>Each foreign key column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>PKTABLE_CAT</B> String =&gt; primary key table catalog (may be null)
+
−	 *	<LI><B>PKTABLE_SCHEM</B> String =&gt; primary key table schema (may be null)
+
−	 *	<LI><B>PKTABLE_NAME</B> String =&gt; primary key table name
+
−	 *	<LI><B>PKCOLUMN_NAME</B> String =&gt; primary key column name
+
−	 *	<LI><B>FKTABLE_CAT</B> String =&gt; foreign key table catalog (may be null)
+
−	 *		being exported (may be null)
+
−	 *	<LI><B>FKTABLE_SCHEM</B> String =&gt; foreign key table schema (may be null)
+
−	 *		being exported (may be null)
+
−	 *	<LI><B>FKTABLE_NAME</B> String =&gt; foreign key table name
+
−	 *		being exported
+
−	 *	<LI><B>FKCOLUMN_NAME</B> String =&gt; foreign key column name
+
−	 *		being exported
+
−	 *	<LI><B>KEY_SEQ</B> short =&gt; sequence number within foreign key
+
−	 *		(a value of 1 represents the first column of the foreign key, a value of 2 would represent the second column within the foreign key).
+
−	 *	<LI><B>UPDATE_RULE</B> short =&gt; What happens to foreign key when primary is updated:
+
−	 *		<UL>
+
−	 *		<LI> importedKeyNoAction - do not allow update of primary key if it has been imported
+
−	 *		<LI> importedKeyCascade - change imported key to agree with primary key update
+
−	 *		<LI> importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
+
−	 *		<LI> importedKeySetNull - change imported key to NULL if its primary key has been updated
+
−	 *		<LI> importedKeySetDefault - change imported key to the default values if its primary key has been updated
+
−	 *		</UL>
+
−	 *	<LI><B>DELETE_RULE</B> short =&gt; What happens to the foreign key when primary is deleted.
+
−	 *		<UL>
+
−	 *		<LI> importedKeyNoAction - do not allow delete of primary key if it has been imported
+
−	 *		<LI> importedKeyCascade - delete rows that import a deleted key
+
−	 *		<LI> importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
+
−	 *		<LI> importedKeySetNull - change imported key to NULL if its primary key has been deleted
+
−	 *		<LI> importedKeySetDefault - change imported key to the default values if its primary key has been deleted
+
−	 *		</UL>
+
−	 *	<LI><B>FK_NAME</B> String =&gt; foreign key identifier (may be null)
+
−	 *	<LI><B>PK_NAME</B> String =&gt; primary key identifier (may be null)
+
−	 *	<LI><B>DEFERRABILITY</B> short =&gt; can the evaluation of foreign key constraints be deferred until commit
+
−	 *		<UL>
+
−	 *		<LI> importedKeyInitiallyDeferred - see SQL92 for definition
+
−	 *		<LI> importedKeyInitiallyImmediate - see SQL92 for definition
+
−	 *		<LI> importedKeyNotDeferrable - see SQL92 for definition
+
−	 *		</UL>
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schema a schema name pattern; "" retrieves those without a schema
+
−	 * @param table a table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a foreign key column description
+
−	 * @see #getImportedKeys
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getExportedKeys(
+
−		final String catalog,
+
−		final String schema,
+
−		final String table
+
−	) throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(keyQuery.length() + 250);
+
−		query.append(keyQuery);
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schema != null && !schema.equals("%")) {
+
−				query.append(" AND pkschema.\"name\" ").append(composeMatchPart(schema));
+
−			}
+
−			if (table != null && !table.equals("%")) {
+
−				query.append(" AND pktable.\"name\" ").append(composeMatchPart(table));
+
−			}
+
−		}
+
−
+
−		// Note: the extra \"PKTABLE_SCHEM\", \"PKTABLE_NAME\", \"PK_NAME\" in the ordering is important
+
−		// else we do not get the correct column order when multiple fks exist to the same pk in 1 table or query multiple tables.
+
−		query.append(" ORDER BY \"FKTABLE_SCHEM\", \"FKTABLE_NAME\", \"FK_NAME\", \"PKTABLE_SCHEM\", \"PKTABLE_NAME\", \"PK_NAME\", \"KEY_SEQ\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of the foreign key columns in the foreign key
+
−	 * table that reference the primary key columns of the primary key
+
−	 * table. (describe how one table imports another's key) This
+
−	 * should normally return a single foreign key/primary key pair
+
−	 * (most tables only import a foreign key from a table once.)
+
−	 * They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
+
−	 *
+
−	 * <P>Each foreign key column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>PKTABLE_CAT</B> String =&gt; primary key table catalog (may be null)
+
−	 *	<LI><B>PKTABLE_SCHEM</B> String =&gt; primary key table schema (may be null)
+
−	 *	<LI><B>PKTABLE_NAME</B> String =&gt; primary key table name
+
−	 *	<LI><B>PKCOLUMN_NAME</B> String =&gt; primary key column name
+
−	 *	<LI><B>FKTABLE_CAT</B> String =&gt; foreign key table catalog (may be null)
+
−	 *		being exported (may be null)
+
−	 *	<LI><B>FKTABLE_SCHEM</B> String =&gt; foreign key table schema (may be null)
+
−	 *		being exported (may be null)
+
−	 *	<LI><B>FKTABLE_NAME</B> String =&gt; foreign key table name
+
−	 *		being exported
+
−	 *	<LI><B>FKCOLUMN_NAME</B> String =&gt; foreign key column name
+
−	 *		being exported
+
−	 *	<LI><B>KEY_SEQ</B> short =&gt; sequence number within foreign key
+
−	 *		(a value of 1 represents the first column of the foreign key, a value of 2 would represent the second column within the foreign key).
+
−	 *	<LI><B>UPDATE_RULE</B> short =&gt; What happens to foreign key when primary is updated:
+
−	 *		<UL>
+
−	 *		<LI> importedKeyNoAction - do not allow update of primary key if it has been imported
+
−	 *		<LI> importedKeyCascade - change imported key to agree with primary key update
+
−	 *		<LI> importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
+
−	 *		<LI> importedKeySetNull - change imported key to NULL if its primary key has been updated
+
−	 *		<LI> importedKeySetDefault - change imported key to the default values if its primary key has been updated
+
−	 *		</UL>
+
−	 *	<LI><B>DELETE_RULE</B> short =&gt; What happens to the foreign key when primary is deleted.
+
−	 *		<UL>
+
−	 *		<LI> importedKeyNoAction - do not allow delete of primary key if it has been imported
+
−	 *		<LI> importedKeyCascade - delete rows that import a deleted key
+
−	 *		<LI> importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
+
−	 *		<LI> importedKeySetNull - change imported key to NULL if its primary key has been deleted
+
−	 *		<LI> importedKeySetDefault - change imported key to the default values if its primary key has been deleted
+
−	 *		</UL>
+
−	 *	<LI><B>FK_NAME</B> String =&gt; foreign key identifier (may be null)
+
−	 *	<LI><B>PK_NAME</B> String =&gt; primary key identifier (may be null)
+
−	 *	<LI><B>DEFERRABILITY</B> short =&gt; can the evaluation of foreign key constraints be deferred until commit
+
−	 *		<UL>
+
−	 *		<LI> importedKeyInitiallyDeferred - see SQL92 for definition
+
−	 *		<LI> importedKeyInitiallyImmediate - see SQL92 for definition
+
−	 *		<LI> importedKeyNotDeferrable - see SQL92 for definition
+
−	 *		</UL>
+
−	 *	</OL>
+
−	 *
+
−	 * @param pcatalog primary key catalog name; "" retrieves those without a catalog
+
−	 * @param pschema primary key schema name pattern; "" retrieves those without a schema
+
−	 * @param ptable primary key table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param fcatalog foreign key catalog name; "" retrieves those without a catalog
+
−	 * @param fschema foreign key schema name pattern; "" retrieves those without a schema
+
−	 * @param ftable koreign key table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet each row is a foreign key column description
+
−	 * @throws SQLException if a database error occurs
+
−	 * @see #getImportedKeys
+
−	 */
+
−	@Override
+
−	public ResultSet getCrossReference(
+
−		final String pcatalog,
+
−		final String pschema,
+
−		final String ptable,
+
−		final String fcatalog,
+
−		final String fschema,
+
−		final String ftable
+
−	) throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(keyQuery.length() + 350);
+
−		query.append(keyQuery);
+
−
+
−		if ((pcatalog != null && !pcatalog.isEmpty())
+
−		 || (fcatalog != null && !fcatalog.isEmpty())) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (pschema != null && !pschema.equals("%")) {
+
−				query.append(" AND pkschema.\"name\" ").append(composeMatchPart(pschema));
+
−			}
+
−			if (ptable != null && !ptable.equals("%")) {
+
−				query.append(" AND pktable.\"name\" ").append(composeMatchPart(ptable));
+
−			}
+
−
+
−			if (fschema != null && !fschema.equals("%")) {
+
−				query.append(" AND fkschema.\"name\" ").append(composeMatchPart(fschema));
+
−			}
+
−			if (ftable != null && !ftable.equals("%")) {
+
−				query.append(" AND fktable.\"name\" ").append(composeMatchPart(ftable));
+
−			}
+
−		}
+
−
+
−		// Note: the extra \"PKTABLE_SCHEM\", \"PKTABLE_NAME\", \"PK_NAME\" in the ordering is important
+
−		// else we do not get the correct column order when multiple fks exist to the same pk in 1 table or query multiple tables.
+
−		query.append(" ORDER BY \"FKTABLE_SCHEM\", \"FKTABLE_NAME\", \"FK_NAME\", \"PKTABLE_SCHEM\", \"PKTABLE_NAME\", \"PK_NAME\", \"KEY_SEQ\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Get a description of all the SQL data types supported by
+
−	 * this database. They are ordered by DATA_TYPE and then by how
+
−	 * closely the data type maps to the corresponding JDBC SQL type.
+
−	 *
+
−	 * If the database supports SQL distinct types, then getTypeInfo() will
+
−	 * return a single row with a TYPE_NAME of DISTINCT and a DATA_TYPE of Types.DISTINCT.
+
−	 * If the database supports SQL structured types, then getTypeInfo() will
+
−	 * return a single row with a TYPE_NAME of STRUCT and a DATA_TYPE of Types.STRUCT.
+
−	 * If SQL distinct or structured types are supported, then information on
+
−	 * the individual types may be obtained from the getUDTs() method.
+
−	 *
+
−	 * <P>Each type description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TYPE_NAME</B> String =&gt; Type name
+
−	 *	<LI><B>DATA_TYPE</B> int =&gt; SQL data type from java.sql.Types
+
−	 *	<LI><B>PRECISION</B> int =&gt; maximum precision
+
−	 *	<LI><B>LITERAL_PREFIX</B> String =&gt; prefix used to quote a literal (may be null)
+
−	 *	<LI><B>LITERAL_SUFFIX</B> String =&gt; suffix used to quote a literal (may be null)
+
−	 *	<LI><B>CREATE_PARAMS</B> String =&gt; parameters used in creating
+
−	 *		the type (may be null)
+
−	 *	<LI><B>NULLABLE</B> short =&gt; can you use NULL for this type?
+
−	 *		<UL>
+
−	 *		<LI> typeNoNulls - does not allow NULL values
+
−	 *		<LI> typeNullable - allows NULL values
+
−	 *		<LI> typeNullableUnknown - nullability unknown
+
−	 *		</UL>
+
−	 *	<LI><B>CASE_SENSITIVE</B> boolean=&gt; is it case sensitive?
+
−	 *	<LI><B>SEARCHABLE</B> short =&gt; can you use "WHERE" based on this type:
+
−	 *		<UL>
+
−	 *		<LI> typePredNone - No support
+
−	 *		<LI> typePredChar - Only supported with WHERE .. LIKE
+
−	 *		<LI> typePredBasic - Supported except for WHERE .. LIKE
+
−	 *		<LI> typeSearchable - Supported for all WHERE ..
+
−	 *		</UL>
+
−	 *	<LI><B>UNSIGNED_ATTRIBUTE</B> boolean =&gt; is it unsigned?
+
−	 *	<LI><B>FIXED_PREC_SCALE</B> boolean =&gt; can it be a money value?
+
−	 *	<LI><B>AUTO_INCREMENT</B> boolean =&gt; can it be used for an
+
−	 *		auto-increment value?
+
−	 *	<LI><B>LOCAL_TYPE_NAME</B> String =&gt; localized version of type name
+
−	 *		(may be null)
+
−	 *	<LI><B>MINIMUM_SCALE</B> short =&gt; minimum scale supported
+
−	 *	<LI><B>MAXIMUM_SCALE</B> short =&gt; maximum scale supported
+
−	 *	<LI><B>SQL_DATA_TYPE</B> int =&gt; unused
+
−	 *	<LI><B>SQL_DATETIME_SUB</B> int =&gt; unused
+
−	 *	<LI><B>NUM_PREC_RADIX</B> int =&gt; usually 2 or 10
+
−	 *	</OL>
+
−	 *
+
−	 * @return ResultSet each row is a SQL type description
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getTypeInfo() throws SQLException {
+
−		final StringBuilder query = new StringBuilder(4816);
+
−		query.append("SELECT \"sqlname\" AS \"TYPE_NAME\", " +
+
−			"cast(").append(MonetDriver.getSQLTypeMap("\"sqlname\"")).append(" AS int) AS \"DATA_TYPE\", " +
+
−			"cast(CASE WHEN \"sqlname\" IN ('time','timetz','timestamp','timestamptz') THEN \"digits\" -1" +
+
−				" ELSE \"digits\" END AS int) AS \"PRECISION\", " +	// note that when radix is 2 the precision shows the number of bits
+
−			"cast(CASE WHEN \"sqlname\" IN ('char','varchar') THEN ''''" +
+
−				" WHEN \"sqlname\" IN ('clob','inet','json','url','uuid','date','time','timetz','timestamp','timestamptz','blob','sqlblob','xml') THEN \"sqlname\"||' '''" +
+
−				" ELSE NULL END AS varchar(16)) AS \"LITERAL_PREFIX\", " +
+
−			"cast(CASE WHEN \"sqlname\" IN ('char','varchar','clob','inet','json','url','uuid','date','time','timetz','timestamp','timestamptz','blob','sqlblob','xml') THEN ''''" +
+
−				" ELSE NULL END AS varchar(2)) AS \"LITERAL_SUFFIX\", " +
+
−			"CASE WHEN \"sqlname\" IN ('char','varchar') THEN 'max length'" +
+
−				" WHEN \"sqlname\" = 'decimal' THEN 'precision, scale'" +
+
−				" WHEN \"sqlname\" IN ('time','timetz','timestamp','timestamptz') THEN 'scale'" +
+
−				" ELSE NULL END AS \"CREATE_PARAMS\", " +
+
−			"cast(CASE WHEN \"systemname\" = 'oid' THEN " + DatabaseMetaData.typeNoNulls +
+
−				" ELSE " + DatabaseMetaData.typeNullable + " END AS smallint) AS \"NULLABLE\", " +
+
−			"CASE WHEN \"systemname\" IN ('str','json','url','xml') THEN true ELSE false END AS \"CASE_SENSITIVE\", " +
+
−			"cast(CASE WHEN \"systemname\" IN ('str','inet','json','url','uuid','xml') THEN " + DatabaseMetaData.typeSearchable +
+
−				" ELSE " + DatabaseMetaData.typePredBasic + " END AS smallint) AS \"SEARCHABLE\", " +
+
−			"CASE WHEN \"sqlname\" IN ('tinyint','smallint','int','bigint','hugeint','decimal','real','double') THEN false ELSE true END AS \"UNSIGNED_ATTRIBUTE\", " +
+
−			"CASE \"sqlname\" WHEN 'decimal' THEN true ELSE false END AS \"FIXED_PREC_SCALE\", " +
+
−			"CASE WHEN \"sqlname\" IN ('tinyint','smallint','int','bigint') THEN true ELSE false END AS \"AUTO_INCREMENT\", " +
+
−			"\"systemname\" AS \"LOCAL_TYPE_NAME\", " +
+
−			"cast(0 AS smallint) AS \"MINIMUM_SCALE\", " +
+
−			"cast(CASE WHEN \"sqlname\" = 'decimal' THEN (CASE \"systemname\" WHEN 'int' THEN 9 WHEN 'lng' THEN 18 WHEN 'sht' THEN 4 WHEN 'hge' THEN 38 WHEN 'bte' THEN 2 ELSE 0 END)" +
+
−				" WHEN \"sqlname\" IN ('time','timetz','timestamp','timestamptz') THEN 6" +
+
−				" ELSE 0 END AS smallint) AS \"MAXIMUM_SCALE\", " +
+
−			"cast(0 AS int) AS \"SQL_DATA_TYPE\", " +
+
−			"cast(0 AS int) AS \"SQL_DATETIME_SUB\", " +
+
−			"cast(CASE WHEN \"sqlname\" IN ('time','timetz','timestamp','timestamptz') THEN 10 ELSE \"radix\" END AS int) AS \"NUM_PREC_RADIX\" " +
+
−		"FROM \"sys\".\"types\" " +
+
−		// exclude the 3 interval types here as they are added next
+
−		"WHERE \"sqlname\" NOT IN ('sec_interval','day_interval','month_interval') " +
+
−		"UNION ALL " +
+
−		// add the 13 interval types (like done in ODBC SQLGetTypeInfo())
+
−		"SELECT \"TYPE_NAME\", 1111 AS \"DATA_TYPE\", PRECISION, 'interval ''' AS LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS, " +
+
−			DatabaseMetaData.typeNullable + " AS NULLABLE, false AS CASE_SENSITIVE, " + DatabaseMetaData.typePredBasic + " AS SEARCHABLE, " +
+
−			"false AS UNSIGNED_ATTRIBUTE, false AS FIXED_PREC_SCALE, false AS \"AUTO_INCREMENT\", LOCAL_TYPE_NAME, 0 AS MINIMUM_SCALE, " +
+
−			"MAXIMUM_SCALE, 0 AS SQL_DATA_TYPE, 0 AS SQL_DATETIME_SUB, 10 AS NUM_PREC_RADIX " +
+
−		"FROM (VALUES" +
+
−		" ('interval year', 6, ''' year', CAST(NULL AS VARCHAR(5)), 'month_interval', 0)" +
+
−		",('interval month', 8, ''' month', NULL, 'month_interval', 0)" +
+
−		",('interval day', 10, ''' day', NULL, 'day_interval', 0)" +
+
−		",('interval hour', 12, ''' hour', NULL, 'sec_interval', 0)" +
+
−		",('interval minute', 12, ''' minute', NULL, 'sec_interval', 0)" +
+
−		",('interval second', 15, ''' second', 'scale', 'sec_interval', 3)" +
+
−		",('interval year to month', 8, ''' year to month', NULL, 'month_interval', 0)" +
+
−		",('interval day to hour', 12, ''' day to hour', NULL, 'sec_interval', 0)" +
+
−		",('interval day to minute', 12, ''' day to minute', NULL, 'sec_interval', 0)" +
+
−		",('interval day to second', 15, ''' day to second', 'scale', 'sec_interval', 3)" +
+
−		",('interval hour to minute', 12, ''' hour to minute', NULL, 'sec_interval', 0)" +
+
−		",('interval hour to second', 15, ''' hour to second', 'scale', 'sec_interval', 3)" +
+
−		",('interval minute to second', 15, ''' minute to second', 'scale', 'sec_interval', 3)" +
+
−		") AS interval_types(\"TYPE_NAME\", PRECISION, LITERAL_SUFFIX, CREATE_PARAMS, LOCAL_TYPE_NAME, MAXIMUM_SCALE) " +
+
−		"UNION ALL " +
+
−		// also add the 2 serial types (like done in ODBC SQLGetTypeInfo())
+
−		"SELECT \"TYPE_NAME\", \"DATA_TYPE\", PRECISION, NULL AS LITERAL_PREFIX, NULL AS LITERAL_SUFFIX, NULL AS CREATE_PARAMS, " +
+
−			DatabaseMetaData.typeNoNulls + " AS NULLABLE, false AS CASE_SENSITIVE, " + DatabaseMetaData.typePredBasic + " AS SEARCHABLE, " +
+
−			"false AS UNSIGNED_ATTRIBUTE, false AS FIXED_PREC_SCALE, true AS \"AUTO_INCREMENT\", LOCAL_TYPE_NAME, 0 AS MINIMUM_SCALE, " +
+
−			"0 AS MAXIMUM_SCALE, 0 AS SQL_DATA_TYPE, 0 AS SQL_DATETIME_SUB, 2 AS NUM_PREC_RADIX " +
+
−		"FROM (VALUES" +
+
−		" ('bigserial', -5, 64, 'bigint')" +
+
−		",('serial', 4, 32, 'int')" +
+
−		") AS serial_types(\"TYPE_NAME\", \"DATA_TYPE\", PRECISION, LOCAL_TYPE_NAME) " +
+
−		"ORDER BY \"DATA_TYPE\", \"TYPE_NAME\"");
+
−
+
−		// System.err.println("getTypeInfo() query: " + query.toString());
+
−		// if (query.length() >= 4800) System.err.println("getTypeInfo(), extend query initial size to: " + query.length());
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the given table's indices and statistics.
+
−	 * They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
+
−	 *
+
−	 * <P>Each index column description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; table catalog (may be null)
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; table schema (may be null)
+
−	 *	<LI><B>TABLE_NAME</B> String =&gt; table name
+
−	 *	<LI><B>NON_UNIQUE</B> boolean =&gt; Can index values be non-unique?
+
−	 *		false when TYPE is tableIndexStatistic
+
−	 *	<LI><B>INDEX_QUALIFIER</B> String =&gt; index catalog (may be null);
+
−	 *		null when TYPE is tableIndexStatistic
+
−	 *	<LI><B>INDEX_NAME</B> String =&gt; index name; null when TYPE is
+
−	 *		tableIndexStatistic
+
−	 *	<LI><B>TYPE</B> short =&gt; index type:
+
−	 *		<UL>
+
−	 *		<LI> tableIndexStatistic - this identifies table statistics that are
+
−	 *			 returned in conjuction with a table's index descriptions
+
−	 *		<LI> tableIndexClustered - this is a clustered index
+
−	 *		<LI> tableIndexHashed - this is a hashed index
+
−	 *		<LI> tableIndexOther - this is some other style of index
+
−	 *		</UL>
+
−	 *	<LI><B>ORDINAL_POSITION</B> short =&gt; column sequence number
+
−	 *		within index; zero when TYPE is tableIndexStatistic
+
−	 *	<LI><B>COLUMN_NAME</B> String =&gt; column name; null when TYPE is
+
−	 *		tableIndexStatistic
+
−	 *	<LI><B>ASC_OR_DESC</B> String =&gt; column sort sequence, "A" =&gt; ascending
+
−	 *		"D" =&gt; descending, may be null if sort sequence is not supported;
+
−	 *		null when TYPE is tableIndexStatistic
+
−	 *	<LI><B>CARDINALITY</B> int =&gt; When TYPE is tableIndexStatisic then
+
−	 *		this is the number of rows in the table; otherwise it is the
+
−	 *		number of unique values in the index.
+
−	 *	<LI><B>PAGES</B> int =&gt; When TYPE is  tableIndexStatisic then
+
−	 *		this is the number of pages used for the table, otherwise it
+
−	 *		is the number of pages used for the current index.
+
−	 *	<LI><B>FILTER_CONDITION</B> String =&gt; Filter condition, if any.
+
−	 *		(may be null)
+
−	 *	</OL>
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog
+
−	 * @param schema a schema name pattern; "" retrieves those without a schema
+
−	 * @param table a table name
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param unique when true, return only indices for unique values;
+
−	 *	   when false, return indices regardless of whether unique or not
+
−	 * @param approximate when true, result is allowed to reflect approximate
+
−	 *	   or out of data values; when false, results are requested to be
+
−	 *	   accurate
+
−	 * @return ResultSet each row is an index column description
+
−	 * @throws SQLException if a database occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getIndexInfo(
+
−		final String catalog,
+
−		final String schema,
+
−		final String table,
+
−		final boolean unique,
+
−		final boolean approximate
+
−	) throws SQLException
+
−	{
+
−		String table_row_count = "0";
+
−
+
−		if (!approximate
+
−		 && schema != null && !schema.isEmpty() && !schema.contains("%")
+
−		 && table != null && !table.isEmpty() && !table.contains("%")) {
+
−			// we need the exact cardinality for one specific fully qualified table
+
−			ResultSet count = null;
+
−			try {
+
−				count = executeMetaDataQuery("SELECT COUNT(*) FROM \"" + schema + "\".\"" + table + "\"");
+
−				if (count != null && count.next()) {
+
−					String count_value = count.getString(1);
+
−					if (count_value != null && !count_value.isEmpty())
+
−						table_row_count = count_value;
+
−				}
+
−			} catch (SQLException e) {
+
−				// ignore
+
−			} finally {
+
−				MonetConnection.closeResultsetStatement(count, null);
+
−			}
+
−		}
+
−
+
−		final StringBuilder query = new StringBuilder(2500);
+
−		query.append(
+
−		"SELECT cast(null AS char(1)) AS \"TABLE_CAT\", " +
+
−			"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−			"t.\"name\" AS \"TABLE_NAME\", " +
+
−			"CASE WHEN k.\"name\" IS NULL THEN true ELSE false END AS \"NON_UNIQUE\", " +
+
−			"cast(null AS char(1)) AS \"INDEX_QUALIFIER\", " +
+
−			"i.\"name\" AS \"INDEX_NAME\", " +
+
−			"CASE i.\"type\" WHEN 0 THEN " + DatabaseMetaData.tableIndexHashed + " ELSE " + DatabaseMetaData.tableIndexOther + " END AS \"TYPE\", " +
+
−			"cast(o.\"nr\" +1 AS smallint) AS \"ORDINAL_POSITION\", "+
+
−			"c.\"name\" AS \"COLUMN_NAME\", " +
+
−			"cast(null AS char(1)) AS \"ASC_OR_DESC\", " +	// sort sequence currently not supported in keys or indexes in MonetDB
+
−			"cast(").append(table_row_count).append(" AS int) AS \"CARDINALITY\", " +
+
−			"cast(0 AS int) AS \"PAGES\", " +
+
−			"cast(null AS char(1)) AS \"FILTER_CONDITION\" " +
+
−		"FROM \"sys\".\"idxs\" i " +
+
−		"JOIN \"sys\".\"_tables\" t ON i.\"table_id\" = t.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−		"JOIN \"sys\".\"objects\" o ON i.\"id\" = o.\"id\" " +
+
−		"JOIN \"sys\".\"_columns\" c ON (t.\"id\" = c.\"table_id\" AND o.\"name\" = c.\"name\") " +
+
−		"LEFT OUTER JOIN \"sys\".\"keys\" k ON (i.\"name\" = k.\"name\" AND i.\"table_id\" = k.\"table_id\" AND k.\"type\" IN (0, 1, 3)) ");	// primary (0) and unique keys (1 or 3) only
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append("WHERE 1=0");
+
−		} else {
+
−			boolean needWhere = true;
+
−			if (schema != null && !schema.equals("%")) {
+
−				query.append("WHERE s.\"name\" ").append(composeMatchPart(schema));
+
−				needWhere = false;
+
−			}
+
−			if (table != null && !table.equals("%")) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" t.\"name\" ").append(composeMatchPart(table));
+
−				needWhere = false;
+
−			}
+
−			if (unique) {
+
−				query.append(needWhere ? "WHERE" : " AND")
+
−				.append(" k.\"name\" IS NOT NULL");
+
−			}
+
−		}
+
−
+
−		final boolean includetmp = (schema == null)
+
−					|| (schema != null && ("tmp".equals(schema) || schema.contains("%") || schema.contains("_")));
+
−		if (includetmp) {
+
−			// we must also include the indexes of local temporary tables which are stored in tmp.idxs, tmp._tables, tmp._columns, tmp.objects and tmp.keys
+
−			query.append(" UNION ALL ");
+
−			query.append(
+
−			"SELECT cast(null AS char(1)) AS \"TABLE_CAT\", " +
+
−				"s.\"name\" AS \"TABLE_SCHEM\", " +
+
−				"t.\"name\" AS \"TABLE_NAME\", " +
+
−				"CASE WHEN k.\"name\" IS NULL THEN true ELSE false END AS \"NON_UNIQUE\", " +
+
−				"cast(null AS char(1)) AS \"INDEX_QUALIFIER\", " +
+
−				"i.\"name\" AS \"INDEX_NAME\", " +
+
−				"CASE i.\"type\" WHEN 0 THEN " + DatabaseMetaData.tableIndexHashed + " ELSE " + DatabaseMetaData.tableIndexOther + " END AS \"TYPE\", " +
+
−				"cast(o.\"nr\" +1 AS smallint) AS \"ORDINAL_POSITION\", "+
+
−				"c.\"name\" AS \"COLUMN_NAME\", " +
+
−				"cast(null AS char(1)) AS \"ASC_OR_DESC\", " +	// sort sequence currently not supported in keys or indexes in MonetDB
+
−				"cast(").append(table_row_count).append(" AS int) AS \"CARDINALITY\", " +
+
−				"cast(0 AS int) AS \"PAGES\", " +
+
−				"cast(null AS char(1)) AS \"FILTER_CONDITION\" " +
+
−			"FROM \"tmp\".\"idxs\" i " +
+
−			"JOIN \"tmp\".\"_tables\" t ON i.\"table_id\" = t.\"id\" " +
+
−			"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−			"JOIN \"tmp\".\"objects\" o ON i.\"id\" = o.\"id\" " +
+
−			"JOIN \"tmp\".\"_columns\" c ON (t.\"id\" = c.\"table_id\" AND o.\"name\" = c.\"name\") " +
+
−			"LEFT OUTER JOIN \"tmp\".\"keys\" k ON (i.\"name\" = k.\"name\" AND i.\"table_id\" = k.\"table_id\" AND k.\"type\" IN (0, 1, 3)) ");	// primary (0) and unique keys (1 or 3) only
+
−
+
−			if (catalog != null && !catalog.isEmpty()) {
+
−				// non-empty catalog selection.
+
−				// as we do not support catalogs this always results in no rows returned
+
−				query.append("WHERE 1=0");
+
−			} else {
+
−				boolean needWhere = true;
+
−				if (schema != null && !schema.equals("%")) {
+
−					query.append("WHERE s.\"name\" ").append(composeMatchPart(schema));
+
−					needWhere = false;
+
−				}
+
−				if (table != null && !table.equals("%")) {
+
−					query.append(needWhere ? "WHERE" : " AND")
+
−					.append(" t.\"name\" ").append(composeMatchPart(table));
+
−					needWhere = false;
+
−				}
+
−				if (unique) {
+
−					query.append(needWhere ? "WHERE" : " AND")
+
−					.append(" k.\"name\" IS NOT NULL");
+
−				}
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"NON_UNIQUE\", \"TYPE\", \"INDEX_NAME\", \"ORDINAL_POSITION\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	//== 1.2 methods (JDBC 2)
+
−
+
−	/**
+
−	 * Does the database support the given result set type?
+
−	 *
+
−	 * @param type - defined in java.sql.ResultSet
+
−	 * @return true if so; false otherwise
+
−	 * @throws SQLException - if a database access error occurs
+
−	 */
+
−	@Override
+
−	public boolean supportsResultSetType(final int type) throws SQLException {
+
−		// The only type we don't support
+
−		return type != ResultSet.TYPE_SCROLL_SENSITIVE;
+
−	}
+
−
+
−	/**
+
−	 * Does the database support the concurrency type in combination
+
−	 * with the given result set type?
+
−	 *
+
−	 * @param type - defined in java.sql.ResultSet
+
−	 * @param concurrency - type defined in java.sql.ResultSet
+
−	 * @return true if so; false otherwise
+
−	 * @throws SQLException - if a database access error occurs
+
−	*/
+
−	@Override
+
−	public boolean supportsResultSetConcurrency(final int type, final int concurrency)
+
−		throws SQLException
+
−	{
+
−		// These combinations are not supported!
+
−		if (type == ResultSet.TYPE_SCROLL_SENSITIVE)
+
−			return false;
+
−
+
−		// We do only support Read Only ResultSets
+
−		if (concurrency != ResultSet.CONCUR_READ_ONLY)
+
−			return false;
+
−
+
−		// Everything else we do (well, what's left of it :) )
+
−		return true;
+
−	}
+
−
+
−	/* lots of unsupported stuff... (no updatable ResultSet!) */
+
−	@Override
+
−	public boolean ownUpdatesAreVisible(final int type) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean ownDeletesAreVisible(final int type) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean ownInsertsAreVisible(final int type) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean othersUpdatesAreVisible(final int type) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean othersDeletesAreVisible(final int i) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean othersInsertsAreVisible(final int type) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean updatesAreDetected(final int type) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean deletesAreDetected(final int i) {
+
−		return false;
+
−	}
+
−
+
−	@Override
+
−	public boolean insertsAreDetected(final int type) {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Indicates whether the driver supports batch updates.
+
−	 */
+
−	@Override
+
−	public boolean supportsBatchUpdates() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
+
−	 * Schema-specific UDTs may have type JAVA_OBJECT, STRUCT, or DISTINCT.
+
−	 * Only types matching the catalog, schema, type name and type criteria are returned.
+
−	 * They are ordered by DATA_TYPE, TYPE_CAT, TYPE_SCHEM and TYPE_NAME.
+
−	 * The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.
+
−	 *
+
−	 * Each type description has the following columns:
+
−	 *
+
−	 * 1 TYPE_CAT String =&gt; the type's catalog (may be null)
+
−	 * 2 TYPE_SCHEM String =&gt; type's schema (may be null)
+
−	 * 3 TYPE_NAME String =&gt; type name
+
−	 * 4 CLASS_NAME String =&gt; Java class name
+
−	 * 5 DATA_TYPE int =&gt; type value defined in java.sql.Types. One of JAVA_OBJECT, STRUCT, or DISTINCT
+
−	 * 6 REMARKS String =&gt; explanatory comment on the type
+
−	 * 7 BASE_TYPE short =&gt; type code of the source type of a DISTINCT type or the type that implements the
+
−	 *   user-generated reference type of the SELF_REFERENCING_COLUMN of a structured type as defined
+
−	 *   in java.sql.Types (null if DATA_TYPE is not DISTINCT or not STRUCT with REFERENCE_GENERATION = USER_DEFINED)
+
−	 *
+
−	 * @throws SQLException - if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getUDTs(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String typeNamePattern,
+
−		final int[] types
+
−	) throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(990);
+
−		if (types != null && types.length > 0) {
+
−			query.append("SELECT * FROM (");
+
−		}
+
−		query.append("SELECT cast(null as char(1)) AS \"TYPE_CAT\", " +
+
−			"s.\"name\" AS \"TYPE_SCHEM\", " +
+
−			"t.\"sqlname\" AS \"TYPE_NAME\", " +
+
−			"CASE t.\"sqlname\"" +
+
−				// next UDT only when "CREATE TYPE xml EXTERNAL NAME xml;" is executed
+
−				" WHEN 'xml' THEN 'java.lang.String'" +
+
−				" ELSE 'java.lang.Object' END AS \"CLASS_NAME\", " +
+
−			"cast(CASE WHEN t.\"sqlname\" = 'xml' THEN " + Types.JAVA_OBJECT +
+
−				" ELSE " + Types.STRUCT + " END AS int) AS \"DATA_TYPE\", " +
+
−			"t.\"systemname\" AS \"REMARKS\", " +
+
−			"cast(null as smallint) AS \"BASE_TYPE\" " +
+
−		"FROM \"sys\".\"types\" t " +
+
−		"JOIN \"sys\".\"schemas\" s ON t.\"schema_id\" = s.\"id\" " +
+
−		// exclude the built-in types (I assume they always have id <= 99 and eclass < 18)
+
−		"WHERE t.\"id\" > 99" +
+
−		" AND t.\"eclass\" >= 18" +
+
−		" AND t.\"sqlname\" NOT IN ('inet','json','url','uuid')");
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append(" AND s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−			}
+
−			if (typeNamePattern != null && !typeNamePattern.equals("%")) {
+
−				query.append(" AND t.\"sqlname\" ").append(composeMatchPart(typeNamePattern));
+
−			}
+
−		}
+
−
+
−		if (types != null && types.length > 0) {
+
−			query.append(") AS getUDTs WHERE \"DATA_TYPE\" IN (");
+
−			for (int i = 0; i < types.length; i++) {
+
−				if (i > 0) {
+
−					query.append(',');
+
−				}
+
−				query.append(types[i]);
+
−			}
+
−			query.append(')');
+
−		}
+
−
+
−		query.append(" ORDER BY \"DATA_TYPE\", \"TYPE_SCHEM\", \"TYPE_NAME\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the connection that produced this metadata object.
+
−	 *
+
−	 * @return the connection that produced this metadata object
+
−	 */
+
−	@Override
+
−	public Connection getConnection() {
+
−		return con;
+
−	}
+
−
+
−	//== 1.4 methods (JDBC 3)
+
−
+
−	/**
+
−	 * Retrieves whether this database supports savepoints.
+
−	 *
+
−	 * @return <code>true</code> if savepoints are supported;
+
−	 *		   <code>false</code> otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsSavepoints() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports named parameters to callable
+
−	 * statements.
+
−	 *
+
−	 * @return <code>true</code> if named parameters are supported;
+
−	 *		   <code>false</code> otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsNamedParameters() {
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether it is possible to have multiple <code>ResultSet</code> objects
+
−	 * returned from a <code>CallableStatement</code> object
+
−	 * simultaneously.
+
−	 *
+
−	 * @return <code>true</code> if a <code>CallableStatement</code> object
+
−	 *		   can return multiple <code>ResultSet</code> objects
+
−	 *		   simultaneously; <code>false</code> otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsMultipleOpenResults() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether auto-generated keys can be retrieved after
+
−	 * a statement has been executed.
+
−	 *
+
−	 * @return <code>true</code> if auto-generated keys can be retrieved
+
−	 *		   after a statement has executed; <code>false</code> otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsGetGeneratedKeys() {
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the user-defined type (UDT)
+
−	 * hierarchies defined in a particular schema in this database. Only
+
−	 * the immediate super type/ sub type relationship is modeled.
+
−	 * <P>
+
−	 * Only supertype information for UDTs matching the catalog,
+
−	 * schema, and type name is returned. The type name parameter
+
−	 * may be a fully-qualified name. When the UDT name supplied is a
+
−	 * fully-qualified name, the catalog and schemaPattern parameters are
+
−	 * ignored.
+
−	 * <P>
+
−	 * If a UDT does not have a direct super type, it is not listed here.
+
−	 * A row of the <code>ResultSet</code> object returned by this method
+
−	 * describes the designated UDT and a direct supertype. A row has the following
+
−	 * columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TYPE_CAT</B> String =&gt; the UDT's catalog (may be <code>null</code>)
+
−	 *	<LI><B>TYPE_SCHEM</B> String =&gt; UDT's schema (may be <code>null</code>)
+
−	 *	<LI><B>TYPE_NAME</B> String =&gt; type name of the UDT
+
−	 *	<LI><B>SUPERTYPE_CAT</B> String =&gt; the direct super type's catalog
+
−	 *							 (may be <code>null</code>)
+
−	 *	<LI><B>SUPERTYPE_SCHEM</B> String =&gt; the direct super type's schema
+
−	 *							   (may be <code>null</code>)
+
−	 *	<LI><B>SUPERTYPE_NAME</B> String =&gt; the direct super type's name
+
−	 *	</OL>
+
−	 *
+
−	 * <P><B>Note:</B> If the driver does not support type hierarchies, an
+
−	 * empty result set is returned.
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog;
+
−	 *		  <code>null</code> means drop catalog name from the selection criteria
+
−	 * @param schemaPattern a schema name pattern; "" retrieves those without a schema
+
−	 * @param typeNamePattern a UDT name pattern; may be a fully-qualified name
+
−	 * @return a <code>ResultSet</code> object in which a row gives information
+
−	 *		   about the designated UDT
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getSuperTypes(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String typeNamePattern
+
−	) throws SQLException
+
−	{
+
−		final String query =
+
−		"SELECT cast(null as char(1)) AS \"TYPE_CAT\", '' AS \"TYPE_SCHEM\", '' AS \"TYPE_NAME\", " +
+
−			"cast(null as char(1)) AS \"SUPERTYPE_CAT\", '' AS \"SUPERTYPE_SCHEM\", '' AS \"SUPERTYPE_NAME\" " +
+
−		"WHERE 1=0";
+
−
+
−		return executeMetaDataQuery(query);
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the table hierarchies defined in a particular
+
−	 * schema in this database.
+
−	 *
+
−	 * <P>Only supertable information for tables matching the catalog, schema
+
−	 * and table name are returned. The table name parameter may be a fully-
+
−	 * qualified name, in which case, the catalog and schemaPattern parameters
+
−	 * are ignored. If a table does not have a super table, it is not listed here.
+
−	 * Supertables have to be defined in the same catalog and schema as the
+
−	 * sub tables. Therefore, the type description does not need to include
+
−	 * this information for the supertable.
+
−	 *
+
−	 * <P>Each type description has the following columns:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_CAT</B> String =&gt; the type's catalog (may be <code>null</code>)
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; type's schema (may be <code>null</code>)
+
−	 *	<LI><B>TABLE_NAME</B> String =&gt; type name
+
−	 *	<LI><B>SUPERTABLE_NAME</B> String =&gt; the direct super type's name
+
−	 *	</OL>
+
−	 *
+
−	 * <P><B>Note:</B> If the driver does not support type hierarchies, an
+
−	 * empty result set is returned.
+
−	 *
+
−	 * @param catalog a catalog name; "" retrieves those without a catalog;
+
−	 *		  <code>null</code> means drop catalog name from the selection criteria
+
−	 * @param schemaPattern a schema name pattern; "" retrieves those without a schema
+
−	 * @param tableNamePattern a table name pattern; may be a fully-qualified name
+
−	 * @return a <code>ResultSet</code> object in which each row is a type description
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getSuperTables(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String tableNamePattern
+
−	) throws SQLException
+
−	{
+
−		final String query =
+
−		"SELECT cast(null as char(1)) AS \"TABLE_CAT\", " +
+
−			"'' AS \"TABLE_SCHEM\", '' AS \"TABLE_NAME\", '' AS \"SUPERTABLE_NAME\" " +
+
−		"WHERE 1=0";
+
−
+
−		return executeMetaDataQuery(query);
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the given attribute of the given type
+
−	 * for a user-defined type (UDT) that is available in the given schema
+
−	 * and catalog.
+
−	 * <P>
+
−	 * Descriptions are returned only for attributes of UDTs matching the
+
−	 * catalog, schema, type, and attribute name criteria. They are ordered by
+
−	 * TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description
+
−	 * does not contain inherited attributes.
+
−	 * <P>
+
−	 * The <code>ResultSet</code> object that is returned has the following
+
−	 * columns:
+
−	 * <OL>
+
−	 *	<LI><B>TYPE_CAT</B> String =&gt; type catalog (may be <code>null</code>)
+
−	 *	<LI><B>TYPE_SCHEM</B> String =&gt; type schema (may be <code>null</code>)
+
−	 *	<LI><B>TYPE_NAME</B> String =&gt; type name
+
−	 *	<LI><B>ATTR_NAME</B> String =&gt; attribute name
+
−	 *	<LI><B>DATA_TYPE</B> int =&gt; attribute type SQL type from java.sql.Types
+
−	 *	<LI><B>ATTR_TYPE_NAME</B> String =&gt; Data source dependent type name.
+
−	 *	For a UDT, the type name is fully qualified. For a REF, the type name is
+
−	 *	fully qualified and represents the target type of the reference type.
+
−	 *	<LI><B>ATTR_SIZE</B> int =&gt; column size.  For char or date
+
−	 *		types this is the maximum number of characters; for numeric or
+
−	 *		decimal types this is precision.
+
−	 *	<LI><B>DECIMAL_DIGITS</B> int =&gt; the number of fractional digits
+
−	 *	<LI><B>NUM_PREC_RADIX</B> int =&gt; Radix (typically either 10 or 2)
+
−	 *	<LI><B>NULLABLE</B> int =&gt; whether NULL is allowed
+
−	 *		<UL>
+
−	 *		<LI> attributeNoNulls - might not allow NULL values
+
−	 *		<LI> attributeNullable - definitely allows NULL values
+
−	 *		<LI> attributeNullableUnknown - nullability unknown
+
−	 *		</UL>
+
−	 *	<LI><B>REMARKS</B> String =&gt; comment describing column (may be <code>null</code>)
+
−	 *	<LI><B>ATTR_DEF</B> String =&gt; default value (may be <code>null</code>)
+
−	 *	<LI><B>SQL_DATA_TYPE</B> int =&gt; unused
+
−	 *	<LI><B>SQL_DATETIME_SUB</B> int =&gt; unused
+
−	 *	<LI><B>CHAR_OCTET_LENGTH</B> int =&gt; for char types the
+
−	 *		 maximum number of bytes in the column
+
−	 *	<LI><B>ORDINAL_POSITION</B> int =&gt; index of column in table
+
−	 *		(starting at 1)
+
−	 *	<LI><B>IS_NULLABLE</B> String =&gt; "NO" means column definitely
+
−	 *		does not allow NULL values; "YES" means the column might
+
−	 *		allow NULL values.	An empty string means unknown.
+
−	 *	<LI><B>SCOPE_CATALOG</B> String =&gt; catalog of table that is the
+
−	 *		scope of a reference attribute (<code>null</code> if DATA_TYPE isn't REF)
+
−	 *	<LI><B>SCOPE_SCHEMA</B> String =&gt; schema of table that is the
+
−	 *		scope of a reference attribute (<code>null</code> if DATA_TYPE isn't REF)
+
−	 *	<LI><B>SCOPE_TABLE</B> String =&gt; table name that is the scope of a
+
−	 *		reference attribute (<code>null</code> if the DATA_TYPE isn't REF)
+
−	 *	<LI><B>SOURCE_DATA_TYPE</B> short =&gt; source type of a distinct type or user-generated
+
−	 *		Ref type,SQL type from java.sql.Types (<code>null</code> if DATA_TYPE
+
−	 *		isn't DISTINCT or user-generated REF)
+
−	 *	</OL>
+
−	 * @param catalog a catalog name; must match the catalog name as it
+
−	 *		  is stored in the database; "" retrieves those without a catalog;
+
−	 *		  <code>null</code> means that the catalog name should not be used to narrow
+
−	 *		  the search
+
−	 * @param schemaPattern a schema name pattern; must match the schema name
+
−	 *		  as it is stored in the database; "" retrieves those without a schema;
+
−	 *		  <code>null</code> means that the schema name should not be used to narrow
+
−	 *		  the search
+
−	 * @param typeNamePattern a type name pattern; must match the
+
−	 *		  type name as it is stored in the database
+
−	 * @param attributeNamePattern an attribute name pattern; must match the attribute
+
−	 *		  name as it is declared in the database
+
−	 * @return a <code>ResultSet</code> object in which each row is an
+
−	 *		   attribute description
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getAttributes(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String typeNamePattern,
+
−		final String attributeNamePattern
+
−	) throws SQLException
+
−	{
+
−		final String query =
+
−		"SELECT cast(null as char(1)) AS \"TYPE_CAT\", '' AS \"TYPE_SCHEM\", '' AS \"TYPE_NAME\", " +
+
−			"'' AS \"ATTR_NAME\", cast(0 as int) AS \"DATA_TYPE\", '' AS \"ATTR_TYPE_NAME\", cast(0 as int) AS \"ATTR_SIZE\", " +
+
−			"cast(0 as int) AS \"DECIMAL_DIGITS\", cast(0 as int) AS \"NUM_PREC_RADIX\", cast(0 as int) AS \"NULLABLE\", " +
+
−			"'' AS \"REMARKS\", '' AS \"ATTR_DEF\", cast(0 as int) AS \"SQL_DATA_TYPE\", " +
+
−			"cast(0 as int) AS \"SQL_DATETIME_SUB\", cast(0 as int) AS \"CHAR_OCTET_LENGTH\", " +
+
−			"cast(0 as int) AS \"ORDINAL_POSITION\", 'YES' AS \"IS_NULLABLE\", " +
+
−			"'' AS \"SCOPE_CATALOG\", '' AS \"SCOPE_SCHEMA\", '' AS \"SCOPE_TABLE\", " +
+
−			"cast(0 as smallint) AS \"SOURCE_DATA_TYPE\" " +
+
−		"WHERE 1=0";
+
−
+
−		return executeMetaDataQuery(query);
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports the given result set holdability.
+
−	 *
+
−	 * @param holdability one of the following constants:
+
−	 *			<code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or
+
−	 *			<code>ResultSet.CLOSE_CURSORS_AT_COMMIT</code>
+
−	 * @return <code>true</code> if so; <code>false</code> otherwise
+
−	 * @see Connection
+
−	 */
+
−	@Override
+
−	public boolean supportsResultSetHoldability(final int holdability) {
+
−		// we don't close ResultSets at commit; and we don't do updateable
+
−		// result sets, so comes closest to hold cursors over commit
+
−		return holdability == ResultSet.HOLD_CURSORS_OVER_COMMIT;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the default holdability of this <code>ResultSet</code>
+
−	 * object.
+
−	 *
+
−	 * @return the default holdability; either
+
−	 *		   <code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or
+
−	 *		   <code>ResultSet.CLOSE_CURSORS_AT_COMMIT</code>
+
−	 */
+
−	@Override
+
−	public int getResultSetHoldability() {
+
−		return ResultSet.HOLD_CURSORS_OVER_COMMIT;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the major version number of the underlying database.
+
−	 *
+
−	 * @return the underlying database's major version
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public int getDatabaseMajorVersion() throws SQLException {
+
−		return con.getDatabaseMajorVersion();
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the minor version number of the underlying database.
+
−	 *
+
−	 * @return underlying database's minor version
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public int getDatabaseMinorVersion() throws SQLException {
+
−		return con.getDatabaseMinorVersion();
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the major JDBC version number for this driver.
+
−	 *
+
−	 * @return JDBC version major number
+
−	 */
+
−	@Override
+
−	public int getJDBCMajorVersion() {
+
−		return 4; // This class implements JDBC 4.2 (at least we try to)
+
−	}
+
−
+
−	/**
+
−	 * Retrieves the minor JDBC version number for this driver.
+
−	 *
+
−	 * @return JDBC version minor number
+
−	 */
+
−	@Override
+
−	public int getJDBCMinorVersion() {
+
−		return 2; // This class implements JDBC 4.2 (at least we try to)
+
−	}
+
−
+
−	/**
+
−	 * Indicates whether the SQLSTATEs returned by <code>SQLException.getSQLState</code>
+
−	 * is X/Open (now known as Open Group) SQL CLI or SQL:2003.
+
−	 * @return the type of SQLSTATEs, one of:
+
−	 *		  sqlStateXOpen or
+
−	 *		  sqlStateSQL
+
−	 */
+
−	@Override
+
−	public int getSQLStateType() {
+
−		// At least this driver conforms with SQLSTATE to the SQL:2003 standard
+
−		return DatabaseMetaData.sqlStateSQL;
+
−	}
+
−
+
−	/**
+
−	 * Indicates whether updates made to a LOB are made on a copy or directly
+
−	 * to the LOB.
+
−	 * @return <code>true</code> if updates are made to a copy of the LOB;
+
−	 *		   <code>false</code> if updates are made directly to the LOB
+
−	 */
+
−	@Override
+
−	public boolean locatorsUpdateCopy() {
+
−		// not that we have it, but in a transaction it will be copy-on-write
+
−		return true;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports statement pooling.
+
−	 *
+
−	 * @return <code>true</code> is so;
+
−		<code>false</code> otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsStatementPooling() {
+
−		// For the moment, I don't think so
+
−		return false;
+
−	}
+
−
+
−	//== 1.6 methods (JDBC 4)
+
−
+
−	/**
+
−	 * Indicates whether or not this data source supports the SQL ROWID
+
−	 * type, and if so the lifetime for which a RowId object remains
+
−	 * valid.
+
−	 *
+
−	 * @return ROWID_UNSUPPORTED for now
+
−	 */
+
−	@Override
+
−	public RowIdLifetime getRowIdLifetime() {
+
−		// I believe we don't do rowids
+
−		return RowIdLifetime.ROWID_UNSUPPORTED;
+
−	}
+
−
+
−	/**
+
−	 * Get the schema names available in this database.  The results
+
−	 * are ordered by schema name.
+
−	 *
+
−	 * <P>The schema column is:
+
−	 *	<OL>
+
−	 *	<LI><B>TABLE_SCHEM</B> String =&gt; schema name
+
−	 *	<LI><B>TABLE_CATALOG</B> String =&gt; catalog name (may be null)
+
−	 *	</OL>
+
−	 *
+
−	 * @return ResultSet each row has a single String column that is a
+
−	 *         schema name
+
−	 * @throws SQLException if a database error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getSchemas() throws SQLException {
+
−		return getSchemas(null, null);
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports invoking user-defined or
+
−	 * vendor functions using the stored procedure escape syntax.
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsStoredFunctionsUsingCallSyntax() {
+
−		return con.supportsEscapeSequenceSyntax();
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether a SQLException while autoCommit is true
+
−	 * inidcates that all open ResultSets are closed, even ones that are
+
−	 * holdable. When a SQLException occurs while autocommit is true, it
+
−	 * is vendor specific whether the JDBC driver responds with a commit
+
−	 * operation, a rollback operation, or by doing neither a commit nor
+
−	 * a rollback. A potential result of this difference is in whether
+
−	 * or not holdable ResultSets are closed.
+
−	 *
+
−	 * @return true if so; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean autoCommitFailureClosesAllResultSets() {
+
−		// The driver caches most of it, and as far as I knoww the
+
−		// server doesn't close outstanding result handles on commit
+
−		// failure either.
+
−		return false;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a list of the client info properties that the driver
+
−	 * supports. The result set contains the following columns:
+
−	 *    1. NAME String =&gt; The name of the client info property
+
−	 *    2. MAX_LEN int =&gt; The maximum length of the value for the property
+
−	 *    3. DEFAULT_VALUE String =&gt; The default value of the property
+
−	 *    4. DESCRIPTION String =&gt; A description of the property.
+
−	 *       This will typically contain information as to
+
−	 *       where this property is stored in the database.
+
−	 * The ResultSet is sorted by the NAME column
+
−	 *
+
−	 * @return A ResultSet object; each row is a supported client info property
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getClientInfoProperties() throws SQLException {
+
−		String query = "SELECT cast('' as varchar(40)) AS \"NAME\", cast(0 as int) AS \"MAX_LEN\", cast('' as varchar(128)) AS \"DEFAULT_VALUE\", cast('' as varchar(256)) AS \"DESCRIPTION\" WHERE 1=0";
+
−		// only MonetDB Server 11.51 (Aug2024) or higher supports table sys.clientinfo_properties
+
−		if (con.checkMinimumDBVersion(11, 51)) {
+
−			// The query combines the 5 properties (added in Aug2024) we know about with
+
−			// any additional properties that may have been added later to sys.clientinfo_properties table
+
−			query = "SELECT prop AS \"NAME\", cast(maxlen as int) AS \"MAX_LEN\", defval AS \"DEFAULT_VALUE\", descr AS \"DESCRIPTION\"" +
+
−				" FROM sys.clientinfo_properties" +
+
−				" LEFT OUTER JOIN (VALUES " +
+
−				"('ApplicationName',128," + stringEscape(ClientInfo.defaultApplicationName) + ",'Name of the application')," +
+
−				"('ClientHostname',128," + stringEscape(ClientInfo.defaultHostname) + ",'Host the application is running on')," +
+
−				"('ClientLibrary',128," + stringEscape(ClientInfo.defaultClientLibrary) + ",'Name and version of the driver')," +
+
−				"('ClientPid',19," + stringEscape(ClientInfo.defaultPid) + ",'Process id of the application')," +
+
−				"('ClientRemark',256,NULL,'Additional information')" +
+
−				") AS t(nm, maxlen, defval, descr) ON prop = nm" +
+
−				" ORDER BY 1";
+
−		}
+
−		return executeMetaDataQuery(query);
+
−	}
+
−
+
−	private static String stringEscape(String s) {
+
−		return "R'" + s.replaceAll("'", "''") + "'";
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the system and user functions
+
−	 * available in the given catalog.
+
−	 *
+
−	 * Only system and user function descriptions matching the schema
+
−	 * and function name criteria are returned. They are ordered by
+
−	 * FUNCTION_CAT, FUNCTION_SCHEM, FUNCTION_NAME and SPECIFIC_ NAME.
+
−	 *
+
−	 * Each function description has the the following columns:
+
−	 *
+
−	 *    1. FUNCTION_CAT String =&gt; function catalog (may be null)
+
−	 *    2. FUNCTION_SCHEM String =&gt; function schema (may be null)
+
−	 *    3. FUNCTION_NAME String =&gt; function name. This is the
+
−	 *       name used to invoke the function
+
−	 *    4. REMARKS String =&gt; explanatory comment on the function
+
−	 *    5. FUNCTION_TYPE short =&gt; kind of function:
+
−	 *        * functionResultUnknown - Cannot determine if a return
+
−	 *          value or table will be returned
+
−	 *        * functionNoTable- Does not return a table
+
−	 *        * functionReturnsTable - Returns a table
+
−	 *    6. SPECIFIC_NAME String =&gt; the name which uniquely identifies
+
−	 *       this function within its schema. This is a user specified,
+
−	 *       or DBMS generated, name that may be different then the
+
−	 *       FUNCTION_NAME for example with overload functions
+
−	 *
+
−	 * A user may not have permission to execute any of the functions
+
−	 * that are returned by getFunctions.
+
−	 *
+
−	 * @param catalog a catalog name; must match the catalog name as it
+
−	 *        is stored in the database; "" retrieves those without a
+
−	 *        catalog; null means that the catalog name should not be
+
−	 *        used to narrow the search
+
−	 * @param schemaPattern a schema name pattern; must match the schema
+
−	 *        name as it is stored in the database; "" retrieves those
+
−	 *        without a schema; null means that the schema name should
+
−	 *        not be used to narrow the search
+
−	 * @param functionNamePattern a function name pattern; must match
+
−	 *        the function name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet - each row is a function description
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getFunctions(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String functionNamePattern
+
−	) throws SQLException
+
−	{
+
−		final boolean useCommentsTable = con.commentsTableExists();
+
−		final StringBuilder query = new StringBuilder(800);
+
−		query.append("SELECT cast(null as char(1)) AS \"FUNCTION_CAT\", " +
+
−			"s.\"name\" AS \"FUNCTION_SCHEM\", " +
+
−			"f.\"name\" AS \"FUNCTION_NAME\", ")
+
−			.append(useCommentsTable ? "COALESCE(cm.\"remark\", cast(f.\"func\" as varchar(9999)))" : "cast(f.\"func\" as varchar(9999))").append(" AS \"REMARKS\", " +
+
−			"CASE WHEN f.\"type\" IN (1,2,3,4,6) THEN " + DatabaseMetaData.functionNoTable +
+
−			" WHEN f.\"type\" IN (5,7) THEN " + DatabaseMetaData.functionReturnsTable +
+
−			" ELSE " + DatabaseMetaData.functionResultUnknown + " END AS \"FUNCTION_TYPE\", " +
+
−			// only the id value uniquely identifies a function. Include it to be able to differentiate between multiple overloaded functions with the same name
+
−			"cast(f.\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " +
+
−		"FROM \"sys\".\"functions\" f " +
+
−		"JOIN \"sys\".\"schemas\" s ON f.\"schema_id\" = s.\"id\" ");
+
−		if (useCommentsTable) {
+
−			query.append("LEFT OUTER JOIN \"sys\".\"comments\" cm ON f.\"id\" = cm.\"id\" ");
+
−		}
+
−		// only functions, so exclude procedures (type = 2). Those will to be returned via getProcedures()
+
−		query.append("WHERE f.\"type\" <> 2");
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append(" AND s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−			}
+
−			if (functionNamePattern != null && !functionNamePattern.equals("%")) {
+
−				query.append(" AND f.\"name\" ").append(composeMatchPart(functionNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"FUNCTION_SCHEM\", \"FUNCTION_NAME\", \"SPECIFIC_NAME\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	/**
+
−	 * Retrieves a description of the given catalog's system or user
+
−	 * function parameters and return type.
+
−	 *
+
−	 * Only descriptions matching the schema, function and parameter name criteria are returned.
+
−	 * They are ordered by FUNCTION_CAT, FUNCTION_SCHEM, FUNCTION_NAME and SPECIFIC_ NAME.
+
−	 * Within this, the return value, if any, is first. Next are the parameter descriptions in call order.
+
−	 * The column descriptions follow in column number order.
+
−	 *
+
−	 * 1.  FUNCTION_CAT String =&gt; function catalog (may be null)
+
−	 * 2.  FUNCTION_SCHEM String =&gt; function schema (may be null)
+
−	 * 3.  FUNCTION_NAME String =&gt; function name. This is the name used to invoke the function
+
−	 * 4.   COLUMN_NAME String =&gt; column/parameter name
+
−	 * 5.   COLUMN_TYPE Short =&gt; kind of column/parameter:
+
−	 *         functionColumnUnknown - nobody knows
+
−	 *         functionColumnIn - IN parameter
+
−	 *         functionColumnInOut - INOUT parameter
+
−	 *         functionColumnOut - OUT parameter
+
−	 *         functionColumnReturn - function return value
+
−	 *         functionColumnResult - Indicates that the parameter or column is a column in the ResultSet
+
−	 * 6.   DATA_TYPE int =&gt; SQL type from java.sql.Types
+
−	 * 7.   TYPE_NAME String =&gt; SQL type name, for a UDT type the type name is fully qualified
+
−	 * 8.   PRECISION int =&gt; precision
+
−	 * 9.   LENGTH int =&gt; length in bytes of data
+
−	 * 10.  SCALE short =&gt; scale - null is returned for data types where SCALE is not applicable.
+
−	 * 11.  RADIX short =&gt; radix
+
−	 * 12.  NULLABLE short =&gt; can it contain NULL.
+
−	 *         functionNoNulls - does not allow NULL values
+
−	 *         functionNullable - allows NULL values
+
−	 *         functionNullableUnknown - nullability unknown
+
−	 * 13.  REMARKS String =&gt; comment describing column/parameter
+
−	 * 14.  CHAR_OCTET_LENGTH int =&gt; the maximum length of binary and character based parameters or columns. For any other datatype the returned value is a NULL
+
−	 * 15.  ORDINAL_POSITION int =&gt; the ordinal position, starting from 1, for the input and output parameters.
+
−	 *	   A value of 0 is returned if this row describes the function's return value. For result set columns, it is the ordinal position of the column in the result set starting from 1.
+
−	 * 16.  IS_NULLABLE String =&gt; ISO rules are used to determine the nullability for a parameter or column.
+
−	 *         YES --- if the parameter or column can include NULLs
+
−	 *         NO --- if the parameter or column cannot include NULLs
+
−	 *         empty string --- if the nullability for the parameter or column is unknown
+
−	 * 17.  SPECIFIC_NAME String =&gt; the name which uniquely identifies this function within its schema.
+
−	 *	  This is a user specified, or DBMS generated, name that may be different then the FUNCTION_NAME for example with overload functions
+
−	 *
+
−	 * @param catalog a catalog name; must match the catalog name as
+
−	 *        it is stored in the database; "" retrieves those without a
+
−	 *        catalog; null means that the catalog name should not be
+
−	 *        used to narrow the search
+
−	 * @param schemaPattern a schema name pattern; must match the schema
+
−	 *        name as it is stored in the database; "" retrieves those
+
−	 *        without a schema; null means that the schema name should
+
−	 *        not be used to narrow the search
+
−	 * @param functionNamePattern a procedure name pattern; must match the
+
−	 *        function name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @param columnNamePattern a parameter name pattern; must match the
+
−	 *        parameter or column name as it is stored in the database
+
−	 *   Note that our implementation allows this param to be null also (for efficiency as no extra LIKE '%' condition is added to be evaluated).
+
−	 * @return ResultSet - each row describes a user function parameter,
+
−	 *         column or return type
+
−	 * @throws SQLException - if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getFunctionColumns(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String functionNamePattern,
+
−		final String columnNamePattern
+
−	) throws SQLException
+
−	{
+
−		final StringBuilder query = new StringBuilder(2600);
+
−		query.append("SELECT cast(null as char(1)) AS \"FUNCTION_CAT\", " +
+
−			"s.\"name\" AS \"FUNCTION_SCHEM\", " +
+
−			"f.\"name\" AS \"FUNCTION_NAME\", " +
+
−			"a.\"name\" AS \"COLUMN_NAME\", " +
+
−			"cast(CASE a.\"inout\"" +
+
−				" WHEN 0 THEN (CASE a.\"number\" WHEN 0 THEN " + DatabaseMetaData.functionReturn + " ELSE " + DatabaseMetaData.functionColumnOut + " END)" +
+
−				" WHEN 1 THEN " + DatabaseMetaData.functionColumnIn +
+
−				" ELSE " + DatabaseMetaData.functionColumnUnknown + " END AS smallint) AS \"COLUMN_TYPE\", " +
+
−			"cast(").append(MonetDriver.getSQLTypeMap("a.\"type\"")).append(" AS int) AS \"DATA_TYPE\", " +
+
−			"a.\"type\" AS \"TYPE_NAME\", " +
+
−			"CASE a.\"type\" WHEN 'tinyint' THEN 3 WHEN 'smallint' THEN 5 WHEN 'int' THEN 10 WHEN 'bigint' THEN 19" +
+
−				" WHEN 'hugeint' THEN 38 WHEN 'oid' THEN 19 WHEN 'wrd' THEN 19 ELSE a.\"type_digits\" END AS \"PRECISION\", " +
+
−			"CASE a.\"type\" WHEN 'tinyint' THEN 1 WHEN 'smallint' THEN 2 WHEN 'int' THEN 4 WHEN 'bigint' THEN 8" +
+
−				" WHEN 'hugeint' THEN 16 WHEN 'oid' THEN 8 WHEN 'wrd' THEN 8 ELSE a.\"type_digits\" END AS \"LENGTH\", " +
+
−			"cast(CASE WHEN a.\"type\" IN ('tinyint','smallint','int','bigint','hugeint','oid','wrd','decimal','numeric'," +
+
−				"'time','timetz','timestamp','timestamptz','day_interval','month_interval','sec_interval') THEN a.\"type_scale\" ELSE NULL END AS smallint) AS \"SCALE\", " +
+
−			"cast(CASE WHEN a.\"type\" IN ('tinyint','smallint','int','bigint','hugeint','oid','wrd','decimal','numeric','day_interval','month_interval','sec_interval') THEN 10" +
+
−				" WHEN a.\"type\" IN ('real','float','double') THEN 2 ELSE NULL END AS smallint) AS \"RADIX\", " +
+
−			// mvd: do not remove next append. The String above is same as used by getProcedureColumns, so shared in class file.
+
−			"cast(").append(DatabaseMetaData.functionNullableUnknown).append(" AS smallint) AS \"NULLABLE\", " +
+
−			"cast(null as char(1)) AS \"REMARKS\", " +
+
−			"cast(CASE WHEN a.\"type\" IN ('varchar','clob','char','json','url','xml') THEN 4 * cast(a.\"type_digits\" as bigint) WHEN a.\"type\" = 'blob' THEN a.\"type_digits\" ELSE NULL END as bigint) AS \"CHAR_OCTET_LENGTH\", " +
+
−			"cast(a.\"number\" as int) AS \"ORDINAL_POSITION\", " +
+
−			"cast('' as varchar(3)) AS \"IS_NULLABLE\", " +
+
−			// the specific name contains the function id, in order to be able to match the args to the correct overloaded function name
+
−			"cast(f.\"id\" as varchar(10)) AS \"SPECIFIC_NAME\" " +
+
−		"FROM \"sys\".\"args\" a " +
+
−		"JOIN \"sys\".\"functions\" f ON a.\"func_id\" = f.\"id\" " +
+
−		"JOIN \"sys\".\"schemas\" s ON f.\"schema_id\" = s.\"id\" " +
+
−		// only functions, so exclude procedures (type = 2). Those will to be returned via getProcedureColumns()
+
−		"WHERE f.\"type\" <> 2");
+
−
+
−		if (catalog != null && !catalog.isEmpty()) {
+
−			// non-empty catalog selection.
+
−			// as we do not support catalogs this always results in no rows returned
+
−			query.append(" AND 1=0");
+
−		} else {
+
−			if (schemaPattern != null && !schemaPattern.equals("%")) {
+
−				query.append(" AND s.\"name\" ").append(composeMatchPart(schemaPattern));
+
−			}
+
−			if (functionNamePattern != null && !functionNamePattern.equals("%")) {
+
−				query.append(" AND f.\"name\" ").append(composeMatchPart(functionNamePattern));
+
−			}
+
−			if (columnNamePattern != null && !columnNamePattern.equals("%")) {
+
−				query.append(" AND a.\"name\" ").append(composeMatchPart(columnNamePattern));
+
−			}
+
−		}
+
−
+
−		query.append(" ORDER BY \"FUNCTION_SCHEM\", \"FUNCTION_NAME\", \"SPECIFIC_NAME\", \"ORDINAL_POSITION\"");
+
−
+
−		return executeMetaDataQuery(query.toString());
+
−	}
+
−
+
−	//== 1.7 methods (JDBC 4.1)
+
−
+
−	/**
+
−	 * Retrieves a description of the pseudo or hidden columns available
+
−	 * in a given table within the specified catalog and schema.  Pseudo
+
−	 * or hidden columns may not always be stored within a table and are
+
−	 * not visible in a ResultSet unless they are specified in the
+
−	 * query's outermost SELECT list.  Pseudo or hidden columns may not
+
−	 * necessarily be able to be modified.
+
−	 * If there are no pseudo or hidden columns, an empty ResultSet is returned.
+
−	 *
+
−	 * Only column descriptions matching the catalog, schema, table and column name criteria are returned.
+
−	 * They are ordered by TABLE_CAT,TABLE_SCHEM, TABLE_NAME and COLUMN_NAME.
+
−	 *
+
−	 * Each column description has the following columns:
+
−	 *
+
−	 *  1. TABLE_CAT String =&gt; table catalog (may be null)
+
−	 *  2. TABLE_SCHEM String =&gt; table schema (may be null)
+
−	 *  3. TABLE_NAME String =&gt; table name
+
−	 *  4. COLUMN_NAME String =&gt; column name
+
−	 *  5. DATA_TYPE int =&gt; SQL type from java.sql.Types
+
−	 *  6. COLUMN_SIZE int =&gt; column size.
+
−	 *  7. DECIMAL_DIGITS int =&gt; the number of fractional digits. Null is returned for data types where DECIMAL_DIGITS is not applicable.
+
−	 *  8. NUM_PREC_RADIX int =&gt; Radix (typically either 10 or 2)
+
−	 *  9. COLUMN_USAGE String =&gt; The allowed usage for the column. The value returned will correspond to the enum name returned by PseudoColumnUsage.name()
+
−	 * 10. REMARKS String =&gt; comment describing column (may be null)
+
−	 * 11. CHAR_OCTET_LENGTH int =&gt; for char types the maximum number of bytes in the column
+
−	 * 12. IS_NULLABLE String =&gt; ISO rules are used to determine the nullability for a column.
+
−	 *         YES --- if the column can include NULLs
+
−	 *         NO --- if the column cannot include NULLs
+
−	 *         empty string --- if the nullability for the column is unknown
+
−	 *
+
−	 * @param catalog a catalog name
+
−	 * @param schemaPattern a schema name pattern
+
−	 * @param tableNamePattern a table name pattern
+
−	 * @param columnNamePattern a column name pattern
+
−	 * @return ResultSet where each row is a column description
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	@Override
+
−	public ResultSet getPseudoColumns(
+
−		final String catalog,
+
−		final String schemaPattern,
+
−		final String tableNamePattern,
+
−		final String columnNamePattern
+
−	) throws SQLException
+
−	{
+
−		// MonetDB currently does not support pseudo or hidden columns, so return an empty ResultSet
+
−		final String query =
+
−		"SELECT cast(null as char(1)) AS \"TABLE_CAT\", " +
+
−			"'' AS \"TABLE_SCHEM\", " +
+
−			"'' AS \"TABLE_NAME\", " +
+
−			"'' AS \"COLUMN_NAME\", " +
+
−			"cast(0 as int) AS \"DATA_TYPE\", " +
+
−			"cast(0 as int) AS \"COLUMN_SIZE\", " +
+
−			"cast(0 as int) AS \"DECIMAL_DIGITS\", " +
+
−			"cast(0 as int) AS \"NUM_PREC_RADIX\", " +
+
−			"'' AS \"COLUMN_USAGE\", " +
+
−			"'' AS \"REMARKS\", " +
+
−			"cast(0 as int) AS \"CHAR_OCTET_LENGTH\", " +
+
−			"'' AS \"IS_NULLABLE\" " +
+
−		"WHERE 1=0";
+
−
+
−		return executeMetaDataQuery(query);
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether a generated key will always be returned if the
+
−	 * column name(s) or index(es) specified for the auto generated key
+
−	 * column(s) are valid and the statement succeeds.  The key that is
+
−	 * returned may or may not be based on the column(s) for the auto
+
−	 * generated key.
+
−	 *
+
−	 * @return true if so, false otherwise
+
−	 * @throws SQLException - if a database access error occurs
+
−	 */
+
−	@Override
+
−	public boolean generatedKeyAlwaysReturned() throws SQLException {
+
−		return true;
+
−	}
+
−
+
−	//== Java 1.8 methods (JDBC 4.2)
+
−
+
−	/**
+
−	 * Retrieves the maximum number of bytes this database allows for the logical size for a LOB.
+
−	 * The default implementation will return 0
+
−	 * @return the maximum number of bytes allowed; a result of zero means that there is no limit or the limit is not known
+
−	 */
+
−	@Override
+
−	public long getMaxLogicalLobSize() {
+
−		return 0;
+
−	}
+
−
+
−	/**
+
−	 * Retrieves whether this database supports REF CURSOR.
+
−	 * The default implementation will return false
+
−	 * @return true if this database supports REF CURSOR; false otherwise
+
−	 */
+
−	@Override
+
−	public boolean supportsRefCursors() {
+
−		return false;
+
−	}
+
−
+
−	//== end methods interface DatabaseMetaData
+
−
+
−
+
−	//== internal helper methods which do not belong to the JDBC interface
+
−
+
−	/**
+
−	 * Internal utility method to create a Statement object, execute a query and return the ResulSet object which allows scrolling.
+
−	 * As the Statement object is created internally (the caller does not see it and thus can not close it),
+
−	 * we set it to close (and free server resources) when the ResultSet object is closed by the caller.
+
−	 *
+
−	 * @param query the SQL query to execute
+
−	 * @return a scrollable ResulSet or null when query failed to be executed
+
−	 * @throws SQLException if a database access error occurs
+
−	 */
+
−	private final ResultSet executeMetaDataQuery(final String query) throws SQLException {
+
−		final Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+
−		ResultSet rs = null;
+
−		if (stmt != null) {
+
−// for debug: System.out.println("SQL (len " + query.length() + "): " + query);
+
−			rs = stmt.executeQuery(query);
+
−			if (rs != null) {
+
−				/* we want the statement object to be closed also when the resultset is closed by the caller */
+
−				stmt.closeOnCompletion();
+
−			} else {
+
−				/* failed to produce a resultset, so release resources for created statement object now */
+
−				stmt.close();
+
−			}
+
−		}
+
−		return rs;
+
−	}
+
−
+
−	/**
+
−	 * Returns a SQL match part string where depending on the input value we compose
+
−	 * - an exact string match (using = comparator) or
+
−	 * - a match with wildcards (using LIKE comparator) or
+
−	 * - when input is missing (using IS NULL comparator)
+
−	 *
+
−	 * Note that wildcard characters can be escaped by prefix \ (a backslash)
+
−	 * When ALL wildcard characters are escaped then we remove the \'s and compose an = comparator string match.
+
−	 *
+
−	 * @param in the string to match
+
−	 * @return the SQL match part string
+
−	 */
+
−	private final String composeMatchPart(final String in) {
+
−		if (in == null)
+
−			return "IS NULL";
+
−
+
−		final int len = in.length();
+
−		if (len == 0)
+
−			return "= ''";
+
−
+
−		if (in.equals("%") || in.equals("%%"))
+
−			return "LIKE '%'";
+
−
+
−		// Scan input string for SQL wildcard characters: % and _
+
−		// When they are all prefixed by a backslash then the backslash is removed (to allow usage of = comparator)
+
−		// else it needs to be interpreted as a wildcard and we need to use LIKE instead of = comparator.
+
−		// A backslash can be escaped by using two backslashes.
+
−		final StringBuilder sb = new StringBuilder(len);
+
−		boolean removed_bs = false;
+
−		boolean use_like = false;
+
−		boolean escaped = false;
+
−		try {
+
−			// parse all characters in input to find if the wildcards are escaped by a \.
+
−			// note: the escape character \ can also be escaped, so \\.
+
−			for (int i = 0; i < len; i++) {
+
−				char c = in.charAt(i);
+
−				switch(c) {
+
−				case '\\':
+
−					if (escaped) {
+
−						// copy the 2 backslash characters as in the original string
+
−						sb.append(c).append(c);
+
−						escaped = false;
+
−					} else {
+
−						escaped = true;
+
−					}
+
−					break;
+
−				case '%':
+
−				case '_':
+
−					if (escaped) {
+
−						removed_bs = true;
+
−						escaped = false;
+
−					} else {
+
−						use_like = true;
+
−						i = len; /* no need to scan further */
+
−					}
+
−					sb.append(c);
+
−					break;
+
−				default:
+
−					if (escaped) {
+
−						sb.append('\\');	// also copy the preceding escape found before this character
+
−						escaped = false;
+
−					}
+
−					sb.append(c);
+
−					break;
+
−				}
+
−			}
+
−		} catch (IndexOutOfBoundsException iob) {
+
−			/* ignore */
+
−		}
+
−
+
−		if (use_like) {
+
−		// for debug: System.out.println("input: " + in + " changed into: " + "LIKE " + MonetWrapper.sq(in));
+
−			// we found a non-escaped wildcard character, use like and the original input
+
−			return "LIKE " + MonetWrapper.sq(in);
+
−		}
+
−		if (removed_bs) {
+
−		// for debug: System.out.println("input: " + in + " changed into: " + "= " + MonetWrapper.sq(sb.toString()));
+
−			// we found only escaped wildcard character(s),
+
−			// use the edited string without the ecapes before the wildcard character(s) so an equals match can be done (which is faster than LIKE)
+
−			return "= " + MonetWrapper.sq(sb.toString());
+
−		}
+
−		// for debug: System.out.println("input: " + in + " changed into: " + "= " + MonetWrapper.sq(in));
+
−		return "= " + MonetWrapper.sq(in);
+
−	}
+
−
+
−	//== end helper methods
+
−}