[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