diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2021-01-09 00:36:13 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2021-01-11 13:23:06 +0530 |
| commit | 7220e3719d312e194c0ce00c0c66a770360835fa (patch) | |
| tree | b5ad8ec9efebd4ca671e5f54acee4a4e1a17fc39 /mysql-test/main/join_cardinality.test | |
| parent | 8b7ad4e69750dcf6663203de5f4a1a082bf383be (diff) | |
| download | mariadb-git-7220e3719d312e194c0ce00c0c66a770360835fa.tar.gz | |
Addressing review
Diffstat (limited to 'mysql-test/main/join_cardinality.test')
| -rw-r--r-- | mysql-test/main/join_cardinality.test | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/join_cardinality.test b/mysql-test/main/join_cardinality.test index 696025bdecf..d0f8b74e99b 100644 --- a/mysql-test/main/join_cardinality.test +++ b/mysql-test/main/join_cardinality.test @@ -1,16 +1,16 @@ --source include/have_sequence.inc +# Default settings for all following tests +SET @save_optimizer_switch=@@optimizer_switch; +SET optimizer_trace=1; +SET optimizer_switch='rowid_filter=off'; + CREATE TABLE t1(a INT, b INT, c INT, KEY(b), KEY(a)); INSERT INTO t1 SELECT seq, seq, seq from seq_1_to_100; CREATE TABLE t2(a INT, b INT, key(b)); INSERT INTO t2 SELECT seq, seq from seq_1_to_100; - -SET @save_optimizer_switch=@@optimizer_switch; -SET optimizer_trace=1; -SET optimizer_switch='rowid_filter=off'; - --echo # --echo # RUNNING the join cardinality tests when statistics are --echo # available only from indexes @@ -224,7 +224,7 @@ DROP VIEW v1; --echo # ---echo # TESTS to get ndv from rec_per_key +--echo # TESTS to get Number of distinct values(ndv) from rec_per_key --echo # CREATE TABLE t1 (a INT, b INT); |