SQLite Forum

Table constraints accepted without comma
Login
Regarding: 
>...second "check" works 

FWIW, **both** check constraints work for me.  

<code>
SQLite version 3.37.0 2021-11-27 14:13:22
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table test (
   ...> id int,
   ...> check (id > 1)
   ...> check (id < 10));
sqlite> insert into test values (1);
Error: stepping, CHECK constraint failed: id > 1 (19)
sqlite> insert into test values (11);
Error: stepping, CHECK constraint failed: id < 10 (19)
</code>

And, as you might expect, both constraints also work if one **does** include a comma.  I guess if this is a bug, it seems a rather benign one.