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