Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.4
-
None
-
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 */
|