[JBoss JIRA] Created: (TEIIDDES-570) Valid names can have almost any character, except periods. No periods!
12:48 p.m.
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
7:06 a.m.
New subject: [JBoss JIRA] Assigned: (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...
]
Barry LaFond reassigned TEIIDDES-570:
-------------------------------------
Assignee: Barry LaFond
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
Assignee: Barry LaFond
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
7:08 a.m.
New subject: [JBoss JIRA] Assigned: (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...
]
Barry LaFond reassigned TEIIDDES-570:
-------------------------------------
Assignee: Steven Hawkins (was: Barry LaFond)
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
Assignee: Steven Hawkins
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
9:44 a.m.
New subject: [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
11:58 a.m.
New subject: [JBoss JIRA] Commented: (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...
]
Barry LaFond commented on TEIIDDES-570:
---------------------------------------
RelationalStringNameValidator or StringNameValidator.validate() uses a simple
StringNameValidator.validateStringNameChars() method which uses a simple
StringNameValidator which only allows:
1) // The first character must be an alphabetic character ...
2) // The remaining characters must be either alphabetic, digit or underscore character
...
This is a generic class that we use EVERYWHERE within Designer.
I think we need to be careful what we change here and maybe extend
RelationalStringNameValidator a little more to override the specific validate/check-char
methods.
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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:06 p.m.
New subject: [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...
]
Barry LaFond updated TEIIDDES-570:
----------------------------------
Fix Version/s: 7.2
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
Fix For: 7.2
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
8:24 a.m.
New subject: [JBoss JIRA] Updated: (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 updated TEIIDDES-570:
----------------------------------
Fix Version/s: 7.3
(was: 7.2)
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
Fix For: 7.3
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
3:01 p.m.
New subject: [JBoss JIRA] Assigned: (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 reassigned TEIIDDES-570:
-------------------------------------
Assignee: Barry LaFond
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
11:56 a.m.
New subject: [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
3:28 p.m.
New subject: [JBoss JIRA] Resolved: (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 resolved TEIIDDES-570.
-----------------------------------
Resolution: Done
With the help from Steve H., consolidated and cleaned up Designer's
StringNameValidator and related classes so they use correct "unlimited"
characters (except for '.') for any Model "child" name validation,
unless the new Validation preference to "Restrict for SQL" is turned on, then we
limit names to letter or digit or _.
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
4862
days inactive
5051
days old
teiid-designer-issues@lists.jboss.org
9 comments
3 participants
participants (3)
-
Barry LaFond (JIRA) -
Paul Nittel (JIRA)
-
Steve Hawkins (JIRA)