This is similar to issue #34, except using the construction NOT LIKE. Please note that using a regular LIKE, i.e. without negation, does work.
Example:
CREATE TABLE not_working(
value TEXT CONSTRAINT "value" CHECK(value NOT LIKE "prefix%")
);
CREATE TABLE working(
value TEXT CONSTRAINT "value" CHECK(value LIKE "prefix%")
);
INSERT INTO not_working( value ) VALUES( "a" );
INSERT INTO working( value ) VALUES( "prefixa" );
-- INSERT INTO NotWorking( value ) VALUES( "prefixb" );
-- INSERT INTO Working( value ) VALUES( "b" );
I'm using the test build posted in the comment by @justinclift in issue #34 on Windows 7.
This is similar to issue #34, except using the construction
NOT LIKE. Please note that using a regularLIKE, i.e. without negation, does work.Example:
I'm using the test build posted in the comment by @justinclift in issue #34 on Windows 7.