http://stackoverflow.com/questions/30643061/sqlite-db-browser-invalid-operand-for-regexp

I use DB Browser for SQLite version 3.6.0; SQLite Version 3.8.9. If I use regexp on a nullable column revision then invalid operand error is happened.

    SELECT brand,revision FROM TDevice WHERE TDevice.revision regexp '^ASUS$';

Below is the schema:

    CREATE TABLE `TDevice` (
    `id`    INTEGER NOT NULL,
    `brand` varchar(128) NOT NULL,
    `model` varchar(128) NOT NULL,
    `revision`  TEXT,
    PRIMARY KEY(id)
    );

After I replaced the NULL revision with empty string, then this issue fixed.

    UPDATE TDevice SET revision='' WHERE revision IS NULL

I assume regexp should behave as LIKE operator, because LIKE operator can accept NULL text.