Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| 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: |
0b7668a71ef8995ea0306c7d890f8776 |
| User & Date: | dan 2011-03-23 10:52:24 |
|
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 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