Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

goInception 不支持 select 语句中包含子查询 #266

Closed
sheenzxx opened this issue Sep 10, 2020 · 2 comments
Closed

goInception 不支持 select 语句中包含子查询 #266

sheenzxx opened this issue Sep 10, 2020 · 2 comments

Comments

@sheenzxx
Copy link

sheenzxx commented Sep 10, 2020

在select 语句中出现的只查询。不能识别from 列表的 的字段。

CREATE TABLE temp_test1(id INT,NAME VARCHAR(30));
CREATE TABLE temp_test2(id INT ,salesid INT ,title VARCHAR(100));

INSERT INTO temp_test1 VALUES (1,'helo'),(2,'bilgo'),(3,'dolot');
INSERT INTO temp_test2 VALUES (1,1,'月光光'),(2,2,'品牌效应'),(3,3,'李白醉酒');

SELECT a.id,a.title,(SELECT b.name FROM temp_test1 b WHERE b.id = a.salesid) AS salesname
FROM temp_test2 a

image

在 (SELECT b.name FROM temp_test1 b WHERE b.id = a.salesid) 子句中。识别不了a.salesid
环境

  • 数据库: [mysql]
  • 版本: [例如 5.6.3]
@hanchuanchuan
Copy link
Owner

该问题已修复.
Releases (选择v1.2.3-32或以上版本)

@sheenzxx
Copy link
Author

谢谢@hanchuanchuan

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants