Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.8.1, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (id INT, f VARCHAR(64), PRIMARY KEY (id DESC), FULLTEXT ft(f)) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1,'foo'),(2,'bar'); |
DELETE FROM t1 WHERE id = 2; |
ALTER TABLE t1 DROP INDEX ft; |
ALTER TABLE t1 ADD FULLTEXT INDEX ft (f); |
INSERT INTO t1 values (3,'innodb ft search'); |
ANALYZE TABLE t1; |
SELECT * FROM t1 WHERE MATCH(f) AGAINST("+innodb +search" IN BOOLEAN MODE); |
|
DROP TABLE t1; |
SELECT returns an empty result set
preview-10.8-MDEV-13756-desc-indexes c10e10c6 |
SELECT * FROM t1 WHERE MATCH(f) AGAINST("+innodb +search" IN BOOLEAN MODE); |
id f
|
Normally it should return a row:
SELECT * FROM t1 WHERE MATCH(f) AGAINST("+innodb +search" IN BOOLEAN MODE); |
id f
|
3 innodb ft search
|
Not reproducible with an ascending PK.
Not reproducible with otherwise the same test case without re-creating the key.
Not reproducible on MySQL 8.0.
Attachments
Issue Links
- relates to
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
- Closed