On Tue, May 27, 2014 at 8:58 AM, Mike Appenzellar <mappenzel...@gmail.com>wrote:
> Just lately, I am having to change my SQL statements to retrieve data.
> Queries that use to be set to things such as WHERE some_int_field =
> other_int_field is now forcing me to do WHERE some_int_field LIKE
> other_int_field which is obviously slower. Any thoughts? Both fields are
> set as integer. Would be be causing this? I also outputed the length of the
> fields and they are correct so it doesn't appear to be a hidden
> space/character issue.
>
What do these queries show you:
SELECT DISTINCT typeof(some_int_field) FROM table;
SELECT quote(some_int_field) FROM table WHERE typeof(some_int_field)
NOT IN ('null','integer');
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
