[teiid-issues] [JBoss JIRA] (TEIID-3979) Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
Gabriel Steinberg (JIRA)
issues at jboss.org
Tue Feb 16 15:57:00 EST 2016
Gabriel Steinberg created TEIID-3979:
----------------------------------------
Summary: 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
Affects Versions: 8.13.1
Reporter: Gabriel Steinberg
Assignee: Steven Hawkins
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