[teiid-issues] [JBoss JIRA] (TEIID-2691) Grouping expression with view fails when grouping columns have the same name

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-2691:
-------------------------------------

             Summary: Grouping expression with view fails when grouping columns have the same name
                 Key: TEIID-2691
                 URL: https://issues.jboss.org/browse/TEIID-2691
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.5
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.6


If a source supports views, but not grouping expression, and grouping/select columns have the same short name, then the view creation logic will fail with:

ERROR [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue6859) caU8stCGl+8r TEIID30019 Unexpected exception for request caU8stCGl+8r.0: java.lang.AssertionError: Cannot create AliasSymbol wrapping AliasSymbol

  at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.symbol.AliasSymbol.setSymbol(AliasSymbol.java:76) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:159) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.preVisitVisitor(PreOrPostOrderNavigator.java:54) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:77) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:297) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.lang.OrderByItem.acceptVisitor(OrderByItem.java:87) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:291) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.lang.OrderBy.acceptVisitor(OrderBy.java:136) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.doVisit(PreOrPostOrderNavigator.java:669) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.sql.visitor.ExpressionMappingVisitor.mapExpressions(ExpressionMappingVisitor.java:394) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.rewriteGroupByAsView(RuleCollapseSource.java:741) [teiid-engine-8.5.0.Final.jar:8.5.0.Final]

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira