MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=10'

Question

I am posting this to save another dev hours of wasted time. Mysql release candidate 5.6.7-rc is junk. As as dev I usually follow as closely as possible with latest version. This caused me hours of debugging gerrit and mysql. The answer is to use a stable version. I hope this helps someone else.

Not sure on the SO protocol for doing something like this - so just posting as a question.

mysql> select VERSION();
+--------------+
| VERSION()    |
+--------------+
| 5.6.7-rc-log |
+--------------+
1 row in set (0.00 sec)

mysql> SET OPTION SQL_SELECT_LIMIT=10;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=10' at line 1


mysql>  select VERSION();
+------------+
| VERSION()  |
+------------+
| 5.5.28-log |
+------------+
1 row in set (0.00 sec)

mysql> SET OPTION SQL_SELECT_LIMIT=10;
Query OK, 0 rows affected (0.00 sec)

Answer 1

Older versions of MySQL employed SET OPTION, but this syntax is deprecated in favor of SET without OPTION.

SET OPTION syntax is deprecated, and was removed in version 5.6.

You should just use SET SQL_SELECT_LIMIT=10; instead.

Look at the here.

Incompatible Change: The obsolete OPTION modifier for the SET statement has been removed.