Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Change the documented behavior of casting a large real into an integer.|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2013-11-26 21:07:30|
|01:26||Add documentation for the SQLITE_WIN32_HEAP compile-time option. Fix typos in the change log. check-in: 907e8cfb73 user: drh tags: trunk|
|21:07||Change the documented behavior of casting a large real into an integer. check-in: f9d830d206 user: drh tags: trunk|
|17:47||Add the double-to-int casting change to the change log. Set the release date (tenatively) to 2013-12-10. check-in: 45cab1f685 user: drh tags: trunk|
Changes to pages/lang.in.
1993 1993 the value that can be interpreted as an integer number is extracted from 1994 1994 the TEXT value and the remainder ignored. ^Any leading spaces in the 1995 1995 TEXT value when converting from TEXT to INTEGER are ignored. ^If there 1996 1996 is no prefix that can be interpreted as an integer number, the result 1997 1997 of the conversion is 0. 1998 1998 1999 1999 <p>^A cast of a REAL value into an INTEGER will truncate the fractional 2000 - part of the REAL. ^If a REAL is too large to be represented as an 2001 - INTEGER then the result of the cast is the largest negative integer: 2002 - -9223372036854775808. 2000 + part of the REAL. ^If a REAL is greater than the greatest possible signed 2001 + integer (+9223372036854775807) then the result is the greatest possible 2002 + signed integer and if the REAL is less than the least possible signed 2003 + integer (-9223372036854775808) then the result is the least possible 2004 + signed integer. 2003 2005 2004 2006 <tr> 2005 2007 <td> NUMERIC 2006 2008 <td> ^Casting a TEXT or BLOB value into NUMERIC first does a forced 2007 2009 conversion into REAL but then further converts the result into INTEGER if 2008 2010 and only if the conversion from REAL to INTEGER is lossless and reversible. 2009 2011 This is the only context in SQLite where the NUMERIC and INTEGER [affinities]