Lines Matching refs:i1
47 CREATE INDEX i1 ON t1(a, b);
58 t1 i1 {1 1 1} {0 0 0} {0 0 0} {(0) (0) 1}
59 t1 i1 {1 1 1} {1 1 1} {1 1 1} {(1) (1) 2}
60 t1 i1 {1 1 1} {2 2 2} {2 2 2} {(2) (2) 3}
61 t1 i1 {1 1 1} {3 3 3} {3 3 3} {(3) (3) 4}
62 t1 i1 {1 1 1} {4 4 4} {4 4 4} {(4) (4) 5}
69 t1 i1 {1 1 1} {0 0 0} {0 0 0} ....(0)(0)
70 t1 i1 {1 1 1} {1 1 1} {1 1 1} ....(1)(1).
71 t1 i1 {1 1 1} {2 2 2} {2 2 2} ....(2)(2).
72 t1 i1 {1 1 1} {3 3 3} {3 3 3} ....(3)(3).
73 t1 i1 {1 1 1} {4 4 4} {4 4 4} ....(4)(4).
86 CREATE INDEX i1 ON t1(a, b, c);
165 CREATE INDEX i1 ON t1(c, b, a);
266 CREATE INDEX i1 ON t1(o);
301 CREATE INDEX i1 ON t1(a);
332 CREATE INDEX i1 ON t1(a, b);
377 CREATE INDEX i1 ON t1(x);
394 CREATE INDEX i1 ON t1(a, b, c, d);
417 } {/t1 USING INDEX i1/}
426 } {/t1 USING INDEX i1/}
570 CREATE INDEX i1 ON t1(a);
581 } {/SEARCH t1 USING INDEX i1/}
584 } {/SEARCH t1 USING INDEX i1/}
605 CREATE INDEX i1 ON t1(a, b);
612 } {/SEARCH t1 USING INDEX i1/}
615 } {/SEARCH t1 USING INDEX i1/}
655 #puts "HAVE: [db eval {SELECT test_decode(sample) FROM sqlite_stat4 WHERE idx='i1'}]"
657 db eval {SELECT test_decode(sample) AS s FROM sqlite_stat4 WHERE idx='i1'} {
678 CREATE INDEX i1 ON t1(a,b,c,d);
823 CREATE INDEX i1 ON t1(a, b) WHERE d IS NOT NULL;
846 } {/USING INDEX i1/}
849 } {/USING INDEX i1/}
857 } {/USING INDEX i1/}
868 CREATE INDEX i1 ON t1(a, b);
901 CREATE INDEX i1 ON t1(x, y);
932 CREATE INDEX i1 ON t1(a,b,c,d);
1205 CREATE INDEX i1 ON t1(x, y);
1232 } {SEARCH t1 USING INDEX i1 (x=? AND y>?)}