[JBoss JIRA] (TEIID-5194) Osisoft translator - MAX and MIN on boolean column cause an error
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5194?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5194:
------------------------------------------------
Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1530289|https://bugzilla.redhat.com/show_bug.cgi?id=1530289] from ON_QA to VERIFIED
> Osisoft translator - MAX and MIN on boolean column cause an error
> -----------------------------------------------------------------
>
> Key: TEIID-5194
> URL: https://issues.jboss.org/browse/TEIID-5194
> 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
>
>
> Running a query such as
> {code:sql}
> SELECT MAX(BooleanValue) FROM BQT1.SmallA
> {code}
> fails with the following exception:
> {noformat}
> java.lang.ClassCastException: java.lang.Byte cannot be cast to java.lang.Boolean
> at com.osisoft.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:407)
> at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBoolean(WrappedResultSet.java:594)
> ... 22 more
> {noformat}
> Same issue occurs when using MIN.
> Running an equivalent query directly against the Osisoft PI datasource returns the correct result, with the return type being int8 (i.e. byte)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5227) Error when inserting a NULL value into a PostgreSQL Geometry datatype column
by Madou Coulibaly (JIRA)
Madou Coulibaly created TEIID-5227:
--------------------------------------
Summary: Error when inserting a NULL value into a PostgreSQL Geometry datatype column
Key: TEIID-5227
URL: https://issues.jboss.org/browse/TEIID-5227
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.12.12.6_3
Reporter: Madou Coulibaly
Assignee: Steven Hawkins
Inserting a Null value into a PostgreSQL Geometry datatype column using Teiid raises an error:
Caused by: org.postgresql.util.PSQLException: ERROR: column "geom" is of type geometry but expression is of type oid
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5226) Error when inserting a Geometry value into PostgreSQL
by Madou Coulibaly (JIRA)
Madou Coulibaly created TEIID-5226:
--------------------------------------
Summary: Error when inserting a Geometry value into PostgreSQL
Key: TEIID-5226
URL: https://issues.jboss.org/browse/TEIID-5226
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 8.12.12.6_3
Reporter: Madou Coulibaly
Assignee: Steven Hawkins
Attachments: server.log
Inserting a Geometry value into a PostgreSQL database using Teiid raises an error:
ERROR: Geometry SRID (0) does not match column SRID (28992)
Seems we do not take in account the SRID value during this operation.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5225) Building embedded applications without JBoss Third Party repository is not possible
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5225?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5225:
---------------------------------------
Will you have a pull request, or is there something that you want me to take a look at ahead of time?
> Building embedded applications without JBoss Third Party repository is not possible
> -----------------------------------------------------------------------------------
>
> Key: TEIID-5225
> URL: https://issues.jboss.org/browse/TEIID-5225
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.1
>
>
> Building any Teiid applications like
> - Embedded Teiid based applications
> - WildFly Swarm based applications
> - Spring Boot based applications
> is not possible just using the Maven Central repository, one must include the JBoss Third Party repository to fetch "nux:nux:1.6" jar. This project seems to nowhere to found in maven central and not actively being managed. The alternative solution is to fork the code of this project and build deploy a maven artifact with "org.teiid:nux:1.6" coordinates into Maven Central and use this in Teiid build.
> Also, xerces:xercesImpl seems to be in similar situation, but a stable version of this library is now available in the Maven Central repository. Teiid build should be moved to this version.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5225) Building embedded applications without JBoss Third Party repository is not possible
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5225?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5225:
-------------------------------------
I was thinking fix release, but if we have issues, then we can postpone this. I had a default XML parser selection issue with the current version of Saxon which got corrected in a later version, which surfaced during the WF-Swarm development.
> Building embedded applications without JBoss Third Party repository is not possible
> -----------------------------------------------------------------------------------
>
> Key: TEIID-5225
> URL: https://issues.jboss.org/browse/TEIID-5225
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.1
>
>
> Building any Teiid applications like
> - Embedded Teiid based applications
> - WildFly Swarm based applications
> - Spring Boot based applications
> is not possible just using the Maven Central repository, one must include the JBoss Third Party repository to fetch "nux:nux:1.6" jar. This project seems to nowhere to found in maven central and not actively being managed. The alternative solution is to fork the code of this project and build deploy a maven artifact with "org.teiid:nux:1.6" coordinates into Maven Central and use this in Teiid build.
> Also, xerces:xercesImpl seems to be in similar situation, but a stable version of this library is now available in the Maven Central repository. Teiid build should be moved to this version.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5225) Building embedded applications without JBoss Third Party repository is not possible
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5225?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5225:
---------------------------------------
> Also, how do you feel about upgrading the Saxon-HE library
Is it a fix release or a minor release? We've always had follow on issues from minor release changes.
> Building embedded applications without JBoss Third Party repository is not possible
> -----------------------------------------------------------------------------------
>
> Key: TEIID-5225
> URL: https://issues.jboss.org/browse/TEIID-5225
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.1
>
>
> Building any Teiid applications like
> - Embedded Teiid based applications
> - WildFly Swarm based applications
> - Spring Boot based applications
> is not possible just using the Maven Central repository, one must include the JBoss Third Party repository to fetch "nux:nux:1.6" jar. This project seems to nowhere to found in maven central and not actively being managed. The alternative solution is to fork the code of this project and build deploy a maven artifact with "org.teiid:nux:1.6" coordinates into Maven Central and use this in Teiid build.
> Also, xerces:xercesImpl seems to be in similar situation, but a stable version of this library is now available in the Maven Central repository. Teiid build should be moved to this version.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5222) Invalid conversion when selecting array
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5222?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5222.
-----------------------------------
Fix Version/s: 10.1
Resolution: Done
Applied as a general enhancement to allow all array type conversions that are allowable by the component types.
This can be back ported.
> Invalid conversion when selecting array
> ---------------------------------------
>
> Key: TEIID-5222
> URL: https://issues.jboss.org/browse/TEIID-5222
> Project: Teiid
> Issue Type: Bug
> Components: OData, Query Engine
> Affects Versions: 8.12.x-6.4
> Reporter: Maximilián Košiarčik
> Assignee: Steven Hawkins
> Fix For: 10.1
>
>
> When issuing a query to select array from table in H2 database in teiid such as:
> {code:sql}
> SELECT (a,b) FROM y;
> {code}
> a,b are both strings.
> it throws the following error:
> {noformat}
> Error: TEIID10076 Invalid conversion from type class java.lang.Object with value '[Ljava.lang.Object;@30b0a27' to type class [Ljava.lang.String;
> {noformat}
> When issuing this query against H2 directly it works without error.
> I find the issue when testing TEIID-4380, teiid issues such a query when building the response for deep insert.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5225) Building embedded applications without JBoss Third Party repository is not possible
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5225?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5225:
-------------------------------------
Hopefully, I can finish today. The major task is converting the ant build to maven build for nux. Also, how do you feel about upgrading the Saxon-HE library, there is a minor issue with current version with WildFly-Swarm builds.
> Building embedded applications without JBoss Third Party repository is not possible
> -----------------------------------------------------------------------------------
>
> Key: TEIID-5225
> URL: https://issues.jboss.org/browse/TEIID-5225
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.1
>
>
> Building any Teiid applications like
> - Embedded Teiid based applications
> - WildFly Swarm based applications
> - Spring Boot based applications
> is not possible just using the Maven Central repository, one must include the JBoss Third Party repository to fetch "nux:nux:1.6" jar. This project seems to nowhere to found in maven central and not actively being managed. The alternative solution is to fork the code of this project and build deploy a maven artifact with "org.teiid:nux:1.6" coordinates into Maven Central and use this in Teiid build.
> Also, xerces:xercesImpl seems to be in similar situation, but a stable version of this library is now available in the Maven Central repository. Teiid build should be moved to this version.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5225) Building embedded applications without JBoss Third Party repository is not possible
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5225?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5225:
---------------------------------------
Do you need to have this in 10.1, and if so how long will you need?
> Building embedded applications without JBoss Third Party repository is not possible
> -----------------------------------------------------------------------------------
>
> Key: TEIID-5225
> URL: https://issues.jboss.org/browse/TEIID-5225
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 10.0
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.1
>
>
> Building any Teiid applications like
> - Embedded Teiid based applications
> - WildFly Swarm based applications
> - Spring Boot based applications
> is not possible just using the Maven Central repository, one must include the JBoss Third Party repository to fetch "nux:nux:1.6" jar. This project seems to nowhere to found in maven central and not actively being managed. The alternative solution is to fork the code of this project and build deploy a maven artifact with "org.teiid:nux:1.6" coordinates into Maven Central and use this in Teiid build.
> Also, xerces:xercesImpl seems to be in similar situation, but a stable version of this library is now available in the Maven Central repository. Teiid build should be moved to this version.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months
[JBoss JIRA] (TEIID-5222) Invalid conversion when selecting array
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5222?page=com.atlassian.jira.plugin... ]
Work on TEIID-5222 started by Steven Hawkins.
---------------------------------------------
> Invalid conversion when selecting array
> ---------------------------------------
>
> Key: TEIID-5222
> URL: https://issues.jboss.org/browse/TEIID-5222
> Project: Teiid
> Issue Type: Bug
> Components: OData, Query Engine
> Affects Versions: 8.12.x-6.4
> Reporter: Maximilián Košiarčik
> Assignee: Steven Hawkins
>
> When issuing a query to select array from table in H2 database in teiid such as:
> {code:sql}
> SELECT (a,b) FROM y;
> {code}
> a,b are both strings.
> it throws the following error:
> {noformat}
> Error: TEIID10076 Invalid conversion from type class java.lang.Object with value '[Ljava.lang.Object;@30b0a27' to type class [Ljava.lang.String;
> {noformat}
> When issuing this query against H2 directly it works without error.
> I find the issue when testing TEIID-4380, teiid issues such a query when building the response for deep insert.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 11 months