EVOLUTION-MANAGER

Edit File: 895.result

SET DEFAULT_STORAGE_ENGINE = 'tokudb'; DROP TABLE IF EXISTS t; CREATE TABLE t (r INT, s INT, t BIGINT, PRIMARY KEY (r, s)); INSERT INTO t VALUES (1,2,3),(4,5,6); EXPLAIN SELECT * FROM t WHERE r > 0; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t range PRIMARY PRIMARY 4 NULL NULL; Using where CREATE INDEX it on t(t); EXPLAIN SELECT * FROM t WHERE r > 0; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t range PRIMARY PRIMARY 4 NULL NULL; Using where DROP TABLE t;