Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.4.6
-
None
-
Mariadb 10.4.6
Newest FC 30
5.1.15-300.fc30.x86_64 #1
Description
Hello Everyone, I have found some small regression in error reporting, basically it reports lack of derieved table's alias as syntax error in new version of maria. I think maybe some code was removed in 10.4 and that resulted in generic error being output instead of more descriptive one. Not sure if that's a bug, basically the older server was working better in this regard so reporting as minor bug and maybe it can be made to work the old way...
Code to reproduce it:
CREATE TEMPORARY TABLE `test_regr_99182` ( |
`x` varchar(255) NULL ); |
SELECT count(*) FROM |
(SELECT * FROM test_regr_99182 limit 1) |
What new version (10.4.6) does:
[Err] 1064 - 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 '' at line 7
What old version (10.1) does:
[Err] 1248 - Every derived table must have its own alias