[
https://issues.jboss.org/browse/TEIIDDES-1993?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1993:
----------------------------------------
Validation rules will check for
Double-quoted name (can contain '.' character, but only other current valid
characters (i.e. number, _, etc..)
VALID NAME = "dbo.SUPPLIER"
INVALID NAME = dbo.Supplier
Resulting validation error message will state: *The name (Table.Name) contains the
'.' delimiter. This name is required to be wrapped in double-quotes.*
If the name contains an invalid character, it will still show a "info" message
like:
*The character '(' (at position 3) is not allowed; only alphabetic ([a-z]|[A-Z]),
digit ([0-9])) or '_' are allowed*
Issues with allowing '.' character in object name without
d-quoting the name
----------------------------------------------------------------------------
Key: TEIIDDES-1993
URL:
https://issues.jboss.org/browse/TEIIDDES-1993
Project: Teiid Designer
Issue Type: Bug
Components: Modeling, Validation
Affects Versions: 8.3
Reporter: Barry LaFond
Priority: Critical
Fix For: 8.3.x
Designer allows object names to contain "." character but does not force
wrapping the name in double quotes.
The JDBC importer, for instance, allows creating with fully qualified names like:
PARTSSUPPLIER.SUPPLIER for a table name.
The VDB Permission "resource-name" string value assumes that this name would be
wrapped in d-quotes to prevent wrong interpretation of path.
* Need to auto-wrap name in JDBC Importer processor
* Create a validation rule (ERROR) to check for non-double-quoted names
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira