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

revision-id: psergey@askmonty.org-20121221152341-9stvnkuiinslrt9h

date: 2012-12-21 19:23:41 +0400

build-date: 2012-12-21 22:11:06 +0400

revno: 4471

branch: mysql-5.6-leveldb