The delta protocol contains the following sentence but check

Question

The delta protocol contains the following sentence but check constraints should allow `unknown` e g `1 gt null` in addition to `true` from SQL standard perspective in my understanding Can we update the protocol gt Rows in a table must satisfy CHECK constraints In other words evaluating the SQL expressions of CHECK constraints must return `true` for each row in a table cc < Slawomir Pajak>

Yuya Ebihara · Answer

< Allison Portis> < Scott Sandre Delta Lake > Could you confirm the above comment

ruslan · Answer

null shouldn t violate check constraints unless you put in a specific is `not null` check If Delta doesn t work this way this should be fixed breaking change to the previous behavior

Yuya Ebihara · Answer

Thanks for your response Filed <https github com delta io delta issues 1714>