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