Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.6.15, 11.4
-
None
Description
SELECT 123 AS x is the same as SELECT 123 x. Extending to strings, SELECT '123' AS 'x' gives:
MariaDB [test]> SELECT '123' AS 'x';
|
+-----+
|
| x |
|
+-----+
|
| 123 |
|
+-----+
|
1 row in set (0.000 sec)
|
Which is what one would expect.
However, SELECT '123' 'x' yields an unexpected result:
MariaDB [test]> SELECT '123' 'x';
|
+------+
|
| 123 |
|
+------+
|
| 123x |
|
+------+
|
1 row in set (0.001 sec)
|
In the last example, the column name should match the returned value (123x or similar).
Attachments
Activity
Notes for the changelog: String literals that are next to each other are concatenated together, for example, select '123' 'x' will produce '123x'. When the string literal in the select list, its value will be used as column name. Before this fix, only the first literal is used for the name, '123'. After the fix, the result of the concatenation is used as the name, '123x'.
https://mariadb.com/kb/en/string-literals/