Thanks for the fix version 2.2.222.
Don't know if it will work for me, because I run with that revision into a
performance problem.
One of my unit tests runs now extremely long and it seems that much memory
get allocated.
Can't send you the complete code but I isolate it to the SQL statements and
looks like:
CREATE TABLE IF NOT EXISTS A (number VARCHAR(128) not NULL, intent INT not
NULL, objID VARCHAR(30) not NULL, objType SMALLINT not NULL, PRIMARY KEY
(number,intent,objID,objType));
CREATE INDEX IF NOT EXISTS A_IDX ON A(objType,objID,intent);
CREATE INDEX IF NOT EXISTS A_type_IDX ON A (objType);
for (int loop = 0, number = 0; loop < 300; ++loop){
DROP TABLE IF EXISTS B;
CREATE TABLE IF NOT EXISTS B (number VARCHAR(128) not NULL, intent INT
not NULL, objID VARCHAR(30) not NULL, objType SMALLINT not NULL, PRIMARY
KEY (number,intent,objID,objType));
CREATE INDEX IF NOT EXISTS B_IDX ON B(objType,objID,intent);
for (int i = 0; i < 100; ++i) {
++number;
MERGE INTO B (number,intent,objID,objType) VALUES
(Integer.toString(number),1, Integer.toString(number), 1)
}
DELETE FROM A T WHERE EXISTS (SELECT NULL from A S WHERE T.objID=S.objID
AND T.objType=S.objType AND T.intent=S.intent AND T.number<>S.number)
MERGE INTO A T USING (SELECT * FROM B) AS S ON T.objID=S.objID AND
T.objType=S.objType AND T.intent=S.intent AND T.number=S.number WHEN NOT
MATCHED THEN INSERT (objID, objType, number, intent) VALUES (S.objID,
S.objType, S.number, S.intent);
DROP TABLE B CASCADE
}
If run with the previous versions 1.4, 2.1 and 2.2.220 it's finished after
some seconds.
With the 2.2.222 it takes longer with each loop; don't finish after some
minutes.
Please take a look; thanks.
Thanks,
Jürgen
Andreas Reichel schrieb am Mittwoch, 23. August 2023 um 14:12:42 UTC+2:
> On Wed, 2023-08-23 at 08:09 -0400, Andrei Tokar wrote:
>
> This is a patch release, and AFAIK there are no incompatibilities with
> on-disk format of v.2.2.220, so hopefully it can be used as drop in
> replacement for 2.2.220 (and only 2.2.220!).
>
>
>
> Thank you very much.
> Just in case: We have amended H2MigrationTool for support of H2 2.2.222
> already.
>
> http://h2migrationtool.manticore-projects.com/
>
> Best regards
> Andreas
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/a9dde386-ec94-4beb-b13a-a2913f6e4311n%40googlegroups.com.
