Changeset: 46017dd6a126 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=46017dd6a126
Modified Files:
java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
Branch: default
Log Message:
Correct the return value of supportsExpressionsInOrderBy().
MonetDB does support expressions in order by clause.
Tested for instance with query: select (radix * 1000) + digits as comp, * from
types order by (radix * 1000) + digits, -id;
diffs (31 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
@@ -10,7 +10,6 @@ package nl.cwi.monetdb.jdbc;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
-import java.sql.Driver;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
@@ -655,16 +654,16 @@ public class MonetDatabaseMetaData exten
/**
* Are expressions in "ORDER BY" lists supported?
- *
* e.g. select * from t order by a + b;
*
- * MonetDB does not support this (yet?)
+ * 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 false;
+ return true;
}
/**
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
