CREATE TABLE t1 (i INT PRIMARY KEY) ENGINE=LevelDB;
|
INSERT INTO t1 VALUES (1),(3);
|
CREATE TABLE t2 (j INT PRIMARY KEY) ENGINE=LevelDB;
|
INSERT INTO t2 VALUES (1),(4);
|
|
EXPLAIN EXTENDED
|
SELECT * FROM t1, t2 WHERE i=j;
|
# id select_type table type possible_keys key key_len ref rows filtered Extra
|
# 1 SIMPLE t1 ALL PRIMARY NULL NULL NULL 1000 100.00 NULL
|
# 1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.i 1 100.00 NULL
|
# Warnings:
|
# Note 1003 /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t2`.`j` AS `j` from `test`.`t1` join `test`.`t2` where (`test`.`t2`.`j` = `test`.`t1`.`i`)
|
|
SELECT * FROM t1, t2 WHERE i=j;
|
# i j
|
|