[android-developers] Re: multiple parameters with rawQuery in sqlite = BUG

On Mar 10, 5:29 pm, Mark Murphy <mmur...@commonsware.com> wrote:
>
> I'm not aware of any. I'm not even sure it's Android that is doing the ?
> replacement -- the Ruby SQLite library has the same feature, so it might
> be handled by SQLite itself.
>

It could certainly be in SQlite or its JDBC driver. .NET SQLite
provider worked with the exact same query string - but it had typed
parameters, not an array of strings.

Given the nature of SQLite, I wouldn't be surprised if it is casting
the column to a string and doing a string comparison.

If this is the case, to be fixed, I'd have to request a new signature
for rawQuery.

rawQuery (String sql, Object... params)

If I come up with a smaller case, I'll post it. It is 100%
reproducible with FLOAT columns and inequality in my code.

Nathan

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en