Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14922

XA RECOVER FORMAT='SQL' requires quotes while XA RECOVER FORMAT=RAW does not

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3
    • Fix Version/s: 10.3
    • Component/s: XA
    • Labels:
      None

      Description

      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 
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                greenman Ian Gilfillan
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: