SQLite Forum

Why Sqlite parse error: line 1:94: expecting RPAREN, found 'OR' in CHECK constraint?
Login
Sorry if I did not provide my information!

The string shown in the error message is indeed exactly the string I used to create the database, except I also have `IF NOT EXISTS` after `CREATE TABLE`, which for some reason is excluded from the error message.

What I did when I said "When I open my database ..." really is just calling `sqlitebrowser /path/to/database.db` from the terminal. This `sqlitebrowser` is a standard Ubuntu package, where I use the one from Ubuntu 20.04 x86_64:

```
#> apt-cache show sqlitebrowser
Package: sqlitebrowser
Architecture: amd64
Version: 3.11.2-1build2
Priority: extra
Section: universe/devel
Origin: Ubuntu
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Original-Maintainer: Arto Jantunen <viiru@debian.org>
[...]
```