Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Skip all tests in tableapi.test if SQLITE_OMIT_GET_TABLE defined. Ticket #3975. (CVS 6901) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
0219a543367638013ccd06295eeb9efc |
| User & Date: | shane 2009-07-17 14:37:25 |
Context
|
2009-07-17
| ||
| 16:54 | Return a meaningful error message if a keyword is used as an rtree table column name. Ticket #3970. (CVS 6902) (check-in: 046efe46 user: danielk1977 tags: trunk) | |
| 14:37 | Skip all tests in tableapi.test if SQLITE_OMIT_GET_TABLE defined. Ticket #3975. (CVS 6901) (check-in: 0219a543 user: shane tags: trunk) | |
| 11:44 | Code simplifications in support of structural testing. (CVS 6900) (check-in: fb1b955d user: drh tags: trunk) | |
Changes
Changes to test/tableapi.test.
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 .. 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 ... 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 |
# 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 sqlite_exec_printf() and # sqlite_get_table_printf() APIs. # # $Id: tableapi.test,v 1.20 2008/07/31 02:05:05 shane Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable memdebug { source $testdir/malloc_common.tcl } do_test tableapi-1.0 { set ::dbx [sqlite3_open test.db] ................................................................................ INSERT INTO xyz VALUES(1,'%q') } {Hi Y'all} } {0 {}} do_test tableapi-1.2 { sqlite3_exec_printf $::dbx {SELECT * FROM xyz} {} } {0 {a b 1 {Hi Y'all}}} ifcapable gettable { do_test tableapi-2.1 { sqlite3_get_table_printf $::dbx { BEGIN TRANSACTION; SELECT * FROM xyz WHERE b='%q' } {Hi Y'all} } {0 1 2 a b 1 {Hi Y'all}} do_test tableapi-2.2 { ................................................................................ } } {0 3 2 a b 52 NULL 50 (50) 42 (42)} do_test tableapi-2.7 { sqlite3_get_table_printf $::dbx { SELECT * FROM xyz WHERE a>1000 } {} } {0 0 0} }; # end ifcapable gettable # Repeat all tests with the empty_result_callbacks pragma turned on # do_test tableapi-3.1 { sqlite3_get_table_printf $::dbx { ROLLBACK; PRAGMA empty_result_callbacks = ON; |
| > > > > > < < < < < |
8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 .. 36 37 38 39 40 41 42 43 44 45 46 47 48 49 ... 113 114 115 116 117 118 119 120 121 122 123 124 125 126 |
# 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 sqlite_exec_printf() and # sqlite_get_table_printf() APIs. # # $Id: tableapi.test,v 1.21 2009/07/17 14:37:25 shane Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !gettable { finish_test return } ifcapable memdebug { source $testdir/malloc_common.tcl } do_test tableapi-1.0 { set ::dbx [sqlite3_open test.db] ................................................................................ INSERT INTO xyz VALUES(1,'%q') } {Hi Y'all} } {0 {}} do_test tableapi-1.2 { sqlite3_exec_printf $::dbx {SELECT * FROM xyz} {} } {0 {a b 1 {Hi Y'all}}} do_test tableapi-2.1 { sqlite3_get_table_printf $::dbx { BEGIN TRANSACTION; SELECT * FROM xyz WHERE b='%q' } {Hi Y'all} } {0 1 2 a b 1 {Hi Y'all}} do_test tableapi-2.2 { ................................................................................ } } {0 3 2 a b 52 NULL 50 (50) 42 (42)} do_test tableapi-2.7 { sqlite3_get_table_printf $::dbx { SELECT * FROM xyz WHERE a>1000 } {} } {0 0 0} # Repeat all tests with the empty_result_callbacks pragma turned on # do_test tableapi-3.1 { sqlite3_get_table_printf $::dbx { ROLLBACK; PRAGMA empty_result_callbacks = ON; |