On 5 Jun 2011, at 3:35pm, Sidney Cadot wrote: > After some experimenting, it appears that ... > > * SELECT 1.0 / 0.0 yields NULL (where I would expect to see Inf) > * SELECT 1e10000 yields an actual IEEE-754 infinity, and it can be > stored in a table > * SELECT 1e10000 + 1e10000 yields Infinity, as expected according to IEEE-754. > * SELECT 1e10000 - 1e10000 yields NULL, where I would have expected to > see NaN in accordance with IEEE-754.
Note that according to SQL semantics, 'NULL' means 'I don't know'. So every value of all types matches with it. Not a useful test. You might learn something by matching with negative or positive underflows, but I have no clue how to express them. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
