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

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

            SQL is documented as a reserved word, so it's probably not very surprising, but since we seem to be trying to allow everything that doesn't cause ambiguity, assigning it to serg to confirm whether it's intentional.

            elenst Elena Stepanova added a comment - SQL is documented as a reserved word, so it's probably not very surprising, but since we seem to be trying to allow everything that doesn't cause ambiguity, assigning it to serg to confirm whether it's intentional.

            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.