Function where_add_regex

src/store/store.c:2459–2470

Append a regex WHERE clause for a column (case-sensitive or insensitive). */

/* Append a regex WHERE clause for a column (case-sensitive or insensitive). */
static void where_add_regex(char *where, int where_sz, int *wlen, int *nparams,
                            search_bind_t *binds, int *bind_idx, const char *column,
                            const char *pattern, bool case_sensitive) {
    char buf[CBM_SZ_128];
    if (case_sensitive) {
        snprintf(buf, sizeof(buf), "%s REGEXP ?%d", column, *bind_idx + SKIP_ONE);
    } else {
        snprintf(buf, sizeof(buf), "iregexp(?%d, %s)", *bind_idx + SKIP_ONE, column);
    }
    *wlen = where_append(where, where_sz, *wlen, nparams, buf);
    where_bind_text(binds, bind_idx, pattern);
}

/* Prepend LIKE pre-filter conditions for literal segments of a regex pattern.
 * The idx_nodes_name index satisfies LIKE '%literal%', cutting the rows that