sqle icon indicating copy to clipboard operation
sqle copied to clipboard

SQLE预检查不能检测出子查询内表是否存在

Open taolx0 opened this issue 2 years ago • 0 comments

版本

2.9999.x

现象

  1. 此类嵌套sql预检查不能处理
SELECT
  *
FROM
  (
    SELECT
      users.login_name
    FROM
      workflows
      JOIN users ON workflows.created_at = users.created_at
  ) AS project_user; 

原因?

预检查逻辑未获取子查询内的表名

修复方案

利用访问者模式获取所有表名

taolx0 avatar Nov 10 '23 09:11 taolx0