This is a re-post of a problem reported by bafilius on July 16 22:10. I am posting my reply separately here for reasons of 'currency'.
I can confirm a similar error: I have the same database running under MS SQL, MySQL, and SQLite3. [The application 'Web Bones' can be viewed at georgiansoftware.com user/password 'Guest'/'Guest2009'.] I am using SQLite Manager to view and administer the database (32 tables, 17 views). All my sql statements have been tested as error-free in SQLite Manager. Initially, I thought Android was having a problem 'starting my activity' in response to an entry in an AutoCompleteTextview. But, when I hard-coded the view query to happen immediately following an all-table query, the error was repeatable!
Did you ever find a solution to your problem other than to re-write the query to avoid the use of the SQLite view?