diff options
author | Sergei Golubchik <serg@mariadb.org> | 2022-01-01 17:20:52 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2022-01-26 18:43:06 +0100 |
commit | b18697fd3eb9bc2d88c03869109bcebcdf55a9a1 (patch) | |
tree | a12e81450bd5f00c1e817db28d1d76e637ad5a72 /mysql-test/suite/federated | |
parent | f00236ac230ebc48cd30fb72166fc1106141c365 (diff) | |
download | mariadb-git-b18697fd3eb9bc2d88c03869109bcebcdf55a9a1.tar.gz |
MDEV-27398 DESC index causes wrong (empty) result on Federated tables
take descending indexes into account when generating a query
Diffstat (limited to 'mysql-test/suite/federated')
-rw-r--r-- | mysql-test/suite/federated/indexes.result | 33 | ||||
-rw-r--r-- | mysql-test/suite/federated/indexes.test | 22 |
2 files changed, 55 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/indexes.result b/mysql-test/suite/federated/indexes.result new file mode 100644 index 00000000000..d5ebbeeb6dc --- /dev/null +++ b/mysql-test/suite/federated/indexes.result @@ -0,0 +1,33 @@ +# +# MDEV-27398 DESC index causes wrong (empty) result on Federated tables +# +create table t (a int); +insert into t values (1),(5),(2),(3),(4); +create table tf (a int, key(a desc)) connection 'mysql://root@127.0.0.1:$MASTER_MYPORT/test/t' engine=Federated; +select * from tf; +a +1 +2 +3 +4 +5 +select * from tf where a > 2; +a +3 +4 +5 +select * from tf where a < 3; +a +1 +2 +select * from tf where a >= 3; +a +3 +4 +5 +select * from tf where a <= 3; +a +1 +2 +3 +drop table tf, t; diff --git a/mysql-test/suite/federated/indexes.test b/mysql-test/suite/federated/indexes.test new file mode 100644 index 00000000000..2ad2f823acf --- /dev/null +++ b/mysql-test/suite/federated/indexes.test @@ -0,0 +1,22 @@ +--source include/not_embedded.inc +--source suite/federated/have_federatedx.inc + +--echo # +--echo # MDEV-27398 DESC index causes wrong (empty) result on Federated tables +--echo # + +create table t (a int); +insert into t values (1),(5),(2),(3),(4); + +--evalp create table tf (a int, key(a desc)) connection 'mysql://root@127.0.0.1:$MASTER_MYPORT/test/t' engine=Federated +--sorted_result +select * from tf; +--sorted_result +select * from tf where a > 2; +--sorted_result +select * from tf where a < 3; +--sorted_result +select * from tf where a >= 3; +--sorted_result +select * from tf where a <= 3; +drop table tf, t; |