Re: [h2] Re: Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

2016-10-26 Thread Stuart Goldberg
Please take a look at my post a number of months ago entitled "Timeout trying to lock table". This is the same problem! There is a bug somewhere. This issue continues to plague us intermittently. On Monday, September 12, 2016 at 2:38:13 AM UTC-4, Dave Anonymous wrote: > > > Sorry, but I'm not go

Re: [h2] INSERT .. ON DUPLICATE KEY UPDATE may not work depending on table indexes order and columns participating in statement

2016-10-26 Thread Noel Grandin
thanks for the good test cases, this has been fixed on master -- 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

Re: [h2] INSERT .. ON DUPLICATE KEY UPDATE may not work depending on table indexes order and columns participating in statement

2016-10-26 Thread Filipp Zhinkin
Just reordered primary key and unique constraint declarations and it stopped working: DROP TABLE test_table IF EXISTS; CREATE TABLE test_table (id INT, dup INT, counter INT, PRIMARY KEY(id), UNIQUE(dup)); INSERT INTO test_table (id, dup, counter) VALUES (1, 1, 1); INSERT INTO test_table (id, dup