Documentation Source Text

Check-in [f9d830d206]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Change the documented behavior of casting a large real into an integer.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: f9d830d20643f88d5b46cf5a6ba322e0e8e6eb7a
User & Date: drh 2013-11-26 21:07:30
Context
2013-11-27
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
2013-11-26
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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]