[jira] [Commented] (CALCITE-1373) select date column will fail in 1.8.0

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15486576#comment-15486576 ] 

Julian Hyde commented on CALCITE-1373:
--------------------------------------

It works for me:

{noformat}
diff --git a/example/csv/src/test/java/org/apache/calcite/test/CsvTest.java b/example/csv/src/test/java/org/apache/calcite/test/CsvTest.java
index 62af53f..d5ca849 100644
--- a/example/csv/src/test/java/org/apache/calcite/test/CsvTest.java
+++ b/example/csv/src/test/java/org/apache/calcite/test/CsvTest.java
@@ -178,6 +178,10 @@ private static StringBuilder escapeString(StringBuilder buf, String s) {
     checkSql("smart", "select name from EMPS");
   }
 
+  @Test public void testSelectDate() throws SQLException {
+    checkSql("smart", "select JOINEDAT from EMPS");
+  }
+
   @Test public void testSelectSingleProject() throws SQLException {
     checkSql("smart", "select name from DEPTS");
   }
{noformat}


> select date column will fail in 1.8.0
> -------------------------------------
>
>                 Key: CALCITE-1373
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1373
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: hongbin ma
>            Assignee: Julian Hyde
>
> Hi experts
> When I play with calcite 1.8.0's csv sample DB, the following simple query will fail:
> "select JOINEDAT from EMPS"
> the error message is:
> Error: Error while executing SQL "select JOINEDAT from EMPS": Error while compiling generated Java code:
> org.apache.calcite.DataContext root;
> public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root0) {
>   root = root0;
>   final org.apache.calcite.rel.RelNode v0stashed = (org.apache.calcite.rel.RelNode) root.get("v0stashed");
>   final org.apache.calcite.interpreter.Interpreter _inputEnumerable = new org.apache.calcite.interpreter.Interpreter(
>     root,
>     v0stashed);
>   return new org.apache.calcite.linq4j.AbstractEnumerable(){
>       public org.apache.calcite.linq4j.Enumerator enumerator() {
>         return new org.apache.calcite.linq4j.Enumerator(){
>             public final org.apache.calcite.linq4j.Enumerator inputEnumerator = _inputEnumerable.enumerator();
>             public void reset() {
>               inputEnumerator.reset();
>             }
>             public boolean moveNext() {
>               return inputEnumerator.moveNext();
>             }
>             public void close() {
>               inputEnumerator.close();
>             }
>             public Object current() {
>               return org.apache.calcite.runtime.SqlFunctions.internalToDate(((Object[]) inputEnumerator.current())[9]);
>             }
>           };
>       }
>     };
> }
> public Class getElementType() {
>   return java.sql.Date.class;
> } (state=,code=0)
> can you please confirm whether it is a known issue or not?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)