[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