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
Technical task
Major
