[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)
9 years, 4 months
[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)
9 years, 4 months
[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)
9 years, 4 months
[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)
9 years, 4 months
[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)
9 years, 4 months
[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)
9 years, 4 months
[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)
9 years, 4 months
[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)
9 years, 4 months
[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 resolved TEIID-3335.
-----------------------------------
Fix Version/s: (was: 8.10)
Resolution: Duplicate Issue
This is a duplicate of TEIID-3161
So it would need the 8.9 server, not just the driver.
> 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)
9 years, 4 months