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

积木BI大屏1.93版本,在ORACLE数据库下,点击【模版案例】【文件夹】接口报错 #7721

Closed
huweinan03 opened this issue Jan 14, 2025 · 2 comments

Comments

@huweinan03
Copy link

版本号:
积木BI大屏1.93

问题描述:
积木BI大屏1.93版本,在ORACLE数据库下,点击【模版文件】【文件夹】接口报错
这两个接口的查询SQL中有条件 odp.type = "0" ,在mysql环境下可以运行,在oracle环境下无法运行,是否应该为单引号 ‘0’
错误sql:
SELECT count(0)
FROM onl_drag_page odp
LEFT JOIN jimu_report_category jrc
ON odp.type = jrc.id
WHERE jrc.del_flag = 0
AND odp.STYLE = ?
AND odp.iz_template = ?
AND odp.del_flag = ?
OR (odp.type = "0" AND odp.STYLE = ? AND odp.del_flag = ? AND
odp.iz_template = ?)

错误截图:
image
image

@huweinan03 huweinan03 changed the title 积木BI大屏1.93版本,在ORACLE数据库下,点击【模版文件】【文件夹】接口报错 积木BI大屏1.93版本,在ORACLE数据库下,点击【模版案例】【文件夹】接口报错 Jan 14, 2025
@zhangdaiscott
Copy link
Member

收到 sq

@jeecgDeveloper
Copy link

已修改,下版本更新

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

3 participants