Changeset: 7d041f5c3fea for monetdb-java
URL: https://dev.monetdb.org/hg/monetdb-java?cmd=changeset;node=7d041f5c3fea
Modified Files:
ChangeLog
src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
Branch: default
Log Message:
In getTimeDateFunctions() also return newly added SQL function: date_trunc
diffs (24 lines):
diff --git a/ChangeLog b/ChangeLog
--- a/ChangeLog
+++ b/ChangeLog
@@ -16,7 +16,7 @@
- Improved MonetDatabaseMetaData methods:
- getNumericFunctions(): it no longer lists aggregate functions: avg, prod
and sum
- getSystemFunctions(): it no longer lists timedate function: extract
- - getTimeDateFunctions(): it now also lists function: epoch
+ - getTimeDateFunctions(): it now also lists functions: date_trunc, epoch
- Corrected MonetDatabaseMetaData method getTypeInfo() for result column
SEARCHABLE. It now returns DatabaseMetaData.typeSearchable for all
string data types including 'inet','json','url','uuid' and 'blob'.
diff --git a/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
b/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
--- a/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
+++ b/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
@@ -532,7 +532,7 @@ public class MonetDatabaseMetaData exten
@Override
public String getTimeDateFunctions() {
String wherePart =
- "\"mod\" IN ('mtime','timestamp') OR \"name\" IN
('localtime','localtimestamp')";
+ "\"mod\" IN ('mtime','timestamp') OR \"name\" IN
('localtime','localtimestamp','date_trunc')";
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'" +
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
