Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
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 |