[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-570) Valid names can have almost any character, except periods. No periods!
[
https://issues.jboss.org/browse/TEIIDDES-570?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-570:
---------------------------------------
After much help from Steve H.....
Default StringNameValidator assumes:
1) First character has to be a Letter
2) All other chars can be a letter, digit OR an underscore '_'
For RelationalStringNameValidator there is a new Validation preference labeled:
"Restrict name characters to valid unquoted SQL identifiers:" (basically letter,
digit & '_')
Table names have an additional check of "."
If this Validation is OFF or IGNORE, then pretty much any character is valid for a
relational entity name.
For Model Projects and Resource names (models and vdbs) we'll use the Default (letter,
digit & '_') but add the hyphen ('-')
Also to make Preview Data action work, I've changed the SQL generation to double-quote
all name segments (i.e. "PartsOracle"."PARTS")
Valid names can have almost any character, except periods. No
periods!
----------------------------------------------------------------------
Key: TEIIDDES-570
URL: https://issues.jboss.org/browse/TEIIDDES-570
Project: Teiid Designer
Issue Type: Bug
Components: Validation
Affects Versions: 7.1
Environment: All
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.4
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira