diff options
| author | unknown <holyfoot/hf@hfmain.(none)> | 2008-02-18 19:08:35 +0400 |
|---|---|---|
| committer | unknown <holyfoot/hf@hfmain.(none)> | 2008-02-18 19:08:35 +0400 |
| commit | 78d12b299e80751da53b378baa9d4a03a050b3cc (patch) | |
| tree | 15a412769b910a727666b2b1ca290fc249adc643 /mysql-test/r/select.result | |
| parent | 9b9f08e7ad5d207145a2dffd65ce9576ad44b4fb (diff) | |
| parent | 16f69a3d54041d15b48a43f3f0ba6550348ab022 (diff) | |
| download | mariadb-git-78d12b299e80751da53b378baa9d4a03a050b3cc.tar.gz | |
Merge bk@192.168.21.1:mysql-5.1-opt
into mysql.com:/home/hf/work/32942/my51-32942
sql/sql_select.cc:
Auto merged
mysql-test/r/select.result:
merging
mysql-test/t/select.test:
merging
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index e56c1629a64..73a2e93e19e 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -4319,6 +4319,27 @@ SELECT * FROM t1 WHERE a IN (CONCAT('foo', 0), 'bar'); a foo0 DROP TABLE t1; +CREATE TABLE t1 (a INT, b INT); +CREATE TABLE t2 (a INT, c INT, KEY(a)); +INSERT INTO t1 VALUES (1, 1), (2, 2); +INSERT INTO t2 VALUES (1, 1), (1, 2), (1, 3), (1, 4), (1, 5), +(2, 1), (2, 2), (2, 3), (2, 4), (2, 5), +(3, 1), (3, 2), (3, 3), (3, 4), (3, 5), +(4, 1), (4, 2), (4, 3), (4, 4), (4, 5); +FLUSH STATUS; +SELECT DISTINCT b FROM t1 LEFT JOIN t2 USING(a) WHERE c <= 3; +b +1 +2 +SHOW STATUS LIKE 'Handler_read%'; +Variable_name Value +Handler_read_first 0 +Handler_read_key 2 +Handler_read_next 0 +Handler_read_prev 0 +Handler_read_rnd 0 +Handler_read_rnd_next 6 +DROP TABLE t1, t2; End of 5.0 tests create table t1(a INT, KEY (a)); INSERT INTO t1 VALUES (1),(2),(3),(4),(5); |