Simple test case: CREATE TABLE TEST(ID BIGINT PRIMARY KEY, NAME VARCHAR); CREATE UNIQUE INDEX NAME_IDX ON TEST(NAME); INSERT INTO TEST(ID) SELECT X FROM SYSTEM_RANGE(1, 10000);
Each new row causes iterations over all previous in *checkUnique()*. I don't know how NULLS FIRST and NULLS LAST can interfer with this method. But I also don't unerstand the reason for loop here, key iterator should return matched row or row that greater than our and probably we should stop check in this case. -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
