On http://www.sqlite.org/lang_expr.html#castexpr the text reads:
> A CAST expression of the form "CAST(<expr> TO <type-name>)" is used to > convert the value of <expr> to a different storage class specified by > <type-name>. Note the "TO" there; the expression syntax diagram (http://www.sqlite.org/syntaxdiagrams.html#expr) correctly shows CAST uses "AS". Can the documentation be corrected to read: > A CAST expression of the form "CAST(<expr> AS <type-name>)" is used to > convert the value of <expr> to a different storage class specified by > <type-name>. instead? The same syntax error has started to creep into the change log reports too. For the 3.8.2 news entry (http://www.sqlite.org/news.html#2013_12_06): > In other words, CAST(+99.9e99 to INT) would yield -9223372036854775808. > […] > Hence, CAST(+99.9e99 to INT) now returns +9223372036854775807. -- Martijn Pieters www.zopatista.com _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
