Ian Gilfillan added a comment - 2018-01-10 14:56 holyfoot , monty or serg please provide examples for this feature - I can't find any tests, and the documentation added to the page in: https://mariadb.com/kb/en/library/xa-transactions/+revision/64274/64269/ and https://mariadb.com/kb/en/library/xa-transactions/+revision/64269/25115/ is not correct or sufficient. For example, XA RECOVER FORMAT=SQL; ERROR 1064 (42000): 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 'SQL' at line 1 If I run the two forms, all I see is a difference in quotes, and I'm not sure how that's helpful: XA RECOVER FORMAT='SQL'; +----------+--------------+--------------+--------+ | formatID | gtrid_length | bqual_length | data | +----------+--------------+--------------+--------+ | 1 | 4 | 0 | 'test' | +----------+--------------+--------------+--------+   XA RECOVER FORMAT='RAW'; +----------+--------------+--------------+------+ | formatID | gtrid_length | bqual_length | data | +----------+--------------+--------------+------+ | 1 | 4 | 0 | test | +----------+--------------+--------------+------+

Sergei Golubchik added a comment - 2018-01-10 21:33 Test cases are in the commit, https://github.com/mariadb/server/commit/0acac4fe5fd6d8fab9f13859219f46842153803b For a meaningful test case try something with non-printable bytes in gtrid and/or with bqual. Then you'll see the difference.