|
From: Gerd W. <ger...@t-...> - 2014-06-21 07:33:11
|
Hi Jan, no, the Plugin interface does not yet support to do this. But I'm also sure that it wouldn't be hard to change the interface accordingly and implement the functionality in RDBMS specific Plugins. Please feel invited to do it (as well as anybody else reading this). You may either send patches of the changes to me or even better drop them here: http://sourceforge.net/p/squirrel-sql/patches/ Thanks Gerd Am 19.06.2014 10:46, schrieb jan_bar: > > 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 > > > ------------------------------------------------------------------------------ > HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions > Find What Matters Most in Your Big Data with HPCC Systems > Open Source. Fast. Scalable. Simple. Ideal for Dirty Data. > Leverages Graph Analysis for Fast Processing & Easy Data Exploration > http://p.sf.net/sfu/hpccsystems > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
