diff options
Diffstat (limited to 'test/expr.test')
| -rw-r--r-- | test/expr.test | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/test/expr.test b/test/expr.test index 39f1d38fe..c23b5687d 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.42 2005/01/21 03:12:16 danielk1977 Exp $ +# $Id: expr.test,v 1.43 2005/01/21 11:55:27 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl @@ -553,4 +553,12 @@ do_test expr-9.1 { execsql {SELECT round(-('-'||'123'))} } 123 +# Test an error message that can be generated by the LIKE expression +do_test expr-10.1 { + catchsql {SELECT 'abc' LIKE 'abc' ESCAPE ''} +} {1 {ESCAPE expression must be a single character}} +do_test expr-10.2 { + catchsql {SELECT 'abc' LIKE 'abc' ESCAPE 'ab'} +} {1 {ESCAPE expression must be a single character}} + finish_test |