Is it just me, or is Sqlite3 goofy?

[Magnus Lycka]

Paul Boddie wrote:
> To be fair, that text originates in section 12.3, referring to input
> parameters to procedures. Meanwhile, the following text (subclause
> 13.8, "<insert statement>") appears to be more pertinent:
> 
> "If the data type of the target identified by the i-th <column name> is
> an exact numeric type, then the data type of the i-th item of the
> <insert statement> shall be an exact numeric type."

And SQLite behaves as expected if you provide a numeric value
to a numeric column, right? In other words, it complies to that
clause.

Does the spec state how the database engine should behave if the
client breaks the requirements for insert? I guess that this is
implementation dependent.