| 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
|
|
|