[BUG]What is the problem with using MySQL database Elsa service error?

elsa-workflows / elsa-core

A .NET workflows library

https://v3.elsaworkflows.io/

MIT License

6.53k stars 1.2k forks source link

[BUG]What is the problem with using MySQL database Elsa service error? #6091

Closed EthanZqh closed 2 weeks ago

EthanZqh commented 3 weeks ago

The MySQL server version is community-based mysql-8.0.30-winx64 or community-based mysql-9.0.1-winx64 Limit&IN/ALL/ANY/OME subqueries are not yet supported Solution problem: 1. Which MySQL version supports the "Limit&IN/ALL/ANY/OME subquery" query?

It is to modify the nested source code query, but I cannot modify the Elsa source code. I am referencing the Elsa Dll dynamic library.

elsa-mysql-err

sfmskywalker commented 2 weeks ago

Closing because this one has been duplicated via #6096