/ Check-in [8502fba3]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Added test case to in4.test to try and duplicate crash reported on the mailing list. (CVS 5951)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 8502fba37bb13c019252d0a65973a78982ec44aa
User & Date: shane 2008-11-24 15:32:00
Context
2008-11-24
20:01
Fixed some spelling errors in sqliteInt.h. Ticket #3509. (CVS 5952) check-in: 7e134a5c user: shane tags: trunk
15:32
Added test case to in4.test to try and duplicate crash reported on the mailing list. (CVS 5951) check-in: 8502fba3 user: shane tags: trunk
2008-11-22
19:50
fix the compile warnings on OS/2 (CVS 5950) check-in: b7d0ec83 user: pweilbacher tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/in4.test.

     5      5   #
     6      6   #    May you do good and not evil.
     7      7   #    May you find forgiveness for yourself and forgive others.
     8      8   #    May you share freely, never taking more than you give.
     9      9   #
    10     10   #***********************************************************************
    11     11   #
    12         -# $Id: in4.test,v 1.1 2008/10/02 13:50:56 danielk1977 Exp $
           12  +# $Id: in4.test,v 1.2 2008/11/24 15:32:00 shane Exp $
    13     13   
    14     14   set testdir [file dirname $argv0]
    15     15   source $testdir/tester.tcl
    16     16   
    17     17   do_test in4-1.1 {
    18     18     execsql {
    19     19       CREATE TABLE t1(a, b);
................................................................................
    84     84   do_test in4-2.7 {
    85     85     execsql { SELECT b FROM t2 WHERE a IN ('1', '2') }
    86     86   } {one two}
    87     87   
    88     88   do_test in4-2.8 {
    89     89     execsql { SELECT b FROM t2 WHERE a IN ('', '0.0.0', '2') }
    90     90   } {two}
           91  +
           92  +# add test case from the mailing list 
           93  +# (11/7/08 sqlite crash with "WHERE x in ()" query)
           94  +do_test in4-3.1 {
           95  +  execsql {
           96  +    DROP TABLE IF EXISTS t1;
           97  +    DROP TABLE IF EXISTS t2;
           98  +    CREATE TABLE t1(x, id);
           99  +    CREATE TABLE t2(x, id);
          100  +    INSERT INTO t1 VALUES(NULL, NULL);
          101  +    INSERT INTO t1 VALUES(0, NULL);
          102  +    INSERT INTO t1 VALUES(1, 3);
          103  +    INSERT INTO t1 VALUES(2, 4);
          104  +    INSERT INTO t1 VALUES(3, 5);
          105  +    INSERT INTO t1 VALUES(4, 6);
          106  +    INSERT INTO t2 VALUES(0, NULL);
          107  +    INSERT INTO t2 VALUES(4, 1);
          108  +    INSERT INTO t2 VALUES(NULL, 1);
          109  +    INSERT INTO t2 VALUES(NULL, NULL);
          110  +  }
          111  +} {}
          112  +do_test in4-3.2 {
          113  +  execsql {
          114  +    SELECT x FROM t1 WHERE id IN () AND x IN (SELECT x FROM t2 WHERE id=1)
          115  +  }
          116  +} {}
    91    117   
    92    118   finish_test
    93    119