From: John V. S. <js...@gm...> - 2008-04-18 04:47:58
|
This has always been a pain. Since the project has been inactive in Sourceforge for quite a while now, I've forked it into perforce.eigenbase.org, and written up instructions for maintenance: http://pub.eigenbase.org/wiki/SqllineDocs For now, I kept the overall structure fairly close to how it was before, but there are some optimizations we can make if anyone is going to spend a lot of time with enhancements. I also ran Jalopy on the source code. As part of the change, I also enhanced sqlline with a new !set rowlimit 100 So you can limit the number of rows coming back from a query (like the limit clause in MySQL). It uses Statement.setMaxRows, which was already implemented in Farrago JDBC. !set rowlimit 0 means unlimited (same as the JDBC convention). JVS |