Bug 1506285 - Osisoft translator - Syntax error on datasource for queries with LOCATE
Summary: Osisoft translator - Syntax error on datasource for queries with LOCATE
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: CR2
: 6.4.0
Assignee: Van Halbert
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-10-25 15:10 UTC by Andrej Smigala
Modified: 2018-02-13 17:34 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Running a query with a locate function causes a syntax error on the Osisoft PI server. As a result, you will encounter an exception.
Clone Of:
Environment:
Last Closed: 2018-02-13 17:34:26 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-5124 0 Major Resolved Osisoft translator - Syntax error on datasource for queries with LOCATE 2018-02-01 00:18:34 UTC

Description Andrej Smigala 2017-10-25 15:10:54 UTC 
Running a query with LOCATE function causes a syntax error on the PI server:

> SELECT INTKEY FROM BQT1.SmallA WHERE LOCATE(2, INTKEY, 1) = 1

is pushed as

> SELECT g_0.IntKey AS c_0 FROM dvqe..SmallA AS g_0 WHERE cast(g_0.IntKey AS String)'2'1 = 1
.

Furthermore, query such as

> SELECT INTKEY, LOCATE(1, STRINGNUM) FROM BQT1.SmallA

fails on teiid (before push down) with IndexOutOfBoundsException.

See JIRA for details
Note You need to log in before you can comment on or make changes to this bug.