Import SQLite 3.10.2.

third_party/sqlite/src/test/e_expr.test

 # 2010 July 16
 #
 # 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 1408 matching lines @@
   INSERT INTO t3 VALUES(X'555655', '1.23abc', 4.5);
   SELECT typeof(a), a, typeof(b), b, typeof(c), c FROM t3;
 } {blob UVU text 1.23abc real 4.5}
 do_execsql_test e_expr-27.1.2 {
   SELECT 
     typeof(CAST(X'555655' as TEXT)), CAST(X'555655' as TEXT),
     typeof(CAST('1.23abc' as REAL)), CAST('1.23abc' as REAL),
     typeof(CAST(4.5 as INTEGER)), CAST(4.5 as INTEGER)
 } {text UVU real 1.23 integer 4}
 
-# EVIDENCE-OF: R-27225-65050 If the value of <expr> is NULL, then
-# the result of the CAST expression is also NULL.
+# EVIDENCE-OF: R-32434-09092 If the value of expr is NULL, then the
+# result of the CAST expression is also NULL.
 #
 do_expr_test e_expr-27.2.1 { CAST(NULL AS integer) } null {}
 do_expr_test e_expr-27.2.2 { CAST(NULL AS text) }    null {}
 do_expr_test e_expr-27.2.3 { CAST(NULL AS blob) }    null {}
 do_expr_test e_expr-27.2.4 { CAST(NULL AS number) }  null {}
 
-# EVIDENCE-OF: R-31076-23575 Casting a value to a <type-name> with
-# no affinity causes the value to be converted into a BLOB.
+# EVIDENCE-OF: R-43522-35548 Casting a value to a type-name with no
+# affinity causes the value to be converted into a BLOB.
 #
 do_expr_test e_expr-27.3.1 { CAST('abc' AS blob)       } blob abc
 do_expr_test e_expr-27.3.2 { CAST('def' AS shobblob_x) } blob def
 do_expr_test e_expr-27.3.3 { CAST('ghi' AS abbLOb10)   } blob ghi
 
 # EVIDENCE-OF: R-22956-37754 Casting to a BLOB consists of first casting
 # the value to TEXT in the encoding of the database connection, then
 # interpreting the resulting byte sequence as a BLOB instead of as TEXT.
 #
 do_qexpr_test e_expr-27.4.1 { CAST('ghi' AS blob) } X'676869'
@@ skipping 443 matching lines @@
 } {true}
 do_execsql_test e_expr-37.9 {
    SELECT CASE WHEN -0.1 THEN 'true' ELSE 'false' END;
 } {true}
 do_execsql_test e_expr-37.10 {
    SELECT CASE WHEN '1english' THEN 'true' ELSE 'false' END;
 } {true}
 
 
 finish_test