[sqlite] Question about checking table requirements on INSERT into a table

Hi sqlite-users, When I was toying around with sqlite in python, I ran into an interesting caveat when INSERTing into a table where an unsupported data type didn't throw an exception/error from sqlite's perspective. In the example below, I expected an insert of a text field to an integer

Re: [sqlite] Question about checking table requirements on INSERT into a table

On 4/24/2014 1:03 PM, yaneurabeya . wrote: Being able to INSERT and print out 'a' above caught me off guard a bit. Is this programmer error when I ran CREATE TABLE or the INSERT (this is the most likely answer, but I wanted to be sure), or is this by design? By design. For details,

Re: [sqlite] Question about checking table requirements on INSERT into a table

On Thu, Apr 24, 2014 at 10:23 AM, Igor Tandetnik i...@tandetnik.org wrote: On 4/24/2014 1:03 PM, yaneurabeya . wrote: Being able to INSERT and print out 'a' above caught me off guard a bit. Is this programmer error when I ran CREATE TABLE or the INSERT (this is the most likely