Good point, I saw a similar but wonkier behavior when testing with Sqlite.
I actually left this because you told me you used auto incremental + another key. How does that work for you?