MySQL Bugs: #120345: XA END ... SUSPEND returns XAER

Bug #120345	XA END ... SUSPEND returns XAER_INVAL
Submitted:	26 Apr 19:18
Reporter:	Kristian Ivarsson	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: XA transactions	Severity:	S4 (Feature request)
Version:	8.4.8	OS:	Ubuntu
Assigned to:		CPU Architecture:	x86 (64)
Tags:	xa end

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
XA END ... SUSPEND returns XAER_INVAL despite documentation stating it is "recognized but has no effect"

How to repeat:
Call this through ODBC (even though the behaviour is the same even through the CLI)

"XA END X'AA',X'AA',1 SUSPEND;"

... and you get XAER_INVAL even though the documentation states that it should be valid (but maybe ignored)

Calling without suspend

"XA END X'AA',X'AA',1;"

... works fine, but thetransaction isn't really ended, but merely suspended