/ Check-in [9589e937]
Login

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

Overview
Comment:Fix the rtreeG.test test case.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | tree-stat1-fix
Files: files | file ages | folders
SHA1:9589e9377118efc356c73ea1aab2d7e6c2f7fc36
User & Date: drh 2016-05-23 18:27:07
Context
2016-05-23
19:02
Avoid a minor error message when running RTREE without an sqlite_stat1 table. check-in: 276e92f5 user: drh tags: trunk
18:27
Fix the rtreeG.test test case. Closed-Leaf check-in: 9589e937 user: drh tags: tree-stat1-fix
18:12
Fix RTREE so that it does not run queries against the sqlite_stat1 if that table does not exist. check-in: 48526a2f user: drh tags: tree-stat1-fix
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/rtree/rtreeG.test.

    22     22   sqlite3_shutdown
    23     23   test_sqlite3_log [list lappend ::log]
    24     24   set ::log [list]
    25     25   sqlite3 db test.db
    26     26   
    27     27   
    28     28   set ::log {}
    29         -do_test rtreeG-1.1 {
    30         -  db eval {CREATE VIRTUAL TABLE t1 USING rtree(a,b,c);}
           29  +do_execsql_test rtreeG-1.1 {
           30  +  CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1);
           31  +} {}
           32  +do_test rtreeG-1.1log {
           33  +  set ::log
           34  +} {}
           35  +
           36  +do_execsql_test rtreeG-1.2 {
           37  +  INSERT INTO t1 VALUES(1,10,15,5,23),(2,20,21,5,23),(3,10,15,20,30);
           38  +  SELECT id from t1 WHERE x0>8 AND x1<16 AND y0>2 AND y1<25;
           39  +} {1}
           40  +do_test rtreeG-1.2log {
           41  +  set ::log
           42  +} {}
           43  +
           44  +db close
           45  +sqlite3 db test.db
           46  +do_execsql_test rtreeG-1.3 {
           47  +  SELECT id from t1 WHERE x0>8 AND x1<16 AND y0>2 AND y1<25;
           48  +} {1}
           49  +do_test rtreeG-1.3log {
           50  +  set ::log
           51  +} {}
           52  +
           53  +do_execsql_test rtreeG-1.4 {
           54  +  DROP TABLE t1;
           55  +} {}
           56  +do_test rtreeG-1.4log {
    31     57     set ::log
    32     58   } {}
    33     59   
           60  +db close
           61  +sqlite3_shutdown
           62  +test_sqlite3_log
           63  +sqlite3_initialize
           64  +sqlite3 db test.db
           65  +
    34     66   finish_test