[JBoss JIRA] (TEIID-5109) Set operations and parenthesis
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5109?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5109:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1504707|https://bugzilla.redhat.com/show_bug.cgi?id=1504707] from MODIFIED to ON_QA
> Set operations and parenthesis
> ------------------------------
>
> Key: TEIID-5109
> URL: https://issues.jboss.org/browse/TEIID-5109
> Project: Teiid
> Issue Type: Bug
> Components: Connector API, Query Engine
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 10.0, 8.12.x-6.4, 9.3.4, 9.2.7
>
>
> Using Teiid 9.2.2 with postgresql, I issue a query structured like this:
>
> (a
> UNION ALL
> b
> UNION ALL
> c)
> INTERSECT
> d
>
> All queries are from a single database.
> This query does not give back the expected result.
> In the plan, I see the query printed with no parenthesis around the unions:
> a UNION ALL b UNION ALL c INTERSECT d
> This gives the same result as the query submitted with no parens in it (the intersect of c and d is unioned with a union b.
> The expepeted result is to preserve the paren so that the intersect is performed against the union of all three tables.
> As a note, using UNION instead of UNION ALL did not preserve the parens, either.
>
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5127) Osisoft translator - MOD fails with non-integer arguments
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5127?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5127:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506587|https://bugzilla.redhat.com/show_bug.cgi?id=1506587] from MODIFIED to ON_QA
> Osisoft translator - MOD fails with non-integer arguments
> ---------------------------------------------------------
>
> Key: TEIID-5127
> URL: https://issues.jboss.org/browse/TEIID-5127
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Fix For: 8.12.x-6.4, 10.1
>
>
> Query such as
> {code:sql}
> SELECT FloatNum, 11, MOD(FloatNum, 11) FROM BQT1.SmallA
> {code}
> fails on the PI server with
> {noformat}
> com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 1:34] [%] Overload resolution failed for (Single, Single) argument(s).
> {noformat}
> Similarly for Double arguments. It appears that the modulo operator % is only defined when both arguments are integers (contrary to PI OLEDB Enterprise 2016 User Guide, which states that it is defined for all numeric data types)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5141) Osisoft translator - ANY and SOME expressions cause syntax errors on datasource
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5141?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5141:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1511490|https://bugzilla.redhat.com/show_bug.cgi?id=1511490] from MODIFIED to ON_QA
> Osisoft translator - ANY and SOME expressions cause syntax errors on datasource
> -------------------------------------------------------------------------------
>
> Key: TEIID-5141
> URL: https://issues.jboss.org/browse/TEIID-5141
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Fix For: 8.12.x-6.4
>
>
> Running a query such as
> {code:sql}
> SELECT INTKEY, STRINGKEY, FLOATNUM FROM BQT1.SMALLA WHERE FLOATNUM <> SOME (SELECT FLOATNUM FROM BQT1.SMALLA WHERE STRINGKEY = 10)
> {code}
> gets translated as
> {code:sql}
> SELECT g_0.IntKey, g_0.StringKey, g_0.FloatNum FROM dvqe..SmallA AS g_0 WHERE g_0.FloatNum <> SOME (SELECT g_1.FloatNum FROM dvqe..SmallA AS g_1 WHERE g_1.StringKey = '10')
> {code}
> and fails with
> {noformat}
> com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Parser] [Line 1:100] Missing ) at 'SELECT'
> [Line 1:171] Extraneous ')'
> {noformat}
> Same thing when the SOME keyword is replaced with ANY (as in, ANY is translated to the exact same query, with 'SOME', which is understandable, since they _should_ be equivalent).
> This appears to be a bug in Osisoft PI, since issuing the same query with ANY against the datasource (without teiid involvement) works, so I suggest translating SOME as ANY as a workaround.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5161) Push down rand() function
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5161.
-----------------------------------
Resolution: Done
Documented / prevented the pushdown of RAND with seed so that it only affects Teiid - as that seems like the only consistent behavior we can shoot for. Sources have different ranges for seed values, different random generation schemes, and even different behavior with respect to evaluation - see mysql.
Otherwise the pushdown of the rand with no arguments is now supported against the sources listed in this issue.
> Push down rand() function
> -------------------------
>
> Key: TEIID-5161
> URL: https://issues.jboss.org/browse/TEIID-5161
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1
>
>
> As per discussion within TEIID-5153 we should push down rand() function where ever it seems to be missing. But first of all the function should be pushed down for at least PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5178) doc formatting issues
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-5178:
-------------------------------------
Summary: doc formatting issues
Key: TEIID-5178
URL: https://issues.jboss.org/browse/TEIID-5178
Project: Teiid
Issue Type: Bug
Components: Documentation
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 10.1
The docs contain formatting issues with several example blocks and with \{ escapes - which are not universally honored.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5125) OData v4 doesn't work with Java 6
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5125?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5125:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1506512|https://bugzilla.redhat.com/show_bug.cgi?id=1506512] from MODIFIED to ON_QA
> OData v4 doesn't work with Java 6
> ---------------------------------
>
> Key: TEIID-5125
> URL: https://issues.jboss.org/browse/TEIID-5125
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 8.12.x-6.4
>
>
> In the version reported, user can't access odata4 api:
> {code}
> 17:32:01,553 ERROR [org.teiid.ODATA] (http-0.0.0.0:8080-1) TEIID16050 Unable to process odata request due to: java.lang.Integer.compare(II)I with cause java.lang.Integer.compare(II)I: org.apache.olingo.server.api.ODataApplicationException: java.lang.Integer.compare(II)I
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:173) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)
> at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)
> at org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)
> at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)
> at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67)
> at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.17.Final-redhat-4.jar:7.5.17.Final-redhat-4]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:656) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.24.Final-redhat-1.jar:7.5.24.Final-redhat-1]
> at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
> Caused by: java.lang.NoSuchMethodError: java.lang.Integer.compare(II)I
> at org.teiid.olingo.service.DocumentNode$1.compare(DocumentNode.java:389) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.olingo.service.DocumentNode$1.compare(DocumentNode.java:386) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.Arrays.mergeSort(Arrays.java:1270) [rt.jar:1.6.0_45]
> at java.util.Arrays.sort(Arrays.java:1210) [rt.jar:1.6.0_45]
> at java.util.Collections.sort(Collections.java:157) [rt.jar:1.6.0_45]
> at org.teiid.olingo.service.DocumentNode.sortColumns(DocumentNode.java:386) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.olingo.service.DocumentNode.buildQuery(DocumentNode.java:354) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.olingo.service.ODataSQLBuilder.selectQuery(ODataSQLBuilder.java:184) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:170) [teiid-olingo-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> ... 28 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months