/ Check-in [3117238c]
Login

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

Overview
Comment:Remove a surplus "breakpoint" from select4.test. (CVS 5294)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3117238ce9cbfc36e2de929592decef86220e2a2
User & Date: drh 2008-06-24 12:28:04
Context
2008-06-24
12:46
Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2. Other bug fixes in compound-merge. The compound-merge is still disabled in this check-in using "#if 0" due to additional bugs. (CVS 5295) check-in: 95037e6d user: drh tags: trunk
12:28
Remove a surplus "breakpoint" from select4.test. (CVS 5294) check-in: 3117238c user: drh tags: trunk
11:21
Add start of new test file "select9.test". To test LIMIT, OFFSET and ORDER BY on compound SELECT statements. (CVS 5293) check-in: 3a13e943 user: danielk1977 tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/select1.test.

     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   # This file implements regression tests for SQLite library.  The
    12     12   # focus of this file is testing the SELECT statement.
    13     13   #
    14         -# $Id: select1.test,v 1.59 2008/06/24 00:32:36 drh Exp $
           14  +# $Id: select1.test,v 1.60 2008/06/24 12:28:04 drh Exp $
    15     15   
    16     16   set testdir [file dirname $argv0]
    17     17   source $testdir/tester.tcl
    18     18   
    19     19   # Try to select on a non-existant table.
    20     20   #
    21     21   do_test select1-1.1 {
................................................................................
   540    540      execsql {
   541    541        SELECT a FROM t6 WHERE b IN 
   542    542           (SELECT b FROM t6 WHERE a<='b' UNION SELECT '3' AS x
   543    543                    ORDER BY 1 DESC LIMIT 1)
   544    544      }
   545    545   } {d}
   546    546   do_test select1-6.22 {
   547         -breakpoint
   548    547      execsql {
   549    548        SELECT a FROM t6 WHERE b IN 
   550    549           (SELECT b FROM t6 WHERE a<='b' UNION SELECT '3' AS x
   551    550                    ORDER BY b LIMIT 2)
   552    551        ORDER BY a;
   553    552      }
   554    553   } {a b}
................................................................................
   929    928   do_test select1-14.2 {
   930    929     execsql { 
   931    930       SELECT 10 IN (SELECT rowid FROM sqlite_master);
   932    931     }
   933    932   } {0}
   934    933   
   935    934   finish_test
          935  +