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

FusionIO: Unexpected syntax error on attempt to create a table with ATOMIC_WRITES=ON option

    XMLWordPrintable

Details

    Description

      CREATE TABLE t4 (i int) ENGINE=InnoDB ATOMIC_WRITES=ON;
      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 'ON' at line 1

      But the following is recognized:

      CREATE TABLE t5 (i int) ENGINE=InnoDB ATOMIC_WRITES='ON';
      CREATE TABLE t6 (i int) ENGINE=InnoDB ATOMIC_WRITES=OFF;

      This is unusual and inconsistent.

      revision-id: jplindst@mariadb.org-20140328064402-8xr2e8ck5oqatto2
      date: 2014-03-28 08:44:02 +0200
      build-date: 2014-04-09 22:27:11 +0300
      revno: 3970
      branch-nick: 10.0-FusionIO

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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