[sqlite] SELECT CAST('' AS INTEGER) returns zero instead of null

2015-12-14 Thread Anthony Damico
hi, sql standard says to strip whitespace and then convert.  "" coercing to
zero instead of NULL strikes me as very odd..  thanks

some code here-


[sqlite] i think this is a bug in sqlite? thanks

2015-12-10 Thread Anthony Damico