odc icon indicating copy to clipboard operation
odc copied to clipboard

[Bug]: fail to export result set for sql with * and nvl function

Open LuckyPickleZZ opened this issue 1 year ago • 0 comments

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. image

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

LuckyPickleZZ avatar May 09 '24 03:05 LuckyPickleZZ