Re: CREATE TRIGGER ... QUEUE is not documented

Done. Documentation reads "QUEUE is implemented for syntax compatibility with HSQL and has no effect." On 2013-05-02 16:10, Gili wrote: Hi, Can you please document the QUEUE INT parameter of http://www.h2database.com/html/grammar.html#create_trigger? Thank you, Gili -- You received this mess

CREATE TRIGGER ... QUEUE is not documented

Hi, Can you please document the QUEUE INT parameter of http://www.h2database.com/html/grammar.html#create_trigger? Thank you, Gili -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it

Large scanCount when using IN on composite primary key

Hi, I am trying to improve performance of SQL queries on a H2 database. One query remains slow though: a select with a IN clause on a composite primary key. Testscript to create/fill/select: > DROP TABLE IF EXISTS TestTable; > > CREATE TABLE IF NOT EXISTS TestTable ( > FirstCol VARCHAR(2048)