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?

3 comments
Comment actions Permalink

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?

0
Comment actions Permalink

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

0
Comment actions Permalink

Could you please file new issue at https://youtrack.jetbrains.com/issues/DBE with screenshot, showing the steps to reproduce? Thanks.

0

Please sign in to leave a comment.