为了更快的定位您的问题，请提供以下信息，谢谢
【详述】SQL 错误 [1064] [42000]: Not support Non-EQ correlated predicate in correlated subquery
【背景】执行下面的SQL语句报错
【StarRocks版本】3.0.1
【集群规模】1fe、1be
【附件】
SELECT
RES.*
from
FLW_CHANNEL_DEFINITION RES
WHERE
RES.VERSION_ = (
select
max(VERSION_)
from
FLW_CHANNEL_DEFINITION
where
KEY_ = RES.KEY_
and
(
(
TENANT_ID_ IS NOT NULL
and TENANT_ID_ = RES.TENANT_ID_
)
or (
TENANT_ID_ IS NULL
and RES.TENANT_ID_ IS NULL
)
)
)
order by
RES.ID_ asc;
详细信息：
org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1064] [42000]: Not support Non-EQ correlated predicate in correlated subquery
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:578)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:487)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:173)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:494)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:913)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3760)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:123)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:173)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:121)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5033)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLSyntaxErrorException: Not support Non-EQ correlated predicate in correlated subquery
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:329)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.lambda$0(JDBCStatementImpl.java:131)
at org.jkiss.dbeaver.utils.SecurityManagerUtils.wrapDriverActions(SecurityManagerUtils.java:96)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
… 12 more
这张表是查略官网，通过FlinkSQL的方式同步过来的，查询语句在MySQL里执行没问题，StarRocks执行报错了
这种的还不支持
好的，谢谢，这边用了一个开源的ruoyi-vue-plus框架，这个框架用了一个flowable，这个SQL是这个框架执行的 
，我们打算把mysql替换成starrocks，后面对接大数据，我先看看为什么要用这个框架或者怎么改一下这个sql吧
怎么样啊佬， 我也再做 ruoyi-vue 迁移工作。
