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

Setting sql_mode=oracle ,creates table with double quotes ,replay fails with syntax error

    XMLWordPrintable

Details

    • Q3/2026 Server Maintenance

    Description

      Issue:
      --------
      create sequence s1; -->creates table with double quotes i.e

      CREATE TABLE "s1" .........

      replay fails with syntax error

      For mtr output : refer mtr5.out

      MTR testcase to repro issue: (Say example.test)

      SET sql_mode=ORACLE;
      CREATE SEQUENCE s1;
      EXPLAIN select * from s1;
      drop sequence s1;
      

      How to repro:

      ./mtr example.test  --replay-server
      

      Attachments

        1. mtr5.out
          2 kB
          Pavithra Pandith

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 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.