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

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3(EOL)
    • 10.4(EOL)
    • XA
    • 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

              serg Sergei Golubchik
              greenman Ian Gilfillan
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.