[MDEV-5009] don't look inside /*!50700 ... */ comments Created: 2013-09-10  Updated: 2013-12-19  Resolved: 2013-12-18

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.4
Fix Version/s: 10.0.7

Type: Bug Priority: Major
Reporter: Sergei Golubchik Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
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 */



 Comments   
Comment by Alexander Barkov [ 2013-12-18 ]

Pushed into 10.0-base and 10.0

Generated at Thu Feb 08 07:00:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.