Mercurial > hg > monetdb-java

comparison src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 168:70630bc76ac6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Correct returned value for column SOURCE_DATA_TYPE of method getColumns(). It should return null if DATA_TYPE isn't DISTINCT or user-generated REF as defined in spec: http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 14 Sep 2017 15:15:54 +0200 (2017-09-14)
parents 8b40a845240c
children 60063c67f9e7 4959b85b981c
comparison
equal deleted inserted replaced
167:89e954e7acbb 168:70630bc76ac6
2217 "cast(\"columns\".\"number\" + 1 as int) AS \"ORDINAL_POSITION\", " + 2217 "cast(\"columns\".\"number\" + 1 as int) AS \"ORDINAL_POSITION\", " +
2218 "cast(CASE \"null\" WHEN true THEN 'YES' WHEN false THEN 'NO' ELSE '' END AS varchar(3)) AS \"IS_NULLABLE\", " + 2218 "cast(CASE \"null\" WHEN true THEN 'YES' WHEN false THEN 'NO' ELSE '' END AS varchar(3)) AS \"IS_NULLABLE\", " +
2219 "cast(null AS varchar(1)) AS \"SCOPE_CATALOG\", " + 2219 "cast(null AS varchar(1)) AS \"SCOPE_CATALOG\", " +
2220 "cast(null AS varchar(1)) AS \"SCOPE_SCHEMA\", " + 2220 "cast(null AS varchar(1)) AS \"SCOPE_SCHEMA\", " +
2221 "cast(null AS varchar(1)) AS \"SCOPE_TABLE\", " + 2221 "cast(null AS varchar(1)) AS \"SCOPE_TABLE\", " +
2222 "cast(").append(MonetDriver.getJavaType("other")).append(" AS smallint) AS \"SOURCE_DATA_TYPE\", " + 2222 "cast(null AS smallint) AS \"SOURCE_DATA_TYPE\", " +
2223 "cast(CASE WHEN \"columns\".\"default\" IS NOT NULL AND \"columns\".\"default\" LIKE 'next value for %' THEN 'YES' ELSE 'NO' END AS varchar(3)) AS \"IS_AUTOINCREMENT\", " + 2223 "cast(CASE WHEN \"columns\".\"default\" IS NOT NULL AND \"columns\".\"default\" LIKE 'next value for %' THEN 'YES' ELSE 'NO' END AS varchar(3)) AS \"IS_AUTOINCREMENT\", " +
2224 "cast('NO' AS varchar(3)) AS \"IS_GENERATEDCOLUMN\" " + 2224 "cast('NO' AS varchar(3)) AS \"IS_GENERATEDCOLUMN\" " +
2225 "FROM \"sys\".\"columns\", " + 2225 "FROM \"sys\".\"columns\", " +
2226 "\"sys\".\"tables\", " + 2226 "\"sys\".\"tables\", " +
2227 "\"sys\".\"schemas\" " + 2227 "\"sys\".\"schemas\" " +