You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2018/02/14 05:49:00 UTC
[jira] [Updated] (CALCITE-2099) Code generated for GROUP BY inside
UNION does not compile
[ https://issues.apache.org/jira/browse/CALCITE-2099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-2099:
---------------------------------
Summary: Code generated for GROUP BY inside UNION does not compile (was: generated code compile error when sql has union and aggregation)
> Code generated for GROUP BY inside UNION does not compile
> ---------------------------------------------------------
>
> Key: CALCITE-2099
> URL: https://issues.apache.org/jira/browse/CALCITE-2099
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: jiatao.tao
> Assignee: Julian Hyde
> Priority: Major
>
> Hi, [~julianhyde], add these tests in CsvTest
> {code:java}
> // fail
> @Test
> public void test0() throws SQLException {
> sql("model", "select count(*) from EMPS group by NAME union select count(*) from EMPS group by NAME").ok();
> }
> // fail
> @Test
> public void test1() throws SQLException {
> sql("model", "select sum(AGE) from EMPS group by NAME union select sum(AGE) from EMPS group by NAME").ok();
> }
> // this is ok
> @Test
> public void test2() throws SQLException {
> sql("model", "select count(*), NAME from EMPS group by NAME union select count(*), NAME from EMPS group by NAME").ok();
> }
> {code}
> and will throw exception:Caused by: org.codehaus.commons.compiler.CompileException: Line 202, Column 17: No applicable constructor/method found for actual parameters "java.lang.String, java.lang.Integer"; candidates are: "Baz$Record2_1()"
> Hoping for your reply.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)