xa start 'tr1#$', 'bq', 3;
|
insert t1 values (40);
|
xa end 'tr1#$', 'bq', 3;
|
xa prepare 'tr1#$', 'bq', 3;
|
xa recover format='RAW';
|
+----------+--------------+--------------+---------+
|
| formatID | gtrid_length | bqual_length | data |
|
+----------+--------------+--------------+---------+
|
| 3 | 5 | 2 | tr1#$bq |
|
+----------+--------------+--------------+---------+
|
|
xa recover format='SQL';
|
+----------+--------------+--------------+-------------------------+
|
| formatID | gtrid_length | bqual_length | data |
|
+----------+--------------+--------------+-------------------------+
|
| 3 | 5 | 2 | X'7472312324',X'6271',3 |
|
+----------+--------------+--------------+-------------------------+
|
|
xa recover format=RAW;
|
+----------+--------------+--------------+---------+
|
| formatID | gtrid_length | bqual_length | data |
|
+----------+--------------+--------------+---------+
|
| 3 | 5 | 2 | tr1#$bq |
|
+----------+--------------+--------------+---------+
|
|
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
|