>Could you show us the constraint you feel disallows those things ? We might be able to find a loophole in the exact way you phrased it.
Also, could someone explain to me what EMPTY means here ? I've seen '' called "empty string" but it doesn't seem to be normal SQL language. ----------------------------------------------------------------------------- Simon You are correct. When I say "empty" I am meaning "empty string". My apologies if my nomenclature is incorrect here in terms of SQL speak. Regarding the constraint, to column is set as INTEGER NOT NULL, but because of SQLite's dynamic typing system (something I forget about), empty strings can be passed into INTEGER columns as they are technically not null. Now if a non numeric text would have made it into an INTEGER field, we would have dissected the issue a lot faster (and there is almost no way that would have happened anyway). Because it was an empty string value that made it in there, it appeared as a NULL to us when we tried reading the database as our database reader expected an INTEGER. It took as a while to figure out that the NULL value wasn't really NULL, but an empty string value sitting in an INTEGER field. I definitely know to look out for this now. From: Simon Slavin <slav...@bigfraud.org> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Not Null Constraint Issue? Message-ID: <46053091-b9ab-43c4-b7f9-c89d70986...@bigfraud.org> Content-Type: text/plain; charset=us-ascii On 17 Jan 2020, at 6:39pm, Justin Gielski <justin.giel...@gmail.com> wrote: > After looking into the issue a bit more, it appears the INTEGER value was actually saved into the DB as an EMPTY not a NULL, which is currently allowed by the database constraints. Could you show us the constraint you feel disallows those things ? We might be able to find a loophole in the exact way you phrased it. Also, could someone explain to me what EMPTY means here ? I've seen '' called "empty string" but it doesn't seem to be normal SQL language. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
