SQLite Forum

Is sqldiff meant to detect "NOT NULL" differences?
Login
I was playing around with sqldiff while developing some schema tests.

I noticed that the tool does not raise errors if a table/column in the two given databases differ in "NOT NULL".

Here is a simple example run that demonstrates the problem:

```
 mshamma@shamma  /tmp  sqlite3
SQLite version 3.32.3 2020-06-18 14:16:19
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open not_null.db
sqlite> CREATE TABLE groups (
   ...>    group_id INTEGER PRIMARY KEY,
   ...>    name TEXT NOT NULL
   ...> );
sqlite> .open null.db
sqlite> CREATE TABLE groups (
   ...>    group_id INTEGER PRIMARY KEY,
   ...>    name TEXT
   ...> );
sqlite> ^D
 mshamma@shamma  /tmp  sqldiff --schema not_null.db null.db
 mshamma@shamma  /tmp 
``` 

Is it expected that sqldiff does not complain about this difference? Alternatively, is this a known bug tracked anywhere?