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
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
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
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
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.
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
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
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