diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2021-02-25 12:42:01 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2021-02-25 12:42:01 +0530 |
| commit | 0a95c922c8a2c1625ec6756b1e5c523e1cc4f73d (patch) | |
| tree | eb29768b7a7e186b968ebd63e0deb1639463b888 | |
| parent | 577c970c520852b7bd9ad0b7e38d1883760b79bd (diff) | |
| download | mariadb-git-0a95c922c8a2c1625ec6756b1e5c523e1cc4f73d.tar.gz | |
Fixed the innodb_ext_key test by adding replace_column
| -rw-r--r-- | mysql-test/r/innodb_ext_key.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/innodb_ext_key.test | 1 |
2 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/innodb_ext_key.result b/mysql-test/r/innodb_ext_key.result index 880d7a8bceb..76e6cd000f9 100644 --- a/mysql-test/r/innodb_ext_key.result +++ b/mysql-test/r/innodb_ext_key.result @@ -804,5 +804,5 @@ PRIMARY KEY(pk) INSERT INTO t2 SELECT a,a FROM t1; EXPLAIN SELECT pk FROM t2 FORCE INDEX(k1); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 index NULL k1 23 NULL 10 Using index +1 SIMPLE t2 index NULL k1 23 NULL # Using index DROP TABLE t1,t2; diff --git a/mysql-test/t/innodb_ext_key.test b/mysql-test/t/innodb_ext_key.test index de9ca10ff1b..04ebcc1e41b 100644 --- a/mysql-test/t/innodb_ext_key.test +++ b/mysql-test/t/innodb_ext_key.test @@ -622,6 +622,7 @@ CREATE TABLE t2 ( )ENGINE=INNODB; INSERT INTO t2 SELECT a,a FROM t1; +--replace_column 9 # EXPLAIN SELECT pk FROM t2 FORCE INDEX(k1); DROP TABLE t1,t2; |