sql.engines.oracle.filter_sql方法导致部分查询语句不可用 #2672
waitspring
started this conversation in
General
Replies: 2 comments
-
你可以把你的方案以pr形式提交上来看看 |
Beta Was this translation helpful? Give feedback.
0 replies
-
另外是你可以自定义engine https://github.com/hhyo/Archery/tree/master/sql/engines |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
在sql.engines.oracle模块内,我们发现一个功能特性:
这会导致Oracle数据库的任意数据查询语句都会被装载到临时表内。那么,当我们执行多表联查时,如果多表联查的语句不严谨,在select查询的字段列表内存在同名字段时,查询结果装载临时表失败,并引发整个查询语句失败。
样例如下:
能否更新
filter_sql
方法,变更临时表的限制方案?Beta Was this translation helpful? Give feedback.
All reactions