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

great, thank you! среда, 26 октября 2016 г., 17:23:37 UTC+3 пользователь 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

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

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,

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

четверг, 20 октября 2016 г., 17:30:39 UTC+3 пользователь Noel Grandin написал: > > > > On 2016/10/19 2:24 PM, Filipp Zhinkin wrote: > > > > Suppose we have following table: > > > > CREATE TABLE test_table ( > > id INT, > >

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

duplicate could be detected at least in MVPrimaryIndex which will contain all columns. :( Best regards, Filipp Zhinkin. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails fro