[teiid-issues] [JBoss JIRA] (TEIID-3346) File Source | Dot in file column names causes VDB deployment errors

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13049147#comment-13049147 ] 

Steven Hawkins commented on TEIID-3346:
---------------------------------------

Supporting column and table aliases with . is a sizable amount of work.  We would need to remove the notion of output names, change the parsing logic dealing with name validation and parsing.  Change the resolving logic to not break names up based upon the last index of . and change the sql string logic to preserve quoting.

So for this issue I'll instead introduce another attribute for the text column which will be the header name value.

> 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)