/ Check-in [14227724]
Login

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: 14227724a81c31c6bb9381b210f8fabf4b1154fd
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/e_select.test.

   278    278     3  "SELECT 'x'||a||'x' FROM t1" {xax xbx xcx}
   279    279     4  "SELECT 'x'||a||'x' alias FROM t1" {xax xbx xcx}
   280    280     5  "SELECT 'x'||a||'x' AS alias FROM t1" {xax xbx xcx}
   281    281   }
   282    282   
   283    283   # EVIDENCE-OF: R-41233-21397 -- syntax diagram join-source
   284    284   #
   285         -# EVIDENCE-OF: R-62821-57533 -- syntax diagram join-op
          285  +# EVIDENCE-OF: R-28036-03696 -- syntax diagram join-op
   286    286   #
   287    287   do_select_tests e_select-0.4 {
   288    288     1  "SELECT t1.rowid FROM t1" {1 2 3}
   289    289     2  "SELECT t1.rowid FROM t1,t2" {1 1 1 2 2 2 3 3 3}
   290    290     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}
   291    291   
   292    292     4  "SELECT t1.rowid FROM t1" {1 2 3}
................................................................................
   319    319   do_select_tests e_select-0.6 {
   320    320     1  "SELECT b||a FROM t1 ORDER BY b||a"                  {onea threec twob}
   321    321     2  "SELECT b||a FROM t1 ORDER BY (b||a) COLLATE nocase" {onea threec twob}
   322    322     3  "SELECT b||a FROM t1 ORDER BY (b||a) ASC"            {onea threec twob}
   323    323     4  "SELECT b||a FROM t1 ORDER BY (b||a) DESC"           {twob threec onea}
   324    324   }
   325    325   
   326         -# EVIDENCE-OF: R-35843-38195 -- syntax diagram select-stmt
          326  +# EVIDENCE-OF: R-32629-22838 -- syntax diagram select-stmt
   327    327   #
   328    328   do_select_tests e_select-0.7 {
   329    329     1  "SELECT * FROM t1" {a one b two c three}
   330    330     2  "SELECT * FROM t1 ORDER BY b" {a one c three b two}
   331    331     3  "SELECT * FROM t1 ORDER BY b, a" {a one c three b two}
   332    332   
   333    333     4  "SELECT * FROM t1 LIMIT 10" {a one b two c three}