|
Query returns syntax error in MariaDB 5.5-10.0, but works >=10.1
SELECT 1 AS i FROM dual ORDER BY i;
SELECT 1 AS i FROM dual GROUP BY i;
MariaDB [test]> SELECT 1 AS i FROM dual ORDER BY i;
|
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 'ORDER BY i' at line 1
|
|
MariaDB [test]> SELECT 1 AS i FROM dual GROUP BY i;
|
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 'GROUP BY i' at line 1
|
|