Project

General

Profile

Actions
Copy link

Feature proposal #8228

closed

JSON searching without a row limit is unreliable

Feature proposal #8228: JSON searching without a row limit is unreliable

Added by krileon about 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
2.0.0
Start date:
09 November 2020
Due date:
% Done:

100%

Estimated time:

Description

If you do not set a limit then the search behavior falls back to a generic * pathing. This isn't reliable with searching since that only works in comparing against the number of rows returned. It won't search inside those rows. Try using JSON_CONTAINS instead, which likely requires improvements to core CB to do this.

Actions
Copy link

Also available in: PDF Atom