Cezary H. Noweta wrote: > On 2016-03-14 12:03, Clemens Ladisch wrote: >> The documentation is quite clear that INTEGERs have 64 bits. So trying >> to use integers above 9223372036854775807 is something that is better >> not to be done. > > How could somebody use integers above 9223372036854775807 if they do not > exist?
Not at all. This is why I wrote "trying". > Is your opinion Why would my opinion matter, as opposed to what SQLite actually does? > that ``SELECT CAST(col AS INTEGER);'' should return (not so) random > result set, and receiving any INTEGER should mean that a source string > could have trillion or more possible values? The documentation does not specify how the textual representation of an out-of-range integer is to be converted, so anything SQLite does can be considered correct. Regards, Clemens
