Mercurial > hg > monetdb-java

comparison src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 213:115f6351bf4b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update some documentation text
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 29 Mar 2018 18:43:34 +0200 (2018-03-29)
parents c38d4eaf5479
children 71b039bc2d99
comparison
equal deleted inserted replaced
210:2dbfc65d8e03 213:115f6351bf4b
298 } 298 }
299 299
300 /** 300 /**
301 * Does the database treat mixed case unquoted SQL identifiers 301 * Does the database treat mixed case unquoted SQL identifiers
302 * as case sensitive and as a result store them in mixed case? 302 * as case sensitive and as a result store them in mixed case?
303 * A JDBC-Compliant driver will always return false. 303 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns false.
304 * 304 *
305 * @return false 305 * @return false
306 */ 306 */
307 @Override 307 @Override
308 public boolean supportsMixedCaseIdentifiers() { 308 public boolean supportsMixedCaseIdentifiers() {
342 return false; 342 return false;
343 } 343 }
344 344
345 /** 345 /**
346 * Does the database treat mixed case quoted SQL identifiers as 346 * Does the database treat mixed case quoted SQL identifiers as
347 * case sensitive and as a result store them in mixed case? A 347 * case sensitive and as a result store them in mixed case?
348 * JDBC compliant driver will always return true. 348 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
349 * 349 *
350 * @return true if so 350 * @return true if so
351 */ 351 */
352 @Override 352 @Override
353 public boolean supportsMixedCaseQuotedIdentifiers() { 353 public boolean supportsMixedCaseQuotedIdentifiers() {
386 public boolean storesMixedCaseQuotedIdentifiers() { 386 public boolean storesMixedCaseQuotedIdentifiers() {
387 return false; 387 return false;
388 } 388 }
389 389
390 /** 390 /**
391 * What is the string used to quote SQL identifiers? This returns 391 * What is the string used to quote SQL identifiers?
392 * a space if identifier quoting isn't supported. A JDBC Compliant 392 * This returns a space if identifier quoting isn't supported.
393 * driver will always use a double quote character. 393 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver
394 * will always use a double quote character.
394 * 395 *
395 * @return the quoting string 396 * @return the quoting string
396 */ 397 */
397 @Override 398 @Override
398 public String getIdentifierQuoteString() { 399 public String getIdentifierQuoteString() {
571 572
572 /** 573 /**
573 * Is column aliasing supported? 574 * Is column aliasing supported?
574 * 575 *
575 * <p>If so, the SQL AS clause can be used to provide names for 576 * <p>If so, the SQL AS clause can be used to provide names for
576 * computed columns or to provide alias names for columns as 577 * computed columns or to provide alias names for columns as required.
577 * required. A JDBC Compliant driver always returns true. 578 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
578 * 579 *
579 * <p>e.g. 580 * <p>e.g.
580 * 581 *
581 * <br><pre> 582 * <br><pre>
582 * select count(C) as C_COUNT from T group by C; 583 * select count(C) as C_COUNT from T group by C;
590 public boolean supportsColumnAliasing() { 591 public boolean supportsColumnAliasing() {
591 return true; 592 return true;
592 } 593 }
593 594
594 /** 595 /**
595 * Are concatenations between NULL and non-NULL values NULL? A 596 * Are concatenations between NULL and non-NULL values NULL?
596 * JDBC Compliant driver always returns true 597 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
597 * 598 *
598 * @return true if so 599 * @return true if so
599 */ 600 */
600 @Override 601 @Override
601 public boolean nullPlusNonNullIsNull() { 602 public boolean nullPlusNonNullIsNull() {
756 // conversion from all other JDBC SQL types are not supported 757 // conversion from all other JDBC SQL types are not supported
757 return false; 758 return false;
758 } 759 }
759 760
760 /** 761 /**
761 * Are table correlation names supported? A JDBC Compliant 762 * Are table correlation names supported?
762 * driver always returns true. 763 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
763 * 764 *
764 * @return true if so 765 * @return true if so
765 */ 766 */
766 @Override 767 @Override
767 public boolean supportsTableCorrelationNames() { 768 public boolean supportsTableCorrelationNames() {
837 public boolean supportsGroupByBeyondSelect() { 838 public boolean supportsGroupByBeyondSelect() {
838 return true; 839 return true;
839 } 840 }
840 841
841 /** 842 /**
842 * Is the escape character in "LIKE" clauses supported? A 843 * Is the escape character in "LIKE" clauses supported?
843 * JDBC compliant driver always returns true. 844 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
844 * 845 *
845 * @return true if so 846 * @return true if so
846 */ 847 */
847 @Override 848 @Override
848 public boolean supportsLikeEscapeClause() { 849 public boolean supportsLikeEscapeClause() {
870 public boolean supportsMultipleTransactions() { 871 public boolean supportsMultipleTransactions() {
871 return true; 872 return true;
872 } 873 }
873 874
874 /** 875 /**
875 * Can columns be defined as non-nullable. A JDBC Compliant driver 876 * Can columns be defined as non-nullable.
876 * always returns true. 877 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
877 * 878 *
878 * @return true if so 879 * @return true if so
879 */ 880 */
880 @Override 881 @Override
881 public boolean supportsNonNullableColumns() { 882 public boolean supportsNonNullableColumns() {
919 return false; 920 return false;
920 } 921 }
921 922
922 /** 923 /**
923 * Does this driver support the ANSI-92 entry level SQL grammar? 924 * Does this driver support the ANSI-92 entry level SQL grammar?
924 * All JDBC Compliant drivers must return true. We should be this 925 * All JDBC Compliant <sup><font size=-2>TM</font></sup> drivers must return true.
925 * compliant, so let's 'act' like we are.
926 * 926 *
927 * @return true if so 927 * @return true if so
928 */ 928 */
929 @Override 929 @Override
930 public boolean supportsANSI92EntryLevelSQL() { 930 public boolean supportsANSI92EntryLevelSQL() {
1195 public boolean supportsStoredProcedures() { 1195 public boolean supportsStoredProcedures() {
1196 return true; 1196 return true;
1197 } 1197 }
1198 1198
1199 /** 1199 /**
1200 * Are subqueries in comparison expressions supported? A JDBC 1200 * Are subqueries in comparison expressions supported?
1201 * Compliant driver always returns true. MonetDB also supports this 1201 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
1202 * MonetDB also supports this
1202 * 1203 *
1203 * @return true if so; false otherwise 1204 * @return true if so; false otherwise
1204 */ 1205 */
1205 @Override 1206 @Override
1206 public boolean supportsSubqueriesInComparisons() { 1207 public boolean supportsSubqueriesInComparisons() {
1207 return true; 1208 return true;
1208 } 1209 }
1209 1210
1210 /** 1211 /**
1211 * Are subqueries in 'exists' expressions supported? A JDBC 1212 * Are subqueries in 'exists' expressions supported?
1212 * Compliant driver always returns true. 1213 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
1213 * 1214 *
1214 * @return true if so; false otherwise 1215 * @return true if so; false otherwise
1215 */ 1216 */
1216 @Override 1217 @Override
1217 public boolean supportsSubqueriesInExists() { 1218 public boolean supportsSubqueriesInExists() {
1218 return true; 1219 return true;
1219 } 1220 }
1220 1221
1221 /** 1222 /**
1222 * Are subqueries in 'in' statements supported? A JDBC 1223 * Are subqueries in 'in' statements supported?
1223 * Compliant driver always returns true. 1224 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
1224 * 1225 *
1225 * @return true if so; false otherwise 1226 * @return true if so; false otherwise
1226 */ 1227 */
1227 @Override 1228 @Override
1228 public boolean supportsSubqueriesInIns() { 1229 public boolean supportsSubqueriesInIns() {
1229 return true; 1230 return true;
1230 } 1231 }
1231 1232
1232 /** 1233 /**
1233 * Are subqueries in quantified expressions supported? A JDBC 1234 * Are subqueries in quantified expressions supported?
1234 * Compliant driver always returns true. 1235 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
1235 * 1236 *
1236 * (No idea what this is, but we support a good deal of 1237 * (No idea what this is, but we support a good deal of
1237 * subquerying.) 1238 * subquerying.)
1238 * 1239 *
1239 * @return true if so; false otherwise 1240 * @return true if so; false otherwise
1242 public boolean supportsSubqueriesInQuantifieds() { 1243 public boolean supportsSubqueriesInQuantifieds() {
1243 return true; 1244 return true;
1244 } 1245 }
1245 1246
1246 /** 1247 /**
1247 * Are correlated subqueries supported? A JDBC Compliant driver 1248 * Are correlated subqueries supported?
1248 * always returns true. 1249 * A JDBC Compliant <sup><font size=-2>TM</font></sup> driver always returns true.
1249 * 1250 *
1250 * (a.k.a. subselect in from?) 1251 * (a.k.a. subselect in from?)
1251 * 1252 *
1252 * @return true if so; false otherwise 1253 * @return true if so; false otherwise
1253 */ 1254 */
1592 return true; 1593 return true;
1593 } 1594 }
1594 1595
1595 /** 1596 /**
1596 * Does the database support the given transaction isolation level? 1597 * Does the database support the given transaction isolation level?
1597 * We only support TRANSACTION_READ_COMMITTED as far as I know 1598 * We only support TRANSACTION_SERIALIZABLE as far as I know
1598 * 1599 *
1599 * @param level the values are defined in java.sql.Connection 1600 * @param level the values are defined in java.sql.Connection
1600 * @return true if so 1601 * @return true if so
1601 * @see Connection 1602 * @see Connection
1602 */ 1603 */