Lines Matching refs:i2
38 CREATE INDEX i2 ON t1(b);
51 | `--SEARCH t1 USING INDEX i2 (b=?)
63 `--SEARCH t1 USING INDEX i2 (b=?)
508 # XVIDENCE-OF: R-21179-11011 sqlite> CREATE INDEX i2 ON t1(a, b);
510 # 0|0|0|SEARCH t1 USING COVERING INDEX i2 (a=?)
512 do_execsql_test 5.3.0 { CREATE INDEX i2 ON t1(a, b) }
514 0 0 0 {SEARCH t1 USING COVERING INDEX i2 (a=?)}
519 # 0|0|0|SEARCH t1 USING COVERING INDEX i2 (a=? AND b>?)
524 0 0 0 {SEARCH t1 USING COVERING INDEX i2 (a=? AND b>?)}
530 # 0|0|1|SEARCH t1 USING COVERING INDEX i2 (a=? AND b>?)
534 0 0 1 {SEARCH t1 USING COVERING INDEX i2 (a=? AND b>?)}
540 # 0|0|0|SEARCH t1 USING COVERING INDEX i2 (a=?)
545 0 0 0 {SEARCH t1 USING COVERING INDEX i2 (a=?)}
572 # 1|0|0|SEARCH t1 USING COVERING INDEX i2 (a=?)
581 1 0 0 {SEARCH t1 USING COVERING INDEX i2 (a=?)}
588 # 1|0|0|SCAN t1 USING COVERING INDEX i2
595 1 0 0 {SCAN t1 USING COVERING INDEX i2}
607 0 1 1 {SCAN t1 USING COVERING INDEX i2}
617 1 0 0 {SCAN t1 USING COVERING INDEX i2}
624 # 1|0|0|SCAN t1 USING COVERING INDEX i2
670 1 0 0 SCAN t1 USING COVERING INDEX i2