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

On 14 Dec 2015, at 2:26pm, Anthony Damico wrote: > hi, sql standard says to strip whitespace and then convert. "" coercing to > zero instead of NULL strikes me as very odd.. thanks In your command SELECT CAST('' AS INTEGER) you explicitly tell it to CAST('' AS INTEGER) which means it has

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

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