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?