Landry Norris10/07/2023, 9:41 AM
, I can see the last item (auto-incrementing id is around 2700), but if I select
WHERE textField LIKE (:text || '%')
, I get no results for the same input. Trying different parameters, it seems to never return any items with an id past ~1700. If I select
WHERE textField LIKE ('%' || :text || '%')
, the highest id I can find is ~1500. This makes me think there must be some timeout that causes it to stop the query and return only what it's found so far that matches.
WHERE textField LIKE (:text || '%') OR otherTextField LIKE ('%' || :text || '%')