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.