Ladies and gentlemen, check your assumptions

I spent some time earlier this week trying to debug a permissions problem in Drupal. After a lot of head-scratching, it turned out that Drupal assumes that when you run INSERT queries sequentially on a table with an auto_increment integer column, the values that are assigned to this column will also be sequential, ie: 1, […]