diff options
| author | Monty <monty@mariadb.org> | 2021-04-19 14:31:57 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2021-04-19 14:31:57 +0300 |
| commit | 0620ccf3eabe79f94924acbd641a13f4c69572c9 (patch) | |
| tree | 729ee4c3d5dc021c9c373e3f69feffffdcb99851 | |
| parent | fce3e4ee8ffcda6d0c92d314b4ce8874a6bc91da (diff) | |
| download | mariadb-git-0620ccf3eabe79f94924acbd641a13f4c69572c9.tar.gz | |
Fixed failing test spider/bugfix.mdev_22246
This was caused by MDEV-23634, which disabled index optimization for
index != constant.
| -rw-r--r-- | storage/spider/mysql-test/spider/bugfix/r/mdev_22246.result | 2 | ||||
| -rw-r--r-- | storage/spider/mysql-test/spider/bugfix/t/mdev_22246.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/storage/spider/mysql-test/spider/bugfix/r/mdev_22246.result b/storage/spider/mysql-test/spider/bugfix/r/mdev_22246.result index 4884f60637e..0254d8bfd1c 100644 --- a/storage/spider/mysql-test/spider/bugfix/r/mdev_22246.result +++ b/storage/spider/mysql-test/spider/bugfix/r/mdev_22246.result @@ -47,7 +47,7 @@ SELECT * FROM tbl_a; id node 2 DB-G1 1 DB-G0 -SELECT * FROM tbl_a WHERE id != 0; +SELECT * FROM tbl_a WHERE id <0 || id >0; id node 1 DB-G0 2 DB-G1 diff --git a/storage/spider/mysql-test/spider/bugfix/t/mdev_22246.test b/storage/spider/mysql-test/spider/bugfix/t/mdev_22246.test index 63b04c14e11..9e58bc1a836 100644 --- a/storage/spider/mysql-test/spider/bugfix/t/mdev_22246.test +++ b/storage/spider/mysql-test/spider/bugfix/t/mdev_22246.test @@ -64,7 +64,7 @@ TRUNCATE TABLE mysql.general_log; --connection master_1 SELECT * FROM tbl_a; -SELECT * FROM tbl_a WHERE id != 0; +SELECT * FROM tbl_a WHERE id <0 || id >0; --connection child2_1 eval $CHILD2_1_SELECT_TABLES; |