SQLite Version 3.2.2.
Is this a bug, or is my SQL that bad?
Query 1:
SELECT * FROM table1, table2
WHERE (table1.value LIKE "%value%" AND table1.table2_id = table2.id);
This query works perfectly, can't fault it.
But when I do this, SQLite locks out (Command line interface, and PHP5)
Query 2:
SELECT * FROM table1, table2
WHERE ((table1.value LIKE "%value%" AND table1.table2_id = table2.id);
OR (table1.value LIKE "%different_value%" AND table1.table2_id =
table2.id));
This query (and even more complex versions of it) works in MySQL (Haven't
tried another DB yet) and I'm trying to migrate to SQLite, this is really
holding me back.
Any ideas, I'm totaly stuck, currently trying to see if I can get the same
results using another piece of SQL that SQLite will like, probably going to
end up with a compound statement (UNION most likely I think).