[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-

https://github.com/rstats-db/RSQLite/issues/127


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

2015-12-10 Thread Anthony Damico
https://github.com/rstats-db/RSQLite/issues/125#event-488337588