[CONPY-90] XA test fail (SQL Alchemy) Created: 2020-07-28  Updated: 2021-03-23

Status: Confirmed
Project: MariaDB Connector/Python
Component/s: DBAPI 2.0
Affects Version/s: 1.0.0
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Georg Richter Assignee: Georg Richter
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-16708 Unsupported commands for prepared sta... Closed

 Description   

test_execute test of SQL Alchemy fails due to lack of supporting XA statements in binary protocol:

Python 3.8.1 (default, Dec 31 2019, 18:42:42) 
[GCC 7.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import mariadb
>>> c=mariadb.connect(database="test")
>>> cursor=c.cursor()
>>> cursor.execute("XA BEGIN ?", ('_sa_8a4708f106847beffd4ac9d1ea513d3b',))
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
mariadb.ProgrammingError: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1



 Comments   
Comment by Georg Richter [ 2021-03-10 ]

Implementation of MDEV-16708 will not fix this issue, unless placeholders will be supported in XA statements too.

Generated at Thu Feb 08 03:30:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.