[jira] [Closed] (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:all-tabpanel ]

Julian Hyde closed CALCITE-1373.
--------------------------------

> 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
>            Priority: Major
>             Fix For: 1.19.0
>
>
> When I play with calcite 1.8.0's csv sample DB, the following simple query will fail:
> {code}
> select JOINEDAT from EMPS
> {code}
> the error message is:
> {noformat}
> 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)
> {noformat}
> can you please confirm whether it is a known issue or not?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)