Import SQLite 3.8.7.4.

third_party/sqlite/src/test/cast.test

 # 2005 June 25
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 216 matching lines @@
 # ticket #2364.  Use full percision integers if possible when casting
 # to numeric.  Do not fallback to real (and the corresponding 48-bit
 # mantissa) unless absolutely necessary.
 #
 do_test cast-3.1 {
   execsql {SELECT CAST(9223372036854774800 AS integer)}
 } 9223372036854774800
 do_test cast-3.2 {
   execsql {SELECT CAST(9223372036854774800 AS numeric)}
 } 9223372036854774800
-do_test cast-3.3 {
+do_realnum_test cast-3.3 {
   execsql {SELECT CAST(9223372036854774800 AS real)}
 } 9.22337203685477e+18
 do_test cast-3.4 {
   execsql {SELECT CAST(CAST(9223372036854774800 AS real) AS integer)}
 } 9223372036854774784
 do_test cast-3.5 {
   execsql {SELECT CAST(-9223372036854774800 AS integer)}
 } -9223372036854774800
 do_test cast-3.6 {
   execsql {SELECT CAST(-9223372036854774800 AS numeric)}
 } -9223372036854774800
-do_test cast-3.7 {
+do_realnum_test cast-3.7 {
   execsql {SELECT CAST(-9223372036854774800 AS real)}
 } -9.22337203685477e+18
 do_test cast-3.8 {
   execsql {SELECT CAST(CAST(-9223372036854774800 AS real) AS integer)}
 } -9223372036854774784
 do_test cast-3.11 {
   execsql {SELECT CAST('9223372036854774800' AS integer)}
 } 9223372036854774800
 do_test cast-3.12 {
   execsql {SELECT CAST('9223372036854774800' AS numeric)}
 } 9223372036854774800
-do_test cast-3.13 {
+do_realnum_test cast-3.13 {
   execsql {SELECT CAST('9223372036854774800' AS real)}
 } 9.22337203685477e+18
 ifcapable long_double {
   do_test cast-3.14 {
     execsql {SELECT CAST(CAST('9223372036854774800' AS real) AS integer)}
   } 9223372036854774784
 }
 do_test cast-3.15 {
   execsql {SELECT CAST('-9223372036854774800' AS integer)}
 } -9223372036854774800
 do_test cast-3.16 {
   execsql {SELECT CAST('-9223372036854774800' AS numeric)}
 } -9223372036854774800
-do_test cast-3.17 {
+do_realnum_test cast-3.17 {
   execsql {SELECT CAST('-9223372036854774800' AS real)}
 } -9.22337203685477e+18
 ifcapable long_double {
   do_test cast-3.18 {
     execsql {SELECT CAST(CAST('-9223372036854774800' AS real) AS integer)}
   } -9223372036854774784
 }
 if {[db eval {PRAGMA encoding}]=="UTF-8"} {
   do_test cast-3.21 {
     execsql {SELECT CAST(x'39323233333732303336383534373734383030' AS integer)}
   } 9223372036854774800
   do_test cast-3.22 {
     execsql {SELECT CAST(x'39323233333732303336383534373734383030' AS numeric)}
   } 9223372036854774800
-  do_test cast-3.23 {
+  do_realnum_test cast-3.23 {
     execsql {SELECT CAST(x'39323233333732303336383534373734383030' AS real)}
   } 9.22337203685477e+18
   ifcapable long_double {
     do_test cast-3.24 {
       execsql {
         SELECT CAST(CAST(x'39323233333732303336383534373734383030' AS real)
                     AS integer)
       }
     } 9223372036854774784
   }
@@ skipping 36 matching lines @@
     SELECT a, CAST(a AS integer), a FROM t1;
   }
 } {abc 0 abc}
 do_test cast-4.4 {
   db eval {
     SELECT CAST(a AS integer), a, CAST(a AS real), a FROM t1;
   }
 } {0 abc 0.0 abc}
 
 finish_test