/ Check-in [0b7668a7]
Login

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

Overview
Comment:Fix a numbering issue in rtree6.test. Add a couple of extra tests.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0b7668a71ef8995ea0306c7d890f87761961426e
User & Date: dan 2011-03-23 10:52:24
Context
2011-03-23
11:16
In the shell, make sure the ".log" command has at least one argument. check-in: 1ed5e361 user: drh tags: trunk
10:52
Fix a numbering issue in rtree6.test. Add a couple of extra tests. check-in: 0b7668a7 user: dan tags: trunk
10:38
Change the rtree module to support queries with multiple comparison operators (i.e. > or <) of the same type on a single column. check-in: 387b55aa user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/rtree/rtree6.test.

   123    123       SELECT * FROM t3 WHERE 
   124    124         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   125    125         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   126    126         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   127    127         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 
   128    128     }
   129    129   } {EaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEa}
   130         -do_test rtree6.3.4 {
          130  +do_test rtree6.3.3 {
   131    131     rtree_strategy {
   132    132       SELECT * FROM t3 WHERE 
   133    133         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   134    134         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   135    135         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   136    136         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   137    137         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
   138    138         x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5
   139    139     }
   140    140   } {EaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEaEa}
          141  +
          142  +do_execsql_test rtree6-3.4 {
          143  +  SELECT * FROM t3 WHERE x1>0.5 AND x1>0.8 AND x1>1.1
          144  +} {}
          145  +do_execsql_test rtree6-3.5 {
          146  +  SELECT * FROM t3 WHERE 
          147  +    x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
          148  +    x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
          149  +    x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
          150  +    x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
          151  +    x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND 
          152  +    x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>1.1
          153  +} {}
   141    154   
   142    155   
   143    156   finish_test