gistfile1.txt

sql> select count(*) from matchlineuppenaltytaker ;
22
sql> select * from matchlineuppenaltytaker limit 3 ;
 PLAYERID          POS  LINEUPNAME
---------  -----------  ----------
553720172  -1509883904  [null]
553720273   -838795264  [null]
553713664               [null]

Fetched 3 rows.
sql> select * from matchlineuppenaltytaker limit 3 offset 1 ;
May 30, 2020 11:50:38 A.M. org.hsqldb.persist.Logger logInfoEvent
INFO: /Users/sebastienlecallonnec/dev/HO/db/database.data getFromFile out of mem 12556
May 30, 2020 11:50:38 A.M. org.hsqldb.persist.Logger logSevereEvent
SEVERE: /Users/sebastienlecallonnec/dev/HO/db/database.data getFromFile failed 12556
org.hsqldb.HsqlException: java.lang.OutOfMemoryError: Java heap space
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
	at org.hsqldb.persist.DataFileCache.get(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.getRight(Unknown Source)
	at org.hsqldb.index.IndexAVL.next(Unknown Source)
	at org.hsqldb.index.IndexAVL.next(Unknown Source)
	at org.hsqldb.index.IndexAVL$IndexRowIterator.getNextRow(Unknown Source)
	at org.hsqldb.index.IndexAVL$IndexRowIterator.next(Unknown Source)
	at org.hsqldb.RangeVariable$RangeIteratorMain.findNext(Unknown Source)
	at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)
	at org.hsqldb.QuerySpecification.buildResult(Unknown Source)
	at org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)
	at org.hsqldb.QuerySpecification.getResult(Unknown Source)
	at org.hsqldb.StatementQuery.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at org.hsqldb.cmdline.SqlFile.processSQL(Unknown Source)
	at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source)
	at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)
	at org.hsqldb.cmdline.SqlTool.objectMain(Unknown Source)
	at org.hsqldb.cmdline.SqlTool.main(Unknown Source)
Caused by: java.lang.OutOfMemoryError: Java heap space

May 30, 2020 11:50:38 A.M. org.hsqldb.cmdline.SqlTool objectMain
SEVERE: SQL Error at '<stdin>' line 7:
"select * from matchlineuppenaltytaker limit 3 offset 1 "
java.lang.OutOfMemoryError: Java heap space