[JBoss JIRA] (TEIID-4184) Timestamps need to be submitted without supporting {ts} for OSI PI translator
by Al S (JIRA)
Al S created TEIID-4184:
---------------------------
Summary: Timestamps need to be submitted without supporting {ts} for OSI PI translator
Key: TEIID-4184
URL: https://issues.jboss.org/browse/TEIID-4184
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.13.3
Reporter: Al S
Assignee: Steven Hawkins
Priority: Minor
Queries with OSI PI translator insert a {ts} when passing timestamps but the PI SQL engine does not handle this well.
Example model query:
select "tag","time","value" from "schema-name"."picomp2"
Example query against Teiid schema:
select * from IceDataThree where tag='sinusoid' and timecol>'2016-01-01 00:00:00'
Translation:
SELECT TOP 1000 g_0."tag" AS c_0, g_0."time" AS c_1, g_0."value" AS c_2 FROM "piarchive"."picomp2" AS g_0
02.WHERE g_0."tag" = 'sinusoid' AND g_0."time" > {ts '2016-04-20 00:00:00.0'}
Error:
20:02:57,250 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue21) sV28Up1
02.GiGOM Connector worker process failed for atomic-request=sV28Up1GiGOM.2.0.3: org
03..teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error exe
04.cuting statement(s): [SQL: SELECT TOP 1000 g_0."tag" AS c_0, g_0."time" AS c_1,
05.g_0."value" AS c_2 FROM "piarchive"."picomp2" AS g_0 WHERE g_0."tag" = 'sinusoid
06.' AND g_0."time" > {ts '2016-04-20 00:00:00.0'}]
Caused by: com.osisoft.rdsa.RdsaException: [PIOLEDB] [SQL Parser] [Line 1] Synta
48.x error near 'ts'.
If the translation were to simply remove the "ts" part the query would work:
SELECT TOP 1000 g_0."tag" AS c_0, g_0."time" AS c_1, g_0."value" AS c_2 FROM "piarchive"."picomp2" AS g_0
WHERE g_0."tag" = 'sinusoid' AND g_0."time" > '2016-04-20 00:00:00.0'
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
- 1
- 0
[JBoss JIRA] (TEIID-4107) HSQL Syntax error when Teiid sends it a join query with no parenthesis
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4107?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4107:
----------------------------------
Fix Version/s: 9.0
(was: 9.0.0)
> HSQL Syntax error when Teiid sends it a join query with no parenthesis
> ----------------------------------------------------------------------
>
> Key: TEIID-4107
> URL: https://issues.jboss.org/browse/TEIID-4107
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.0
> Reporter: Gabriel Steinberg
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> The query
> SELECT R_NAME FROM region LEFT OUTER JOIN (customer INNER JOIN nation ON C_NATIONKEY = N_NATIONKEY) ON R_REGIONKEY = N_REGIONKEY
> When run against an HSQL DB causes a syntax error because the query passed to HSQL contains no parenthesis, and HSQL cannot handle it, as described in https://developer.jboss.org/message/953580?et=watches.email.thread#953580.
> As Steve points out there, this was solved for H2 in https://issues.jboss.org/browse/TEIID-3549. H2 and HSQL come from the same project, they split at some point in time, and I suspect they still share a lot of code.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
- 1
- 0