[teiid-issues] [JBoss JIRA] (TEIID-3346) File Source | Dot in file column names causes VDB deployment errors
Steven Hawkins (JIRA)
issues at jboss.org
Wed Mar 4 09:22:49 EST 2015
[ https://issues.jboss.org/browse/TEIID-3346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-3346:
----------------------------------
Fix Version/s: 8.11
Affects Version/s: 7.7
Component/s: Query Engine
> 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
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Shiveeta Mattoo
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> 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)
More information about the teiid-issues
mailing list