Lines Matching refs:ii
58 execsql { CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2) }
80 CREATE VIRTUAL TABLE aux.'a" "b' USING rtree(ii, x1, x2, y1, y2);
138 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2);
148 execsql_intout { SELECT * FROM t1 ORDER BY ii }
185 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
200 execsql { SELECT ii FROM t1 ORDER BY ii }
205 } {1 {UNIQUE constraint failed: t1.ii}}
213 execsql { SELECT ii FROM t1 ORDER BY ii }
227 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
256 execsql { CREATE VIRTUAL TABLE t2 USING rtree(ii, x1, x2) }
263 SELECT * FROM t2 ORDER BY ii;
268 DELETE FROM t2 WHERE ii=2;
269 SELECT * FROM t2 ORDER BY ii;
274 DELETE FROM t2 WHERE ii=1;
275 SELECT * FROM t2 ORDER BY ii;
280 DELETE FROM t2 WHERE ii=3;
281 SELECT * FROM t2 ORDER BY ii;
292 execsql { CREATE VIRTUAL TABLE t3 USING rtree(ii, x1, x2, y1, y2) }
302 execsql { UPDATE t3 SET ii = 2 }
311 CREATE VIRTUAL TABLE t4 USING rtree(ii, x1, x2, y1, y2, z1, z2);
378 CREATE VIRTUAL TABLE t6 USING rtree(ii, x1, x2);
383 do_test rtree-8.1.2 { execsql { SELECT ii FROM t6 WHERE x1>2 } } {1 2}
384 do_test rtree-8.1.3 { execsql { SELECT ii FROM t6 WHERE x1>3 } } {2}
385 do_test rtree-8.1.4 { execsql { SELECT ii FROM t6 WHERE x1>4 } } {}
386 do_test rtree-8.1.5 { execsql { SELECT ii FROM t6 WHERE x1>5 } } {}
387 do_test rtree-8.1.6 { execsql { SELECT ii FROM t6 WHERE x1>''} } {}
388 do_test rtree-8.1.7 { execsql { SELECT ii FROM t6 WHERE x1>null}} {}
389 do_test rtree-8.1.8 { execsql { SELECT ii FROM t6 WHERE x1>'2'} } {1 2}
390 do_test rtree-8.1.9 { execsql { SELECT ii FROM t6 WHERE x1>'3'} } {2}
391 do_test rtree-8.2.2 { execsql { SELECT ii FROM t6 WHERE x1>=2 } } {1 2}
392 do_test rtree-8.2.3 { execsql { SELECT ii FROM t6 WHERE x1>=3 } } {1 2}
393 do_test rtree-8.2.4 { execsql { SELECT ii FROM t6 WHERE x1>=4 } } {2}
394 do_test rtree-8.2.5 { execsql { SELECT ii FROM t6 WHERE x1>=5 } } {}
395 do_test rtree-8.2.6 { execsql { SELECT ii FROM t6 WHERE x1>=''} } {}
396 do_test rtree-8.2.7 { execsql { SELECT ii FROM t6 WHERE x1>=null}} {}
397 do_test rtree-8.2.8 { execsql { SELECT ii FROM t6 WHERE x1>='4'} } {2}
398 do_test rtree-8.2.9 { execsql { SELECT ii FROM t6 WHERE x1>='5'} } {}
399 do_test rtree-8.3.2 { execsql { SELECT ii FROM t6 WHERE x1<2 } } {}
400 do_test rtree-8.3.3 { execsql { SELECT ii FROM t6 WHERE x1<3 } } {}
401 do_test rtree-8.3.4 { execsql { SELECT ii FROM t6 WHERE x1<4 } } {1}
402 do_test rtree-8.3.5 { execsql { SELECT ii FROM t6 WHERE x1<5 } } {1 2}
403 do_test rtree-8.3.6 { execsql { SELECT ii FROM t6 WHERE x1<''} } {1 2}
404 do_test rtree-8.3.7 { execsql { SELECT ii FROM t6 WHERE x1<null}} {}
405 do_test rtree-8.3.8 { execsql { SELECT ii FROM t6 WHERE x1<'3'} } {}
406 do_test rtree-8.3.9 { execsql { SELECT ii FROM t6 WHERE x1<'4'} } {1}
407 do_test rtree-8.4.2 { execsql { SELECT ii FROM t6 WHERE x1<=2 } } {}
408 do_test rtree-8.4.3 { execsql { SELECT ii FROM t6 WHERE x1<=3 } } {1}
409 do_test rtree-8.4.4 { execsql { SELECT ii FROM t6 WHERE x1<=4 } } {1 2}
410 do_test rtree-8.4.5 { execsql { SELECT ii FROM t6 WHERE x1<=5 } } {1 2}
411 do_test rtree-8.4.6 { execsql { SELECT ii FROM t6 WHERE x1<=''} } {1 2}
412 do_test rtree-8.4.7 { execsql { SELECT ii FROM t6 WHERE x1<=null}} {}
413 do_test rtree-8.5.2 { execsql { SELECT ii FROM t6 WHERE x1=2 } } {}
414 do_test rtree-8.5.3 { execsql { SELECT ii FROM t6 WHERE x1=3 } } {1}
415 do_test rtree-8.5.4 { execsql { SELECT ii FROM t6 WHERE x1=4 } } {2}
416 do_test rtree-8.5.5 { execsql { SELECT ii FROM t6 WHERE x1=5 } } {}
417 do_test rtree-8.5.6 { execsql { SELECT ii FROM t6 WHERE x1=''} } {}
418 do_test rtree-8.5.7 { execsql { SELECT ii FROM t6 WHERE x1=null}} {}
590 CREATE VIRTUAL TABLE t10 USING rtree(ii, x1, x2);
619 SELECT * FROM t10 WHERE ii=NULL;
622 SELECT * FROM t10 WHERE ii='xyz';
625 SELECT * FROM t10 WHERE ii='0.0';
628 SELECT * FROM t10 WHERE ii=0.0;
634 CREATE VIRTUAL TABLE t10 USING rtree_i32(ii, x1, x2);