On 5/27/15, gunnar <gharms at hiqinvest.nl> wrote: > Hi, > > Sometimes when I execute (from the sqlite_shell program) a select-query > that contains a correlated subquery that query gets 'stuck'. It outputs > part of the expected results and then doesn't come back to command > prompt and also doesn't output any more records. > > I suspect it is because another process is inserting records in the > table from which I try to select during the time that my query runs.
Transactions are isolated. So I very much doubt this theory. -- D. Richard Hipp drh at sqlite.org