Update sqlite to 3.7.3.

third_party/sqlite/src/test/expr.test

 # 2001 September 15
 #
 # 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 147 matching lines @@
 }
 
 test_expr expr-1.107 {i1=0} {(1<<63)%-1} 0
 test_expr expr-1.108 {i1=0} {1%0} {{}}
 test_expr expr-1.109 {i1=0} {1/0} {{}}
 
 if {[working_64bit_int]} {
   test_expr expr-1.110 {i1=0} {-9223372036854775807/-1} 9223372036854775807
 }
 
+test_expr expr-1.111 {i1=NULL, i2=8} {i1 IS i2} 0
+test_expr expr-1.112 {i1=NULL, i2=NULL} {i1 IS i2} 1
+test_expr expr-1.113 {i1=6, i2=NULL} {i1 IS i2} 0
+test_expr expr-1.114 {i1=6, i2=6} {i1 IS i2} 1
+test_expr expr-1.115 {i1=NULL, i2=8} \
+  {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
+test_expr expr-1.116 {i1=NULL, i2=NULL} \
+  {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
+test_expr expr-1.117 {i1=6, i2=NULL} \
+  {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} no
+test_expr expr-1.118 {i1=8, i2=8} \
+  {CASE WHEN i1 IS i2 THEN 'yes' ELSE 'no' END} yes
+test_expr expr-1.119 {i1=NULL, i2=8} {i1 IS NOT i2} 1
+test_expr expr-1.120 {i1=NULL, i2=NULL} {i1 IS NOT i2} 0
+test_expr expr-1.121 {i1=6, i2=NULL} {i1 IS NOT i2} 1
+test_expr expr-1.122 {i1=6, i2=6} {i1 IS NOT i2} 0
+test_expr expr-1.123 {i1=NULL, i2=8} \
+  {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} yes
+test_expr expr-1.124 {i1=NULL, i2=NULL} \
+  {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} no
+test_expr expr-1.125 {i1=6, i2=NULL} \
+  {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} yes
+test_expr expr-1.126 {i1=8, i2=8} \
+  {CASE WHEN i1 IS NOT i2 THEN 'yes' ELSE 'no' END} no
+
 ifcapable floatingpoint {
   test_expr expr-2.1 {r1=1.23, r2=2.34} {r1+r2} 3.57
   test_expr expr-2.2 {r1=1.23, r2=2.34} {r1-r2} -1.11
   test_expr expr-2.3 {r1=1.23, r2=2.34} {r1*r2} 2.8782
 }
 set tcl_precision 15
 ifcapable floatingpoint {
   test_expr expr-2.4 {r1=1.23, r2=2.34} {r1/r2} 0.525641025641026
   test_expr expr-2.5 {r1=1.23, r2=2.34} {r2/r1} 1.90243902439024
   test_expr expr-2.6 {r1=1.23, r2=2.34} {r2<r1} 0
@@ skipping 80 matching lines @@
 test_expr expr-4.9 {t1='0.0', t2='abc'} {t1==t2} 0
 
 ifcapable floatingpoint {
   test_expr expr-4.10 {r1='0.0', r2='abc'} {r1>r2} 0
   test_expr expr-4.11 {r1='abc', r2='Abc'} {r1<r2} 0
   test_expr expr-4.12 {r1='abc', r2='Abc'} {r1>r2} 1
   test_expr expr-4.13 {r1='abc', r2='Bbc'} {r1<r2} 0
   test_expr expr-4.14 {r1='abc', r2='Bbc'} {r1>r2} 1
   test_expr expr-4.15 {r1='0', r2='0.0'} {r1==r2} 1
   test_expr expr-4.16 {r1='0.000', r2='0.0'} {r1==r2} 1
-  test_expr expr-4.17 {r1=' 0.000', r2=' 0.0'} {r1==r2} 0
+  test_expr expr-4.17 {r1=' 0.000', r2=' 0.0'} {r1==r2} 1
   test_expr expr-4.18 {r1='0.0', r2='abc'} {r1<r2} 1
   test_expr expr-4.19 {r1='0.0', r2='abc'} {r1==r2} 0
   test_expr expr-4.20 {r1='0.0', r2='abc'} {r1>r2} 0
 }
 
 # CSL is true if LIKE is case sensitive and false if not.
 # NCSL is the opposite.  Use these variables as the result
 # on operations where case makes a difference.
 set CSL $sqlite_options(casesensitivelike)
 set NCSL [expr {!$CSL}]
@@ skipping 514 matching lines @@
   }
 } {9.22337203685478e+18}
 do_test expr-13.7 {
   execsql {
     SELECT '9223372036854775807.0'+0
   }
 } {9.22337203685478e+18}
 
 
 finish_test