diff options
| author | drh <drh@noemail.net> | 2003-09-30 01:54:13 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2003-09-30 01:54:13 +0000 |
| commit | 319e4e74841dffc97cd96f8ee60ed462ca7a8a4d (patch) | |
| tree | 41f5790ffd7b6919d0922045113cb3f537f47827 /test/expr.test | |
| parent | 4f88c849f318700260f55a28ab4fdff2b7bea157 (diff) | |
| download | sqlite-319e4e74841dffc97cd96f8ee60ed462ca7a8a4d.tar.gz sqlite-319e4e74841dffc97cd96f8ee60ed462ca7a8a4d.zip | |
All LIKE and GLOB operators to use function notation. "A LIKE B" can be
expressed as "LIKE(B,A)". (CVS 1108)
FossilOrigin-Name: 95b27ebd1322a877112dee514dffddb0937e45fa
Diffstat (limited to 'test/expr.test')
| -rw-r--r-- | test/expr.test | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/test/expr.test b/test/expr.test index 9b344e436..0d0c6e2ae 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.29 2003/04/16 02:17:36 drh Exp $ +# $Id: expr.test,v 1.30 2003/09/30 01:54:15 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -507,4 +507,11 @@ test_expr2 expr-7.57 {((a>0 IS NULL OR 0) AND 1) OR 0} {{}} test_expr2 expr-7.58 {(a||'')<='1'} {1} +test_expr2 expr-7.59 {LIKE('10%',b)} {10 20} +test_expr2 expr-7.60 {LIKE('_4',b)} {6} +test_expr2 expr-7.61 {GLOB('1?',a)} {10 11 12 13 14 15 16 17 18 19} +test_expr2 expr-7.62 {GLOB('1*4',b)} {10 14} +test_expr2 expr-7.63 {GLOB('*1[456]',b)} {4} + + finish_test |