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 |
|
+----------+--------------+--------------+------+
|
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 |
+----------+--------------+--------------+------+