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

LEFT JOIN bug #34

Closed
enoch300 opened this issue Apr 1, 2020 · 3 comments
Closed

LEFT JOIN bug #34

enoch300 opened this issue Apr 1, 2020 · 3 comments
Labels

Comments

@enoch300
Copy link

enoch300 commented Apr 1, 2020

你好!
在使用js-sql-parser时发现一个问题:
ast = sqlParser.parse("SELECT stime, A.names, B.names FROM (SELECT stime, names FROM iaas_data.iaas_d3c0d0681cc1900) AS A LEFT JOIN (SELECT stime, names FROM iaas_data.iaas_1071f89feaa0e100) AS B ON A.stime = B.stime")

sqlParser.stringify(ast) 结果:
SELECT stime, A.names, B.names FROM (SELECT stime, names FROM iaas_data.iaas_d3c0d0681cc1900) LEFT JOIN (SELECT stime, names FROM iaas_data.iaas_1071f89feaa0e100) ON A.stime = B.stime

问题:
sqlParser.stringify(ast)后的SQL 没有 AS A 和 AS B 导致SQL错误.

@enoch300 enoch300 changed the title Bug LEFT JOIN bug Apr 1, 2020
@albin3 albin3 added the bug label Apr 2, 2020
@albin3 albin3 closed this as completed in 394e5cc Apr 2, 2020
@albin3
Copy link
Member

albin3 commented Apr 2, 2020

@albin3
Copy link
Member

albin3 commented Apr 2, 2020

@enoch300 版本1.3.0修复了,多谢

@enoch300
Copy link
Author

enoch300 commented Apr 2, 2020

@enoch300 版本1.3.0修复了,多谢

不客气,很好用。后续有什么问题再给您反馈哈 ,感谢付出

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

No branches or pull requests

2 participants