summaryrefslogtreecommitdiff
path: root/mysql-test/main/subselect_sj2.test
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2019-02-14 15:23:23 -0800
committerIgor Babaev <igor@askmonty.org>2019-02-14 15:23:23 -0800
commitccce4d3be9bb5dfce66576f9744bcb927b754cf4 (patch)
tree6f66a954aed4f99ff06a215d2be603c9fa18c6b2 /mysql-test/main/subselect_sj2.test
parente1de23b8d51c53b87a9d54352af0e99d4386e0ee (diff)
downloadmariadb-git-ccce4d3be9bb5dfce66576f9744bcb927b754cf4.tar.gz
MDEV-16188 Post review fixes
Also adjusted some test files.
Diffstat (limited to 'mysql-test/main/subselect_sj2.test')
-rw-r--r--mysql-test/main/subselect_sj2.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/subselect_sj2.test b/mysql-test/main/subselect_sj2.test
index e7dd6e78664..2b4f619a615 100644
--- a/mysql-test/main/subselect_sj2.test
+++ b/mysql-test/main/subselect_sj2.test
@@ -995,6 +995,8 @@ CREATE TABLE t3 (f12 varchar(1) NOT NULL) ENGINE=InnoDB;
INSERT INTO t3 VALUES ('r'),('s'),('t'),('v'),('w'),('x'),('y');
--echo # The following must use LooseScan but not join buffering
+
+--replace_column 9 #
explain
SELECT * FROM t3
WHERE f12 IN (SELECT alias2.f12 FROM t1 AS alias1, t2 AS alias2, t1 WHERE alias1.f13 = 24);