ios - Strange SQLite behavior. Different results; same query -

ios - Strange SQLite behavior. Different results; same query -

i have query like:

select id,name,province,enabled customers enabled = 1 , (name "%to%" or province "%to%");

using same database on mac or ipad gives me different results.

on mac works supposed , returns 11 records, on ipad returns 55 records ¿? (and strangely of them have field enabled = 0) strange.

ipad app done in objective c xcode6

i suppose sqlite3 not same version on both devices, , doesn't interpret in same way parenthesis priority.

i suspect ios rendition has problem in sql, perhaps missing parentheses. example, next sql may include results enabled not equal 1:

select id,name,province,enabled customers enabled = 1 , name "%to%" or province "%to%";

make sure include parentheses shown in original question.

ios objective-c sqlite3