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

don't look inside /*!50700 ... */ comments

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.4
        • Fix Version/s: 10.0.7
        • Component/s: None
        • Labels:
          None

          Description

          MariaDB will try to parse and execute SQL inside, for example,

          /*!50701 ... */

          comments. Because, when compared as versions, 5.7.1 is less than 10.0.4. But in fact, MySQL-5.7 has new features and might have new SQL syntax that MariaDB-10.0 does not understand.

          To fix this MariaDB-10.0 will ignore all versioned comments with MySQL version in the range 50700–509999.

          If a user wants to use a feature that is in MySQL 5.7 and MariaDB 10.0, he can use
          repeating things for both releases:

          SELECT /*!50701 aaa */ /*!100101 aaa */

          or use the MariaDB syntax (if he is only using MariaDB):

          SELECT /*!M50701 aaa */

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                bar Alexander Barkov added a comment -

                Pushed into 10.0-base and 10.0

                Show
                bar Alexander Barkov added a comment - Pushed into 10.0-base and 10.0

                  People

                  • Assignee:
                    bar Alexander Barkov
                    Reporter:
                    serg Sergei Golubchik
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: