Project

General

Profile

Actions

Feature proposal #8228

closed

JSON searching without a row limit is unreliable

Added by krileon about 4 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
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

Also available in: Atom PDF