I face an error in the version 20.1.0-202202061055110045-36733c65 (Community Edition) that I did not face in previous version (like the 15.5.0-202105040508160960-dddd4dca).
It’s impossible to get result from a query like that:
select t1.col1 ,( SELECT t2.col15 FROM table2 t2 where t2.year <= t1.year order by t2.col15 DESC limit 1 ) as col15 from table1 t1
The LIMIT clause generates an error.
For sure this kind of queries works fine in previous version. I join the query profil here.
8a8e15c8-754f-4a73-9aa1-1936c54d50f4.zip (20.1 KB)