Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.8(EOL)
Description
install soname 'ha_spider'; |
|
set spider_use_handler=3; |
set spider_same_server_link= 1; |
|
create table t (a int, b char(1), primary key(a)); |
insert into t VALUES (1,'f'),(2,'g'),(3,'j'), (4,'i'),(5,'h'); |
|
eval create server s foreign data wrapper mysql options |
(host '127.0.0.1', database 'test', user 'root', port $MASTER_MYPORT); |
|
create table ts (a int, b char(1), primary key(a desc)) |
engine=Spider COMMENT='wrapper "mysql", srv "s", table "t"'; |
|
select a, b from ts where a > 0 and b = 'g' order by a; |
The query returns an empty result set.
preview-10.8-MDEV-13756-desc-indexes 1c4cbb94655 |
a b
|
The expected result is (2, 'g') row.
Attachments
Issue Links
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
- Closed