Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
--source include/have_partition.inc
|
|
INSTALL SONAME 'ha_connect'; |
|
CREATE TABLE t1 ( |
id INT, |
f VARCHAR(32), |
PRIMARY KEY (id DESC) |
) ENGINE=CONNECT TABLE_TYPE=DOS FILE_NAME='f.txt'; |
|
INSERT INTO t1 VALUES(1,'one'),(2,'two'),(3,'three'); |
|
SELECT * FROM t1 WHERE id >= 2; |
|
# Cleanup
|
DROP TABLE t1; |
UNINSTALL SONAME 'ha_connect'; |
The SELECT returns an empty result set
preview-10.8-MDEV-13756-desc-indexes c10e10c6 |
SELECT * FROM t1 WHERE id >= 2; |
id f
|
DROP TABLE t1; |
With an ascending key it returns two rows as expected:
SELECT * FROM t1 WHERE id >= 2; |
id f
|
2 two
|
3 three
|
DROP TABLE t1; |
Attachments
Issue Links
- causes
-
MDEV-30914 Server crashes in ha_connect::create upon DROP INDEX with alter_algorithm=COPY
- Open
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
- Closed