Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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
|