SQLite Forum

3.36.0 .expert doesn't work with REGEXP
Login

3.36.0 .expert doesn't work with REGEXP

(1) By anonymous on 2021-09-10 21:55:11 [link] [source]

I am attempting to use .expert on a database that uses REGEXP to CHECK text fields, but .expert fails with an error.

example:
>CREATE TABLE "foo" (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "value" TEXT NOT NULL
    CHECK("value" REGEXP '^[a-z]+$')
);
>.expert

result:
sqlite3_expert_new: no such function: REGEXP

The error occurs whether I use the built-in REGEXP or .load the pcre extension.

If the CHECK() is omitted then following the above with
>SELECT "id" FROM "foo" WHERE "value" IN ('a', 'bcd');
returns an INDEX suggestion.

This seems to be a bug. If not then please consider it a feature request.

(2) By Larry Brasfield (larrybr) on 2021-09-10 23:58:22 in reply to 1 [source]

This diagnosis and recommendation would probably help.