Bad queries after IDEA update
Answered
Hi,
I've just updated my IDEA to 2016.2.3.
Now, when I try to simply view a database table (Oracle) I'm receiving bad results. The problem is in the query generated by IDEA.
SELECT t.* FROM SCHEME.TABLE t WHERE ROWNUM <= 501 ORDER BY SOME_ID ASC
See where the problem is? The table has thousands of rows but IDEA selects 500 rows, which is OK, but THEN calls ORDER command. Therefore I get the wrong result.
Is it a bug or what?
Please sign in to leave a comment.
Hello,
There was an issue: https://youtrack.jetbrains.com/issue/DBE-3032 Should be fixed in IDEA 2016.2.4 version or 2016.3 EAP Could you check it?
I've updated my IDEA to 2.4 but the same result. Not fixed.
IntelliJ IDEA 2016.2.4
Build #IU-162.2032.8, built on September 9, 2016
Could you please file new issue at https://youtrack.jetbrains.com/issues/DBE with screenshot, showing the steps to reproduce? Thanks.