On Fri, 2005-09-09 at 15:26 -0400, Sylvain Lafleur wrote: > Case: sqlite3.exe database_v3.db > select * from table1 inner join table2 on Table2.ID=Table1.Table2_ID inner > join table3 on Table3.code=Table2.code where table2.english_description like > '%furniture%' > > CPU goes to 96-100% and never returns until I end process. >
There may be something wrong with version 3.2.5. See, for example, ticket #1414: http://www.sqlite.org/cvstrac/tktview?tn=1414 But so far, nobody has sent me enough information to reproduce the problem. If somebody could please send me both a query and a database to run it on, I will look into the matter and hopefully get a fix out right away. -- D. Richard Hipp <[EMAIL PROTECTED]>
