[teiid-issues] [JBoss JIRA] Resolved: (TEIID-753) MySQL translator issues
[
https://jira.jboss.org/jira/browse/TEIID-753?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-753.
----------------------------------
Resolution: Done
Added a check for a gloabl transaction in the autocommit detection, also changed the
timestamp literal to use JDBC escape syntax. Also changed the timestamp nano precision to
0, since mysql does not store fractional seconds.
MySQL translator issues
-----------------------
Key: TEIID-753
URL: https://jira.jboss.org/jira/browse/TEIID-753
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 6.2.0
MySQL does not change the autocommit flag to false when running in a global transaction,
however the current autocommit detection logic does not take whether we're in an xa
transaction into account.
Also the timestamp literal format TIMESTAMP(...) actually produces a null value. This
should be changed to either the jdbc escape syntax or simply the string literal form.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira