[
https://issues.apache.org/jira/browse/CALCITE-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16630295#comment-16630295
]
Volodymyr Vysotskyi commented on CALCITE-2507:
----------------------------------------------
This PR does not handle a case when column name is fully specified (including
schema and table names) with several levels of schema nesting.
Calcite allows such queries, for example, the next test put into
{{SqlValidatorTest.java}} passes
{code:java}
@Test
public void testFullyQualified() {
sql("select catalog.sales.nest.emp_r.* from catalog.sales.nest.emp_r")
.ok();
}
{code}
> Aliasing a star in select list should throw a parsing error.
> -------------------------------------------------------------
>
> Key: CALCITE-2507
> URL: https://issues.apache.org/jira/browse/CALCITE-2507
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.17.0
> Reporter: Hanumath Rao Maduri
> Assignee: Julian Hyde
> Priority: Minor
> Fix For: 1.18.0
>
>
> Currently aliasing a Star column is not throwing an exception in parser.
> There is a TODO for a simple test case (in SqlParserTest.java) to throw an
> error in parser phase itself.
> Change the parser grammar so as to report an error in parsing phase itself.
> {code:java}
> // TODO: should fail in parser
> @Test public void testStarAsFails() {
> sql("select * as x from emp")
> .ok("SELECT * AS `X`\n"
> + "FROM `EMP`");
> }
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
