a few days ago Adam posted the following solution to my question about
how to find the lowest free number in an incomplete list of integer
It does exactly what I wanted it to do, but: When I lock the table
with "LOCK TABLES test WRITE" beforehand, and then execute the above
query, I get an error saying (from memory): "...Error HY000: tables
were not locked with LOCK TABLES".
Trying to find out about the cause of this, I found that the following
part of the query executes successfully (again from memory):
(select id+1 as incid ...