[
https://issues.jboss.org/browse/TEIID-3346?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3346:
---------------------------------------
Model name, or any nameinsource string, I met this error several
time.
Actually it should be fine in a name in source. It's expected though that any
necessary quoting will already be present on the name in source.
We may document that column name can not contain a Dot to solve this
issue.
We do cover that on
https://docs.jboss.org/author/display/TEIID/Identifiers
The issue here is more the interaction with text table in that we expect the source text
header name to match the column name. It would be quite hard to address this issue in
general, but we could add logic specific to TEXTTABLE - either another way to specify the
header name or that if the column name contains a '.' that the projected column
name will simply use a replacement character.
File Source | Dot in file column names causes VDB deployment errors
-------------------------------------------------------------------
Key: TEIID-3346
URL:
https://issues.jboss.org/browse/TEIID-3346
Project: Teiid
Issue Type: Bug
Reporter: Shiveeta Mattoo
Assignee: Steven Hawkins
In case a Delimited Flat file , contains a "Dot" character in any of the column
names, we get an issue during Virtual Data Base deployment -
Root cause -
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered
"'UTF-8') COLUMNS [*]\"name.full\"[*] STRING," at line 1,
column 126.
Invalid simple identifier format: [name.full]
The query is : SELECT A."name.full",A."surname" FROM (EXEC
tabwithdot.getFiles('tab.csv')) AS F, TEXTTABLE(TO_CHARS(F.file,'UTF-8')
COLUMNS "name.full" STRING,"surname" STRING delimiter ' '
quote ' ' HEADER) AS A
Please note, that although the column name [name.full], is enclosed in Double Quotes,
still this issue is observed.
If there was instead any other special character, that works successfully.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)