Youichi Sugiyama comments

Repositories
Issues
Comments

Results 1 comments of


                                            Youichi Sugiyama

After upgrading from 7.0.0 to 8.0.2, SQL translation results are changed and this version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'.

Ah, the effects of this disruptive change. https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-8.0/whatsnew#better-use-of-in-queries But I think I need another workaround, since MySQL does not allow the use of LIMIT clauses in subqueries of IN clauses