Changeset: d226b7c9048e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d226b7c9048e
Modified Files:
java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
Branch: Jun2016
Log Message:
Improve the CREATE_PARAMS info for certain sql types.
diffs (15 lines):
diff --git a/java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
b/java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
--- a/java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
+++ b/java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
@@ -2785,8 +2785,9 @@ public class MonetDatabaseMetaData exten
" ELSE NULL END AS varchar(2)) AS \"LITERAL_PREFIX\", "
+
"cast(CASE WHEN \"systemname\" IN ('str', 'inet',
'json', 'url', 'uuid') THEN ''''" +
" ELSE NULL END AS varchar(2)) AS \"LITERAL_SUFFIX\", "
+
- "CASE WHEN \"sqlname\" IN ('char', 'varchar', 'binary',
'varbinary') THEN 'max length'" +
- " WHEN \"sqlname\" IN ('decimal', 'sec_interval',
'timestamp', 'timestamptz') THEN 'precision'" +
+ "CASE WHEN \"sqlname\" IN ('char', 'varchar') THEN 'max
length'" +
+ " WHEN \"sqlname\" = 'decimal' THEN 'precision, scale'"
+
+ " WHEN \"sqlname\" IN ('time', 'timetz', 'timestamp',
'timestamptz', 'sec_interval') THEN 'precision'" +
" ELSE NULL END AS \"CREATE_PARAMS\", " +
"cast(CASE WHEN \"systemname\" = 'oid' THEN
").append(DatabaseMetaData.typeNoNulls)
.append(" ELSE
").append(DatabaseMetaData.typeNullable).append(" END AS smallint) AS
\"NULLABLE\", " +
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
