[h2] Performance impact of repeated select on an empty table

2018-01-17 Thread Ahsan Fayyaz
Hi, I was wondering what sort of performance impact would I be seeing or even how to measure it. I have thread which is repeatedly every 2 sec hammering an event table with a select statement like "select * from myEventTable limit 10 offset 0". Mostly if the table is empty what is the

[h2] BUG: Broken ROWNUM in h2 1.4.196

2018-01-17 Thread ibilous
ROWNUM expression gives different results in H2 version 1.4.192 and 1.4.196 This script: create table Tab1 (name VARCHAR2(320)); INSERT INTO Tab1(name) VALUES ('abc'); INSERT INTO Tab1(name) VALUES ('abc'); INSERT INTO Tab1(name) VALUES ('xyz'); INSERT INTO Tab1(name) VALUES ('xyz'); select

[h2] Re: Problem with TRACE_LEVEL_FILE option

2018-01-17 Thread Sylvain Palominos
Hi again, Does anyone have an idea if it is a normal behaviour or a bug ? -- 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, send an email to

Re: [h2] Re: Problem with TRACE_LEVEL_FILE option

2018-01-17 Thread Noel Grandin
that sounds like a bug, probably just something nobody has tried to do before -- 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, send an email to

[h2] Re: BUG: broken ROWNUM in h2 v.1.4.196

2018-01-17 Thread Ivan
Evgenij, I`m happy to know bug fix is on the way. Looking forward for Spring Boot to include that h2 release. Then, my project can be upgraded too. H2 is being used for functional regression tests in Oracle-compatibility mode. It is most suitable engine I have seen before. Thank you, Ivan.

[h2] Re: BUG: broken ROWNUM in h2 v.1.4.196

2018-01-17 Thread Ivan
Confirmed. GIT "master" revision 9ba6f143e2e4ff142474d46ab555b4cdb98a0108 on https://github.com/h2database/h2database Result is positive: create table Tab1 (name VARCHAR2(320)); > INSERT INTO Tab1(name) VALUES ('abc'); > INSERT INTO Tab1(name) VALUES ('abc'); > INSERT INTO Tab1(name) VALUES

[h2] Re: BUG: broken ROWNUM in h2 v.1.4.196

2018-01-17 Thread Evgenij Ryazanov
It's already fixed it git. -- 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, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

[h2] Re: MVStore - Check Unique Loops 1000s times per insert

2018-01-17 Thread Evgenij Ryazanov
TestAll with this two changes completes as usual. -- 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, send an email to h2-database+unsubscr...@googlegroups.com. To post to this