SQLite

Check-in [d8e4738216]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a problem in test file bigmmap.test.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: d8e47382160e98be646ce3ba568578493088d1bb11d513ded3e00b576fb07f06
User & Date: dan 2020-08-19 15:21:52.251
Context
2020-08-19
15:24
Update releasetest_data.tcl so that the "Fast-One" configuration runs bigmmap.test as part of release testing. (check-in: a0aa35aaa5 user: dan tags: trunk)
15:21
Fix a problem in test file bigmmap.test. (check-in: d8e4738216 user: dan tags: trunk)
2020-08-17
09:11
Fix the -quote option on the CLI to set the correct column separator. (check-in: c778f8295c user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/bigmmap.test.
︙︙
91
92
93
94
95
96
97
98
99
100
101
102
103
104

    do_eqp_test 2.$i.$t.3 "
      SELECT * FROM t$t AS o WHERE 
        NOT EXISTS( SELECT * FROM t$t AS i WHERE a=o.a AND +b=o.b AND +c=o.c )
      ORDER BY b, c;
    " [string map {"\n    " "\n"} "
      QUERY PLAN
      |--SCAN TABLE t$t AS o USING COVERING INDEX sqlite_autoindex_t${t}_1
      `--CORRELATED SCALAR SUBQUERY
         `--SEARCH TABLE t$t AS i USING INTEGER PRIMARY KEY (rowid=?)
    "]
  }
}

finish_test








|







91
92
93
94
95
96
97
98
99
100
101
102
103
104

    do_eqp_test 2.$i.$t.3 "
      SELECT * FROM t$t AS o WHERE 
        NOT EXISTS( SELECT * FROM t$t AS i WHERE a=o.a AND +b=o.b AND +c=o.c )
      ORDER BY b, c;
    " [string map {"\n    " "\n"} "
      QUERY PLAN
      |--SCAN TABLE t$t AS o USING COVERING INDEX sqlite_autoindex_t${t}_1
      `--CORRELATED SCALAR SUBQUERY xxxxxx
         `--SEARCH TABLE t$t AS i USING INTEGER PRIMARY KEY (rowid=?)
    "]
  }
}

finish_test