diff options
| author | Lena Startseva <lena.startseva@mariadb.com> | 2022-06-09 10:32:51 +0700 |
|---|---|---|
| committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-23 17:36:20 +0700 |
| commit | 72ba96a48eb3e99a967e0489cc79f378e865e3fd (patch) | |
| tree | d68b640bd3b6f71c4c7e13967776a13aa29965a2 /mysql-test/main/subselect_mat_cost_bugs.test | |
| parent | 1dd6255ffef901dddcff2191ddf975a2019799d9 (diff) | |
| download | mariadb-git-72ba96a48eb3e99a967e0489cc79f378e865e3fd.tar.gz | |
MDEV-27691: make working view-protocol
Tests with checking metadata or that cannot be run with
the view-protocol are excluded from --view-protocol.
For tests that do not allow the use of an additional connection,
the util connection is disabled with "--disable_service_connection".
Also cases with bugs for --view-protocol are disabled.
Diffstat (limited to 'mysql-test/main/subselect_mat_cost_bugs.test')
| -rw-r--r-- | mysql-test/main/subselect_mat_cost_bugs.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/subselect_mat_cost_bugs.test b/mysql-test/main/subselect_mat_cost_bugs.test index 028cdced560..5c5777397e8 100644 --- a/mysql-test/main/subselect_mat_cost_bugs.test +++ b/mysql-test/main/subselect_mat_cost_bugs.test @@ -442,10 +442,13 @@ INSERT INTO t1 VALUES (1,'foo','bar'),(2,'bar','foo'); CREATE TABLE t2 (pk2 INT PRIMARY KEY, a2 VARCHAR(3), KEY(a2)) ENGINE=MyISAM; INSERT INTO t2 VALUES (1,'abc'),(2,'xyz'),(3,'foo'); +#enable after fix MDEV-27871 +--disable_view_protocol SELECT 'qux' IN ( SELECT a1 FROM t1 INNER JOIN t2 WHERE a2 = b1 AND pk2 = 3 ); SELECT 'bar' IN ( SELECT a1 FROM t1 INNER JOIN t2 WHERE a2 = b1 AND pk2 = 3 ); EXPLAIN SELECT 'bar' IN ( SELECT a1 FROM t1 INNER JOIN t2 WHERE a2 = b1 AND pk2 = 3 ); +--enable_view_protocol DROP TABLE t1,t2; |