3.36.0 .expert doesn't work with REGEXP
(1) By anonymous on 2021-09-10 21:55:11 [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 [link] [source]
This diagnosis and recommendation would probably help.