You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Jess Balint (JIRA)" <ji...@apache.org> on 2017/01/26 22:01:24 UTC

[jira] [Created] (CALCITE-1607) RelToSqlConverter assertion error with projection over sort

Jess Balint created CALCITE-1607:
------------------------------------

             Summary: RelToSqlConverter assertion error with projection over sort
                 Key: CALCITE-1607
                 URL: https://issues.apache.org/jira/browse/CALCITE-1607
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.11.0
            Reporter: Jess Balint
            Assignee: Julian Hyde
            Priority: Minor


{{RelToSqlConverter}} has a problem creating aliases when wrapping a query, e.g.:
{code:java}
    relBuilder.scan("product");
    relBuilder.sort(1)
              .project(relBuilder.field(0), relBuilder.field(2), relBuilder.field(4))
{code}

This throws
{noformat}
Caused by: java.lang.AssertionError: field ordinal 1 out of range {t=RecordType(INTEGER product_class_id, VARCHAR(60) brand_name, BIGINT SKU)}
	at org.apache.calcite.rel.rel2sql.SqlImplementor$AliasContext.field(SqlImplementor.java:845)
	at org.apache.calcite.rel.rel2sql.SqlImplementor$Context.toSql(SqlImplementor.java:512)
	at org.apache.calcite.rel.rel2sql.RelToSqlConverter.visit(RelToSqlConverter.java:151)
{noformat}



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