Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Modify some evidence tags to match updated gifs. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
f44de500be5130d5ad800759acb76377 |
| User & Date: | dan 2010-09-24 19:14:43 |
Context
|
2010-09-25
| ||
| 07:51 | Add tests to file e_reindex.test. (check-in: eec7dc91 user: dan tags: trunk) | |
|
2010-09-24
| ||
| 19:14 | Modify some evidence tags to match updated gifs. (check-in: f44de500 user: dan tags: trunk) | |
| 18:08 | Merge experimental branch back into trunk. (check-in: 83ecec5d user: dan tags: trunk) | |
Changes
Changes to test/e_delete.test.
283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 |
}
# EVIDENCE-OF: R-40026-10531 If SQLite is compiled with the
# SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option, then the syntax
# of the DELETE statement is extended by the addition of optional ORDER
# BY and LIMIT clauses:
#
# EVIDENCE-OF: R-49959-20251 -- syntax diagram delete-stmt-limited
#
do_delete_tests e_delete-3.1 {
1 "DELETE FROM t1 LIMIT 5" {}
2 "DELETE FROM t1 LIMIT 5-1 OFFSET 2+2" {}
3 "DELETE FROM t1 LIMIT 2+2, 16/4" {}
4 "DELETE FROM t1 ORDER BY x LIMIT 5" {}
5 "DELETE FROM t1 ORDER BY x LIMIT 5-1 OFFSET 2+2" {}
|
| |
283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 |
}
# EVIDENCE-OF: R-40026-10531 If SQLite is compiled with the
# SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option, then the syntax
# of the DELETE statement is extended by the addition of optional ORDER
# BY and LIMIT clauses:
#
# EVIDENCE-OF: R-45897-01670 -- syntax diagram delete-stmt-limited
#
do_delete_tests e_delete-3.1 {
1 "DELETE FROM t1 LIMIT 5" {}
2 "DELETE FROM t1 LIMIT 5-1 OFFSET 2+2" {}
3 "DELETE FROM t1 LIMIT 2+2, 16/4" {}
4 "DELETE FROM t1 ORDER BY x LIMIT 5" {}
5 "DELETE FROM t1 ORDER BY x LIMIT 5-1 OFFSET 2+2" {}
|
Added test/e_reindex.test.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
# 2010 September 24 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # This file implements tests to verify that the "testable statements" in # the lang_reindex.html document are correct. # set testdir [file dirname $argv0] source $testdir/tester.tcl proc do_reindex_tests {args} { uplevel do_select_tests $args } do_execsql_test e_reindex-0.0 { CREATE TABLE t1(a, b); CREATE INDEX i1 ON t1(a, b); CREATE INDEX i2 ON t1(b, a); } {} # EVIDENCE-OF: R-57021-15304 -- syntax diagram reindex-stmt # do_reindex_tests e_reindex-0.1 { 1 "REINDEX" {} 2 "REINDEX nocase" {} 3 "REINDEX binary" {} 4 "REINDEX t1" {} 5 "REINDEX main.t1" {} 4 "REINDEX i1" {} 5 "REINDEX main.i1" {} } finish_test |
Changes to test/e_select.test.
270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 |
do_select_tests e_select-0.6 {
1 "SELECT b||a FROM t1 ORDER BY b||a" {onea threec twob}
2 "SELECT b||a FROM t1 ORDER BY (b||a) COLLATE nocase" {onea threec twob}
3 "SELECT b||a FROM t1 ORDER BY (b||a) ASC" {onea threec twob}
4 "SELECT b||a FROM t1 ORDER BY (b||a) DESC" {twob threec onea}
}
# EVIDENCE-OF: R-32629-22838 -- syntax diagram select-stmt
#
do_select_tests e_select-0.7 {
1 "SELECT * FROM t1" {a one b two c three}
2 "SELECT * FROM t1 ORDER BY b" {a one c three b two}
3 "SELECT * FROM t1 ORDER BY b, a" {a one c three b two}
4 "SELECT * FROM t1 LIMIT 10" {a one b two c three}
|
| |
270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 |
do_select_tests e_select-0.6 {
1 "SELECT b||a FROM t1 ORDER BY b||a" {onea threec twob}
2 "SELECT b||a FROM t1 ORDER BY (b||a) COLLATE nocase" {onea threec twob}
3 "SELECT b||a FROM t1 ORDER BY (b||a) ASC" {onea threec twob}
4 "SELECT b||a FROM t1 ORDER BY (b||a) DESC" {twob threec onea}
}
# EVIDENCE-OF: R-36494-33519 -- syntax diagram select-stmt
#
do_select_tests e_select-0.7 {
1 "SELECT * FROM t1" {a one b two c three}
2 "SELECT * FROM t1 ORDER BY b" {a one c three b two}
3 "SELECT * FROM t1 ORDER BY b, a" {a one c three b two}
4 "SELECT * FROM t1 LIMIT 10" {a one b two c three}
|
Changes to test/e_update.test.
491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 |
}
# EVIDENCE-OF: R-59581-44104 If SQLite is built with the
# SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option then the syntax
# of the UPDATE statement is extended with optional ORDER BY and LIMIT
# clauses
#
# EVIDENCE-OF: R-07033-64910 -- syntax diagram update-stmt-limited
#
do_update_tests e_update-3.0 {
1 "UPDATE t1 SET a=b LIMIT 5" {}
2 "UPDATE t1 SET a=b LIMIT 5-1 OFFSET 2+2" {}
3 "UPDATE t1 SET a=b LIMIT 2+2, 16/4" {}
4 "UPDATE t1 SET a=b ORDER BY a LIMIT 5" {}
5 "UPDATE t1 SET a=b ORDER BY a LIMIT 5-1 OFFSET 2+2" {}
|
| |
491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 |
}
# EVIDENCE-OF: R-59581-44104 If SQLite is built with the
# SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option then the syntax
# of the UPDATE statement is extended with optional ORDER BY and LIMIT
# clauses
#
# EVIDENCE-OF: R-08948-01887 -- syntax diagram update-stmt-limited
#
do_update_tests e_update-3.0 {
1 "UPDATE t1 SET a=b LIMIT 5" {}
2 "UPDATE t1 SET a=b LIMIT 5-1 OFFSET 2+2" {}
3 "UPDATE t1 SET a=b LIMIT 2+2, 16/4" {}
4 "UPDATE t1 SET a=b ORDER BY a LIMIT 5" {}
5 "UPDATE t1 SET a=b ORDER BY a LIMIT 5-1 OFFSET 2+2" {}
|