Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a couple of stale evidence marks in e_select.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
14227724a81c31c6bb9381b210f8fabf |
| User & Date: | dan 2010-09-18 15:15:02 |
Context
|
2010-09-18
| ||
| 19:00 | Add new test file e_insert.test. (check-in: 8023a309 user: dan tags: trunk) | |
| 15:15 | Fix a couple of stale evidence marks in e_select.test. (check-in: 14227724 user: dan tags: trunk) | |
| 15:03 | Add tests to e_select.test. (check-in: 0ee9e755 user: dan tags: trunk) | |
Changes
Changes to test/e_select.test.
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
...
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
|
3 "SELECT 'x'||a||'x' FROM t1" {xax xbx xcx}
4 "SELECT 'x'||a||'x' alias FROM t1" {xax xbx xcx}
5 "SELECT 'x'||a||'x' AS alias FROM t1" {xax xbx xcx}
}
# EVIDENCE-OF: R-41233-21397 -- syntax diagram join-source
#
# EVIDENCE-OF: R-62821-57533 -- syntax diagram join-op
#
do_select_tests e_select-0.4 {
1 "SELECT t1.rowid FROM t1" {1 2 3}
2 "SELECT t1.rowid FROM t1,t2" {1 1 1 2 2 2 3 3 3}
3 "SELECT t1.rowid FROM t1,t2,t3" {1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3}
4 "SELECT t1.rowid FROM t1" {1 2 3}
................................................................................
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-35843-38195 -- 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}
|
|
|
|
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
...
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
|
3 "SELECT 'x'||a||'x' FROM t1" {xax xbx xcx}
4 "SELECT 'x'||a||'x' alias FROM t1" {xax xbx xcx}
5 "SELECT 'x'||a||'x' AS alias FROM t1" {xax xbx xcx}
}
# EVIDENCE-OF: R-41233-21397 -- syntax diagram join-source
#
# EVIDENCE-OF: R-28036-03696 -- syntax diagram join-op
#
do_select_tests e_select-0.4 {
1 "SELECT t1.rowid FROM t1" {1 2 3}
2 "SELECT t1.rowid FROM t1,t2" {1 1 1 2 2 2 3 3 3}
3 "SELECT t1.rowid FROM t1,t2,t3" {1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3}
4 "SELECT t1.rowid FROM t1" {1 2 3}
................................................................................
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}
|