[teiid-issues] [JBoss JIRA] (TEIID-3979) Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
Steven Hawkins (JIRA)
issues at jboss.org
Tue Feb 16 17:53:00 EST 2016
[ https://issues.jboss.org/browse/TEIID-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-3979:
----------------------------------
Component/s: JDBC Connector
Fix Version/s: 9.0
8.12.5
8.13.2
Affects Version/s: 8.7
(was: 8.13.1)
> Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
> ---------------------------------------------------------------------------------------
>
> Key: TEIID-3979
> URL: https://issues.jboss.org/browse/TEIID-3979
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.7
> Reporter: Gabriel Steinberg
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> When running the following query through Teiid against an HSQL database:
> SELECT CAST(N_NATIONKEY AS VARCHAR(100)) FROM NATION
> Teiid drops the length from the query, sending to HSQL the query
> SELECT CAST(N_NATIONKEY AS VARCHAR) FROM NATION
> which causes an HSQL syntax error. HSQL doesn't support VARCHAR without length.
> Note: this query was generated by Tableau, and there's no easy way to change it to use the LFT function, as suggested by Steven in https://developer.jboss.org/thread/267816
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list