delphi-orm icon indicating copy to clipboard operation
delphi-orm copied to clipboard

dorm.adapter.Sqlite3 ignores nullable columns

Open skamradt opened this issue 3 years ago • 0 comments

The nullable attribute is ignored on columns when performing an update or insert.

I believe the simplest path to get this working is to modify SetSqlite3ParameterValue to also pass the current field mapping and a similar substitution made for null as what is done for an empty blob.

In the test case that I came up with, I have an optional column which is a string and indexed unique. Not allowing empty string to be nulls would mean that the field is no longer optional and would generate a key violation.

skamradt avatar Sep 27 '21 14:09 skamradt