diff options
| author | Bernard Xiong <[email protected]> | 2013-11-30 03:36:56 -0800 |
|---|---|---|
| committer | Bernard Xiong <[email protected]> | 2013-11-30 03:36:56 -0800 |
| commit | be2f628160fa1262b6cc10df3823c5f984bc3c48 (patch) | |
| tree | 6a96d2f30c979713b5f175b08c90a03f359faeb6 /components/external/SQLite-3.8.1/test/mallocK.test | |
| parent | 35d83be62ff504d2b595288e0a377160604e71a8 (diff) | |
| parent | 9326719a12cf54f3418e292835e37ddc3afa92fd (diff) | |
Merge pull request #205 from geniusgogo/sqlite
Sqlite
Diffstat (limited to 'components/external/SQLite-3.8.1/test/mallocK.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/mallocK.test | 72 |
1 files changed, 72 insertions, 0 deletions
diff --git a/components/external/SQLite-3.8.1/test/mallocK.test b/components/external/SQLite-3.8.1/test/mallocK.test new file mode 100644 index 0000000000..971bd56137 --- /dev/null +++ b/components/external/SQLite-3.8.1/test/mallocK.test @@ -0,0 +1,72 @@ +# 2008 August 01 +# +# The author disclaims copyright to this source code. In place of +# a legal notice, here is a blessing: +# +# May you do good and not evil. +# May you find forgiveness for yourself and forgive others. +# May you share freely, never taking more than you give. +# +#*********************************************************************** +# +# This test script checks malloc failures in WHERE clause analysis. +# +# $Id: mallocK.test,v 1.3 2009/01/08 21:00:03 drh Exp $ + +set testdir [file dirname $argv0] +source $testdir/tester.tcl +source $testdir/malloc_common.tcl + +set sql {SELECT * FROM t1, t2 WHERE (a=1 OR a=2)} +for {set x 1} {$x<5} {incr x} { + append sql " AND b=y" + do_malloc_test mallocK-1.$x -sqlbody $sql -sqlprep { + CREATE TABLE t1(a,b); + CREATE TABLE t2(x,y); + } +} + +set sql {SELECT * FROM t1 WHERE a GLOB 'xyz*' AND (a=1 OR a=2)} +for {set x 1} {$x<5} {incr x} { + append sql " AND b!=$x" + do_malloc_test mallocK-2.$x -sqlbody $sql -sqlprep { + CREATE TABLE t1(a,b); + } +} + +set sql {SELECT * FROM t1 WHERE a BETWEEN 5 AND 10} +for {set x 1} {$x<5} {incr x} { + append sql " AND b=$x" + do_malloc_test mallocK-3.$x -sqlbody $sql -sqlprep { + CREATE TABLE t1(a,b); + } +} + +set sql {SELECT * FROM t1 WHERE b=0} +for {set x 1} {$x<5} {incr x} { + set term "(b=$x" + for {set y 0} {$y<$x} {incr y} { + append term " AND a!=$y" + } + append sql " OR $term)" + do_malloc_test mallocK-4.$x -sqlbody $sql -sqlprep { + CREATE TABLE t1(a,b); + } +} + +ifcapable vtab { + set sql {SELECT * FROM t2 WHERE a MATCH 'xyz'} + for {set x 1} {$x<5} {incr x} { + append sql " AND b!=$x" + do_malloc_test mallocK-5.$x -sqlbody $sql -tclprep { + register_echo_module [sqlite3_connection_pointer db] + db eval { + CREATE TABLE t1(a,b); + CREATE VIRTUAL TABLE t2 USING echo(t1); + } + } + } +} + + +finish_test |
