tobiasschulz / csharp-sqlite

Automatically exported from code.google.com/p/csharp-sqlite
Other
0 stars 0 forks source link

Exception with a OR in sql commande #84

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
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 commented 9 years ago
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

GoogleCodeExporter commented 9 years ago
Works under 3.7.5

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