sql没加虚拟表from dual审核错误

[LiuHuAshen]

描述

INSERT INTO employees (id, first_name, last_name, salary) 
SELECT (select IFNULL(MAX(id), 0) from employees) + 1, 'John', 'Doe2', 50000.0 
WHERE NOT EXISTS (SELECT 1 FROM employees WHERE first_name='John3'); 

这个语句可以在navicate正常执行，但是 在archery，goinception审核不过，异常信息如下，

加上from dual后正常解析语句并审核了，这是为什么呢

INSERT INTO employees (id, first_name, last_name, salary) 
SELECT (select IFNULL(MAX(id), 0) from employees) + 1, 'John', 'Doe2', 50000.0 
from dual
WHERE NOT EXISTS (SELECT 1 FROM employees WHERE first_name='John3'); 

环境

• 数据库: [mysql/mariadb]
• 版本: [例如 5.7.21]

[zmix999]

应该是parser解析问题，也可以看下我的fork的分支https://gitee.com/zhoujin826/goInception