Index: third_party/sqlite/src/test/expr.test |
diff --git a/third_party/sqlite/src/test/expr.test b/third_party/sqlite/src/test/expr.test |
index 1d624d7b13b9c88541f9004566cf18104cc35852..140ab8d8b31881bcee3ede72416ab1562bbd767b 100644 |
--- a/third_party/sqlite/src/test/expr.test |
+++ b/third_party/sqlite/src/test/expr.test |
@@ -165,6 +165,31 @@ 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 |
@@ -265,7 +290,7 @@ ifcapable floatingpoint { |
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 |