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

SQL代码生成:只能通过查询语句生成DTO对象,请检查SQL #108

Open
vjsplus opened this issue Dec 7, 2023 · 0 comments
Open

Comments

@vjsplus
Copy link

vjsplus commented Dec 7, 2023

当前使用版本(必填,否则不予处理)

com.github.davidfantasy mybatis-plus-generator-ui 2.0.1

该问题是如何引起的?(确定最新版也有问题再提!!!)

重现步骤(如果有就写完整)

你好,我第一次使用通过SQL生成代码的功能。我的sql语句使用Navicat验证是正确的,但是页面报"只能通过查询语句生成DTO对象,请检查SQL"。
我有疑问是否支持SQL迭代查询呢?
WX20231207-153342

sql WITH RECURSIVE company_hierarchy AS (SELECT id, company_name, super_id FROM gmd_company_info WHERE id = '#{companyId}' UNION ALL SELECT c.id, c.company_name, c.super_id FROM gmd_company_info c INNER JOIN company_hierarchy ch ON c.super_id = ch.id) SELECT * FROM company_hierarchy

报错信息

只能通过查询语句生成DTO对象,请检查SQL

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

1 participant