Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Added tests for multi-column primary keys. (CVS 585) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
ffc49e56b13096b35e6cbb1a2f7d5468 |
User & Date: | drh 2002-05-24 02:14:50.000 |
Context
2002-05-24
| ||
16:14 | Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) (check-in: e238643efd user: drh tags: trunk) | |
02:14 | Added tests for multi-column primary keys. (CVS 585) (check-in: ffc49e56b1 user: drh tags: trunk) | |
02:04 | Split the IdList structure into IdList and SrcList. SrcList is used to represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) (check-in: a167b71d8c user: drh tags: trunk) | |
Changes
Changes to test/misc1.test.
︙ | ︙ | |||
9 10 11 12 13 14 15 | # #*********************************************************************** # This file implements regression tests for SQLite library. # # This file implements tests for miscellanous features that were # left out of other test files. # | | | 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | # #*********************************************************************** # This file implements regression tests for SQLite library. # # This file implements tests for miscellanous features that were # left out of other test files. # # $Id: misc1.test,v 1.6 2002/05/24 02:14:50 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Test the creation and use of tables that have a large number # of columns. # |
︙ | ︙ | |||
181 182 183 184 185 186 187 | } } {1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19} do_test misc1-6.4 { execsql { SELECT abort+asc,max(key,pragma,temp) FROM t4 } } {3 17} | | > | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 | } } {1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19} do_test misc1-6.4 { execsql { SELECT abort+asc,max(key,pragma,temp) FROM t4 } } {3 17} # Test for multi-column primary keys, and for multiple primary keys. # do_test misc1-7.1 { catchsql { CREATE TABLE error1( a TYPE PRIMARY KEY, b TYPE PRIMARY KEY ); } } {1 {table "error1" has more than one primary key}} do_test misc1-7.2 { catchsql { CREATE TABLE error1( a INTEGER PRIMARY KEY, b TYPE PRIMARY KEY ); } } {1 {table "error1" has more than one primary key}} do_test misc1-7.3 { execsql { CREATE TABLE t5(a,b,c,PRIMARY KEY(a,b)); INSERT INTO t5 VALUES(1,2,3); SELECT * FROM t5 ORDER BY a; } } {1 2 3} do_test misc1-7.4 { catchsql { INSERT INTO t5 VALUES(1,2,4); } } {1 {constraint failed}} do_test misc1-7.5 { catchsql { INSERT INTO t5 VALUES(0,2,4); } } {0 {}} do_test misc1-7.6 { execsql { SELECT * FROM t5 ORDER BY a; } } {0 2 4 1 2 3} finish_test |