Exception with a OR in sql commande

[GoogleCodeExporter]

What steps will reproduce the problem?
1. execute this request :

"SELECT * FROM localisations WHERE (search LIKE '" + prefix + "%' OR code LIKE 
'" + prefix + "%') LIMIT 10"

What is the expected output? What do you see instead?

Expected to work (autocompletion of cities command).

Throws an exception at :

Debug.Assert( 0 == usedAsColumnCache( pParse, i, i + n - 1 ) );

stack :

SELECT * FROM localisations WHERE (search LIKE 'p%' OR code LIKE 'p%') LIMIT 10
Silverlight AppDomainAssertionÉchec d'assertion
à DefaultTraceListener.AssertFailure(String File, Int32 Line, String Expr)
à DefaultTraceListener.Fail(String message, String detailMessage)
à DefaultTraceListener.Fail(String message)
à TraceInternal.Fail(String message)
à TraceInternal.Assert(Boolean condition)
à Debug.Assert(Boolean condition)
à Sqlite3.sqlite3GetTempRange(Parse pParse, Int32 nReg)
à Sqlite3.sqlite3ExprCodeTarget(Parse pParse, Expr pExpr, Int32 target)
à Sqlite3.sqlite3ExprCodeTemp(Parse pParse, Expr pExpr, Int32& pReg)
à Sqlite3.sqlite3ExprIfFalse(Parse pParse, Expr pExpr, Int32 dest, Int32 
jumpIfNull)
à Sqlite3.sqlite3ExprIfFalse(Parse pParse, Expr pExpr, Int32 dest, Int32 
jumpIfNull)
à Sqlite3.codeOneLo

What version of the product are you using? On what operating system?

latest version of community.csharpsqlite.wp

Original issue reported on code.google.com by toutankh...@gmail.com on 6 Jan 2011 at 1:53

[GoogleCodeExporter]

Unable to reproduce, will retest under the 3.7.5 release

Original comment by noah.hart@gmail.com on 17 Feb 2011 at 1:58

• Changed state: Reviewed
• Added labels: Milestone-3.7.5

[GoogleCodeExporter]

Works under 3.7.5

Original comment by noah.hart@gmail.com on 28 Feb 2011 at 2:41

• Changed state: Fixed