Lines Matching refs:x1
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);
185 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
211 } {1 {rtree constraint failed: t1.(x1<=x2)}}
227 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
256 execsql { CREATE VIRTUAL TABLE t2 USING rtree(ii, x1, x2) }
292 execsql { CREATE VIRTUAL TABLE t3 USING rtree(ii, x1, x2, y1, y2) }
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}} {}
459 catchsql { CREATE VIRTUAL TABLE t7 USING rtree(index, x1, y1, x2, y2) }
467 CREATE VIRTUAL TABLE t8 USING rtree(idx, x1, x2, y1, y2);
484 CREATE VIRTUAL TABLE t1 USING rtree_i32(idx, x1, x2, y1, y2);
492 CREATE TABLE source(idx, x1, x2, y1, y2);
552 set res(2) {1 {rtree constraint failed: t1.(x1<=x2)}}
590 CREATE VIRTUAL TABLE t10 USING rtree(ii, x1, x2);
634 CREATE VIRTUAL TABLE t10 USING rtree_i32(ii, x1, x2);
650 CREATE VIRTUAL TABLE rt USING rtree(id, x1,x2, y1,y2);
665 CREATE VIRTUAL TABLE t16 USING rtree(id,x0,x1,y0,+aux1,x1);
692 CREATE VIRTUAL TABLE rt1 USING rtree(id, x1, x2, +aux);
702 CREATE VIRTUAL TABLE t1 USING rtree(id, x1 PRIMARY KEY, x2, y1, y2);
703 CREATE VIRTUAL TABLE t2 USING rtree(id, x1, x2, y1, y2 UNIQUE);
740 CREATE VIRTUAL TABLE rt0 USING rtree(id, x0, x1);