[teiid-issues] [JBoss JIRA] (TEIID-3148) Teiid exception with vdb from flat file containing utf8 non-ascii character

[Jan Stastny (JIRA)]

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

Jan Stastny commented on TEIID-3148:
------------------------------------

In my model I use this query:

SELECT * FROM
		(EXEC TextTeiid.getTextFiles('EmpData.txt')) AS f, TEXTTABLE(f.file COLUMNS lastName string, firstName string, middleName string, empId biginteger, department string, annualSalary double, title string, homePhone string, mgrId biginteger, street string, city string, state string, ZipCode string HEADER 3) AS emp

> Teiid exception with vdb from flat file containing utf8 non-ascii character
> ---------------------------------------------------------------------------
>
>                 Key: TEIID-3148
>                 URL: https://issues.jboss.org/browse/TEIID-3148
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1
>         Environment: Windows OS
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>
> This issue is Windows OS specific. When trying to parse text csv file in utf8 which contains non-ascii characters an exception occurs. When the non-ascii characters are removed, everything passes well. On RHEL or Solaris this issue doesn't occur.
> TEIID30020 Processing exception for request rgzZ3dn9tVMX.0 'TEIID30179 Text parse error: Could not read data in file:/w:/workspace/JDV6_1_BQT-jstastny/jdk/java17_default/label/Win2k8_x86/eap/standalone/deployments/TextEmployeeTest-files/EmpData.txt'. Originally TeiidProcessingException 'Input length = 1' CoderResult.java:278.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)