odc
odc copied to clipboard
[Bug]: fail to export result set for sql with * and nvl function
ODC version
4.2.4
OB version
4.2.x oboracle
What happened?
When export result set for sql with * and nvl function like select *, nvl(1,0) from whatever_tbl, it would fail.
This is because ODC would rewrite table to add select * from (xxx) fetch first x rows only statement on the sql.
It may cause invalid SQL statement error.
What did you expect to happen?
do not rewrite user's sql
How can we reproduce it (as minimally and precisely as possible)?
Anything else we need to know?
No response