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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Won't Fix
        • Affects Version/s: N/A
        • Fix Version/s: 10.0.15-FusionIO
        • Component/s: None
        • Labels:

          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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                jplindst Jan Lindström added a comment -

                Can't help, ON is reserved word on SQL, thus it can't be used here an you must use 'ON' instead. OFF is not a reserved work on SQL thus both OFF and 'OFF' are valid.

                Show
                jplindst Jan Lindström added a comment - Can't help, ON is reserved word on SQL, thus it can't be used here an you must use 'ON' instead. OFF is not a reserved work on SQL thus both OFF and 'OFF' are valid.

                  People

                  • Assignee:
                    jplindst Jan Lindström
                    Reporter:
                    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 - 0 minutes
                      0m
                      Logged:
                      Time Spent - 3 hours
                      3h