I suppose you forgot to mention that you are doing it on an Aria table, concurrently, simultaneously from several threads?
no, i'm considering any engine, just to know when it's possible to a insert return duplicate error, why, how, etc... i don't see a standard here, i didn't see a standard in others databases too, that's why i'm asking to community