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 2015/09/30 02:21:04 UTC

[jira] [Updated] (CALCITE-546) Allow table, column and field called "*"

     [ https://issues.apache.org/jira/browse/CALCITE-546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde updated CALCITE-546:
--------------------------------
    Description: 
Currently if we see an asterisk in an identifier, we translate it to an identifier name segment called "\*". If there happens to be a table, column or field called "*" we're sunk.

Star can only validly occur in the SELECT clause (not in FROM or WHERE). Examples: {{select emp.\* from emp}}, {{select x from sales.\*}}, {{select 1 from emp where emp.\* is not null}}.

This task is to test with tables, columns, fields called "*", and use a special value in SqlIdentifier. Maybe the empty string would work. Names cannot be empty.

  was:
Currently if we see an asterisk in an identifier, we translate it to an identifier name segment called "*". If there happens to be a table, column or field called "*" we're sunk.

Star can only validly occur in the SELECT clause (not in FROM or WHERE). Examples: {{select emp.* from emp}}, {{select x from sales.*}}, {{select 1 from emp where emp.* is not null}}.

This task is to test with tables, columns, fields called "*", and use a special value in SqlIdentifier. Maybe the empty string would work. Names cannot be empty.


> Allow table, column and field called "*"
> ----------------------------------------
>
>                 Key: CALCITE-546
>                 URL: https://issues.apache.org/jira/browse/CALCITE-546
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>
> Currently if we see an asterisk in an identifier, we translate it to an identifier name segment called "\*". If there happens to be a table, column or field called "*" we're sunk.
> Star can only validly occur in the SELECT clause (not in FROM or WHERE). Examples: {{select emp.\* from emp}}, {{select x from sales.\*}}, {{select 1 from emp where emp.\* is not null}}.
> This task is to test with tables, columns, fields called "*", and use a special value in SqlIdentifier. Maybe the empty string would work. Names cannot be empty.



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