[teiid-designer-issues] [JBoss JIRA] Updated: (TEIIDDES-570) Valid names can have almost any character, except periods. No periods!
[
https://jira.jboss.org/browse/TEIIDDES-570?page=com.atlassian.jira.plugin...
]
Steve Hawkins updated TEIIDDES-570:
-----------------------------------
Assignee: (was: Steven Hawkins)
Unassigning from me and clarifying that the only restriction for an
schema/model/element/column name is that it cannot contain a '.', but a
table/procedure can have any name. If there are restrictions in the Designer related to
EMF or whatever, then we'll capture that on this issue.
Valid names can have almost any character, except periods. No
periods!
----------------------------------------------------------------------
Key: TEIIDDES-570
URL: https://jira.jboss.org/browse/TEIIDDES-570
Project: Teiid Designer
Issue Type: Bug
Components: Validation
Affects Versions: 7.1
Environment: All
Reporter: Paul Nittel
This SQL:
SELECT t.* FROM
(EXEC WeatherData.invoke(action = 'GET', endpoint =
QUERYSTRING('', '38.99,-77.02 39.70,-104.80 47.6,-122.30' AS listLatLon,
'time-series' AS product, '2004-01-01T00:00:00' AS "begin",
'2013-04-20T00:00:00' AS "end", 'maxt' AS maxt, 'mint'
AS mint))) AS w, XMLTABLE('/dwml/data/location' PASSING result COLUMNS
"location-key" string, lattitude string PATH 'point/@latitude',
longitude string PATH 'point/@longitude') AS t
will fail as location-key contains a hyphen. Actually, the only character which is not
valid in a name is the period. Please verify with the Teiid server crew, but we should
loosen up the validation criteria as appropriate.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira