|
When passing only 1 value to VALUES, both in Db2 and Oracle parenthesis are optional. Supporting this in MariaDB should be a small compatibility enhancement.
MariaDB [test]> VALUES ('Hello World');
|
+-------------+
|
| Hello World |
|
+-------------+
|
| Hello World |
|
+-------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> VALUES 'Hello World';
|
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 ''Hello World'' at line 1
|
|