Hi,
Squirrel SQL can limit rows in SQL result. My impression was that it
automagically adds database related row limiting SQL commands such as
LIMIT 10 for MSQ SQL and SELECT ... where ROWNUM <= 10 for Oracle. It is
not the case, Squirrel uses Statement.setMaxRows() and javadoc says:
Sets the limit for the maximum number of rows that any ResultSet object
generated by this Statement object can contain to the given number. If
the limit is exceeded, the excess rows are silently dropped.
So my question is - is there a plugin or something alike that can
rewrite the selects with true limiting so average user will not kill db
server with select *? Does the plugin architecture allow to write such
plugin?
Kind regards, Jan
|