[teiid-issues] [JBoss JIRA] Resolved: (TEIID-873) Add support for quoted identifier aliases

Steven Hawkins (JIRA) jira-events at lists.jboss.org
Fri Nov 20 12:47:29 EST 2009


     [ https://jira.jboss.org/jira/browse/TEIID-873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-873.
----------------------------------

    Resolution: Done


Changed the parsing rules for identifiers to allow double quoting to escape arbitrary identifiers - including aliases.  The use of . is still restricted and cannot be used anywhere we expect a "short name".  

e.g. select x as "my x" from "foo.bar" is valid
however select x as "my.x" from "foo.bar" is not, since we expect the alias to be a short name and not contain a '.'

As before no real special meaning is given to the grouping of double quotes, all that matters is the location of '.' -- "foo.bar!" is the same as foo."bar!".  We may change this in the future if we want to strictly conform to a catalog/schema/table/column naming convention and allow '.' to be part of names.

> Add support for quoted identifier aliases
> -----------------------------------------
>
>                 Key: TEIID-873
>                 URL: https://jira.jboss.org/jira/browse/TEIID-873
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 7.0
>
>
> The sql spec allows for creating quoted identifier aliases (containing spaces, the period delimiter, etc.).  We should support this style of alias for maximum portability.
> The issue with allowing this is that the internals of revolving and metadata do not account for the delimiter character in a table or column name.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


More information about the teiid-issues mailing list