[
https://jira.jboss.org/jira/browse/TEIID-873?page=com.atlassian.jira.plug...
]
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