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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 3h
                3h

                Git Integration

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