February 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ] Work on TEIID-3281 started by Ramesh Reddy. ------------------------------------------- > MongoDB: EmptyStackException when joining tables > ------------------------------------------------ > > Key: TEIID-3281 > URL: https://issues.jboss.org/browse/TEIID-3281 > Project: Teiid > Issue Type: Bug > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Fix For: 8.10 > > Attachments: mongodb-vdb.xml, server.log > > > Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled. > Example: > {code} > insert into customer2 values(1,'Pepa', 'Koukal'); > insert into customer2 values(2,'Jan', 'Tlemil'); > insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode'); > insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode'); > {code} > {code} > select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID > {code} > {code} > Error: > java.util.EmptyStackException > at java.util.Stack.peek(Stack.java:102) > at java.util.Stack.pop(Stack.java:84) > at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993) > at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) > at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) > at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112) > {code} > VDB and log are in the attachment. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2561) Allow nested MERGE of entities in MongoDB translators

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2561?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-2561. --------------------------------- Labels: CR2 (was: ) Resolution: Done Added capability to nest multiple levels using "MERGE" functionality. the scenarios supported are N1 ===> N2 ===> N3 one -2- one - one N1 ===> N2 ===> N4[] one -2- one - many N1 ===> N5[] ===> N6 one -2- many - one N1 ===> N5[] ===> N7[] one -2- many - many It may work more 3 levels deep, but not tested. Also re-worked some parts of the code to make it simpler. The "EMBEDDABLE" is still needs be used with single nested level. I do not see a big compelling reason to support nesting here. > Allow nested MERGE of entities in MongoDB translators > ----------------------------------------------------- > > Key: TEIID-2561 > URL: https://issues.jboss.org/browse/TEIID-2561 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: CR2 > Fix For: 8.10 > > > When MERGE is on child table, Allow parent table to be participate in another "MERGE" or "EMBEDDEBLE" scenario. > This will allow greater number of tables to be collapsed into single document. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3340) JDBC direct query execution binding is incorrect

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3340?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3340. ----------------------------------- Resolution: Done Corrected the direct logic and updated the general binding logic for null and object bindings to be more in line with what drivers expect (similar to the existing oracle logic). > JDBC direct query execution binding is incorrect > ------------------------------------------------ > > Key: TEIID-3340 > URL: https://issues.jboss.org/browse/TEIID-3340 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > The binding logic is passing the literal and the 0 based index, when it should be passing the literal value and the 1 based index. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3340) JDBC direct query execution binding is incorrect

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3340: ------------------------------------- Summary: JDBC direct query execution binding is incorrect Key: TEIID-3340 URL: https://issues.jboss.org/browse/TEIID-3340 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10 The binding logic is passing the literal and the 0 based index, when it should be passing the literal value and the 1 based index. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3339) Adding the multisource column does not work with variadic procedures

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3339: ------------------------------------- Summary: Adding the multisource column does not work with variadic procedures Key: TEIID-3339 URL: https://issues.jboss.org/browse/TEIID-3339 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10 Adding the multi-source column as the last parameter to a variadic procedure results in a validation exception. Options to resolve this include adding the parameter as the second to last, not allowing the procedure to have a multi-source parameter, or choosing a different paradigm - such as call procname_source... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3337) Netty exception related to close logged at warn level

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3337: ------------------------------------- Summary: Netty exception related to close logged at warn level Key: TEIID-3337 URL: https://issues.jboss.org/browse/TEIID-3337 Project: Teiid Issue Type: Quality Risk Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10 An exception with the message "An existing connection was forcibly closed by the remote host" is still being logged at a warning level -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3326) Add back a drools quick start

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3326?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3326. ----------------------------------- Fix Version/s: 8.10 Resolution: Done Added Kylin's quick start. We can revisit later if we want to show modifying a row. > Add back a drools quick start > ----------------------------- > > Key: TEIID-3326 > URL: https://issues.jboss.org/browse/TEIID-3326 > Project: Teiid > Issue Type: Quality Risk > Components: Quick Starts > Reporter: Steven Hawkins > Fix For: 8.10 > > > Add back a Drools quick start: https://docs.jboss.org/author/display/teiidexamples/Drools+Component+Inte... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3335) Uniqueidentifier values are casted inside INSERT clause field list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3335?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3335: --------------------------------------- You should upgrade if possible. Alternatively you could branch and cherry-pick that fix to stay on 8.4.x. > Uniqueidentifier values are casted inside INSERT clause field list > ------------------------------------------------------------------ > > Key: TEIID-3335 > URL: https://issues.jboss.org/browse/TEIID-3335 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Nicholas D > Assignee: Steven Hawkins > Labels: sqlserver2012 > > When inserting into SQL Server table which has uniqueidentifier values - Teiid casts these fields to char(36) inside field list. > Example. When i execute query > bq. INSERT INTO TABLE(record_id, "time", tag_id, "value") > VALUES(UUID(), NOW(), '123', 123);}} > Teiid gives me error > bq. Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ds: 102 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-12 15:40:18.051'}] SQL: INSERT INTO "dbo"."TABLE" (cast("RECORD_ID" as char(36)), "TIME", "TAG_ID", "VALUE") VALUES (uuid(), ?, '123', 123)] -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3335) Uniqueidentifier values are casted inside INSERT clause field list

by Nicholas D (JIRA)

[ https://issues.jboss.org/browse/TEIID-3335?page=com.atlassian.jira.plugin... ] Nicholas D commented on TEIID-3335: ----------------------------------- Do i have any options if i'm stuck with 8.4 version? Will changing driver help? > Uniqueidentifier values are casted inside INSERT clause field list > ------------------------------------------------------------------ > > Key: TEIID-3335 > URL: https://issues.jboss.org/browse/TEIID-3335 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Nicholas D > Assignee: Steven Hawkins > Labels: sqlserver2012 > > When inserting into SQL Server table which has uniqueidentifier values - Teiid casts these fields to char(36) inside field list. > Example. When i execute query > bq. INSERT INTO TABLE(record_id, "time", tag_id, "value") > VALUES(UUID(), NOW(), '123', 123);}} > Teiid gives me error > bq. Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ds: 102 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-12 15:40:18.051'}] SQL: INSERT INTO "dbo"."TABLE" (cast("RECORD_ID" as char(36)), "TIME", "TAG_ID", "VALUE") VALUES (uuid(), ?, '123', 123)] -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3319) Union with different datatypes gives error in mysql

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3319?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3319. ----------------------------------- Resolution: Done removed the implicit conversion in union scenarios to allow mysql more freedom in matching the types. > Union with different datatypes gives error in mysql > --------------------------------------------------- > > Key: TEIID-3319 > URL: https://issues.jboss.org/browse/TEIID-3319 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Mark Tawk > Assignee: Steven Hawkins > Fix For: 8.10 > > > Hello, > I'm using Teiid 8.9.0 Alpha2 with mysql5.7 and mysql5 translator. > I have a union query with fields of different types, int and varchar. > Teiid is adding dynamically the cast as char to the int field but the jdbc query is giving an error on mysql level (Illegal mix of collations for operation 'UNION') > I edited the generated jdbc query and added cast as char to both fields int and varchar, mysql executes the jdbc query without a problem. > I added convert to String to both union fields in Teiid sql query, but the jdbc query generated by teiid is not adding the cast to the string field. > Teiid sql query: > select "ITRITPTicketsView"."ITRITPTicketsView_jiraissue_" as "ITRITPTicketsView_jiraissue_" > from ((select convert("ITRITPTicketsView_sub"."jiraissue_ID", string) as "ITRITPTicketsView_jiraissue_" from "implifyBusinessModel"."ITRITPTicketsView" "ITRITPTicketsView_sub") > union > (select convert("SDView_sub"."incidentsm1_INCIDENT_ID", string) as "SDView_incidentsm1_INCIDENT_" from "implifyBusinessModel"."SDView" "SDView_sub") > ) "ITRITPTicketsView" > LIMIT 0 , 10 > The generated error: > org.teiid.translator.jdbc.JDBCExecutionException: 1271 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: (SELECT cast(g_1.`jiraissue_ID` AS char) AS c_0 FROM `implify_view`.`ITRITPTicketsView` AS g_1) UNION (SELECT g_0.`incidentsm1_INCIDENT_ID` AS c_0 FROM `implify_view`.`SDView` AS g_0) LIMIT 10] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:151) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.sql.SQLException: Illegal mix of collations for operation 'UNION' > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838) > at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2212) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:141) > ... 12 more > Feb 03, 2015 8:43:32 AM org.teiid.logging.JavaLogger log > WARNING: TEIID30020 Processing exception for request AxQ9XTXrAYkm.0 'TEIID30504 implify_viewModelVDB: 1271 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: (SELECT cast(g_1.`jiraissue_ID` AS char) AS c_0 FROM `implify_view`.`ITRITPTicketsView` AS g_1) UNION (SELECT g_0.`incidentsm1_INCIDENT_ID` AS c_0 FROM `implify_view`.`SDView` AS g_0) LIMIT 10]'. Originally TeiidProcessingException 'Illegal mix of collations for operation 'UNION'' SQLError.java:1084. Enable more detailed logging to see the entire stacktrace. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2015