Re: CastException in JDBC Adapter

I have added a runnable test case in the issue's description. The expected query could be a little bit different but this is runnable in Postgresql. Check it, please: https://issues.apache.org/jira/browse/CALCITE-1382. Thanks. Best regards, Miguel. 2016-09-22 19:27 GMT+01:00 Julian Hyde

Re: CastException in JDBC Adapter

Thanks. Please provide a runnable test case, otherwise it’s unlikely we’ll be able to make progress. > On Sep 22, 2016, at 11:19 AM, Miguel Oliveira > wrote: > > I have logged https://issues.apache.org/jira/browse/CALCITE-1382 for this > issue. > > Tomorrow i

Re: CastException in JDBC Adapter

I have logged https://issues.apache.org/jira/browse/CALCITE-1382 for this issue. Tomorrow i will try to find a better query. Best regards, Miguel. 2016-09-22 18:55 GMT+01:00 Julian Hyde : > Yes, sure. Please create a runnable test case if you can. It sounds a bit > improbable

[jira] [Created] (CALCITE-1382) CastException in JDBC Adapter

Miguel Oliveira created CALCITE-1382: Summary: CastException in JDBC Adapter Key: CALCITE-1382 URL: https://issues.apache.org/jira/browse/CALCITE-1382 Project: Calcite Issue Type: Bug

CastException in JDBC Adapter

Hi, I'm using the Jdbc Adapter and the SCOTT schema (emp, dept and salgrade). When i execute the following query (i know that the second join doesn't make sense, but it's only to show the error): > SELECT count(*) FROM (SELECT count(emp.empno) `Count Emp`, dept.dname > `Department Name` FROM