[h2] Re: ON DUPLICATE KEY misses update for composed primary key

2018-02-23 Thread Ján Zahornadský
Many thanks, I no longer observe the missed updates. On Friday, 23 February 2018 13:03:57 UTC+1, Evgenij Ryazanov wrote: > > A fix was merged, you can download the latest sources and build jar by > yourself to test it. > > https://github.com/h2database/h2database >

[h2] Re: ON DUPLICATE KEY misses update for composed primary key

2018-02-23 Thread Evgenij Ryazanov
A fix was merged, you can download the latest sources and build jar by yourself to test it. https://github.com/h2database/h2database http://www.h2database.com/html/build.html#building -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

[h2] Re: ON DUPLICATE KEY misses update for composed primary key

2018-02-23 Thread Evgenij Ryazanov
Hello. No, such result is not expected. I found a reason and I'll send a pull request with fix later. -- 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] ON DUPLICATE KEY misses update for composed primary key

2018-02-23 Thread Ján Zahornadský
Hi All, I'm encountering missed updates by H2. For example, CREATE TABLE test ( id INT NOT NULL, seq INT NOT NULL, str TEXT PRIMARY KEY (id, seq) ) INSERT INTO test (id, seq, str) VALUES (1, 0, 'Old Value'), (2, 1, 'first'), (2, 2, 'second'); After these steps, the database