diff options
| author | drh <drh@noemail.net> | 2008-01-19 20:11:25 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2008-01-19 20:11:25 +0000 |
| commit | 91fd4d46adb506dca504a15357bdce13c7d198cf (patch) | |
| tree | 223880231b1f421b2b4ecf42b07cdbbddfe3c8d4 /test/expr.test | |
| parent | a05a722f2373f8ec849c1e0ed26708583fb43bf4 (diff) | |
| download | sqlite-91fd4d46adb506dca504a15357bdce13c7d198cf.tar.gz sqlite-91fd4d46adb506dca504a15357bdce13c7d198cf.zip | |
Miscellaneous code simplifications and cleanup and test coverage
enhancements. (CVS 4730)
FossilOrigin-Name: af129b6d158cc90ce9752dd6383c1de47f7b3e43
Diffstat (limited to 'test/expr.test')
| -rw-r--r-- | test/expr.test | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/test/expr.test b/test/expr.test index 0f03fd9f6..3fb6adf2c 100644 --- a/test/expr.test +++ b/test/expr.test @@ -11,7 +11,7 @@ # This file implements regression tests for SQLite library. The # focus of this file is testing expressions. # -# $Id: expr.test,v 1.60 2008/01/16 18:20:42 danielk1977 Exp $ +# $Id: expr.test,v 1.61 2008/01/19 20:11:26 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -72,6 +72,7 @@ test_expr expr-1.42b {i1=1, i2=2} {4|2} {6} test_expr expr-1.43 {i1=1, i2=2} {i1&i2} {0} test_expr expr-1.43b {i1=1, i2=2} {4&5} {4} test_expr expr-1.44 {i1=1} {~i1} {-2} +test_expr expr-1.44b {i1=NULL} {~i1} {{}} test_expr expr-1.45 {i1=1, i2=3} {i1<<i2} {8} test_expr expr-1.46 {i1=32, i2=3} {i1>>i2} {4} test_expr expr-1.47 {i1=9999999999, i2=8888888888} {i1<i2} 0 @@ -141,6 +142,8 @@ test_expr expr-1.105 {i1=0} {(-9223372036854775808.0 / -1)>1} 1 test_expr expr-1.106 {i1=0} {(1<<63)/-1} -9223372036854775808 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} {{}} 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 @@ -169,6 +172,8 @@ test_expr expr-2.23 {r1=1.23, r2=2.34} {max(r1,r2,r1+r2,r1-r2)} {3.57} test_expr expr-2.24 {r1=25.0, r2=11.0} {r1%r2} 3.0 test_expr expr-2.25 {r1=1.23, r2=NULL} {coalesce(r1+r2,99.0)} 99.0 test_expr expr-2.26 {r1=1e300, r2=1e300} {coalesce((r1*r2)*0.0,99.0)} 99.0 +test_expr expr-2.27 {r1=1.1, r2=0.0} {r1/r2} {{}} +test_expr expr-2.28 {r1=1.1, r2=0.0} {r1%r2} {{}} test_expr expr-3.1 {t1='abc', t2='xyz'} {t1<t2} 1 test_expr expr-3.2 {t1='xyz', t2='abc'} {t1<t2} 0 |