diff options
| -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; |