Hacker News Reader

Comment by dotancohen | Hacker News Reader

I see that you defined the `dkim` column as NOT NULL. So what happens when an email message does not contain the Dkim-Signature header?

Probably something like

  Error: stepping, NOT NULL constraint failed: messages.dkim (19)

because, unlike MySQL, SQLite apparently returns SQL NULL for JSON null value.

As hun3 said, it would throw an error. My mistake in the quick example I put together. I just noticed an unbalanced () as well. Whoops.