mariadb/mysql-test/suite
Yuchen Pei ec6f320883
MDEV-32732 Support DESC indexes in loose scan optimization
Extend loose index scan to support descending indexes.

This is achieved by removing a block skipping creating loose index
scan plan for descending index, as well as generalising the execution
of such plans.

The generalisation applies to all levels looking for min/max in loose
index scan. In the highest level (get_next), generalise min and max to
first and last, so that it still proceeds in the direction agreeing
with the index parity. In the lower levels, combine next_min and
next_max methods into next_min_max, and combine next_min_in_range and
next_max_in_range into next_min_max_in_range. This retains existing
logic of these functions and reduces code duplication, while allowing
handling of all four combinations (min, max) x (asc index, desc
index).
2025-04-28 13:30:58 +10:00
..
archive MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
atomic Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
binlog cleanup: select ... into tests 2025-02-11 20:31:25 +01:00
binlog_encryption Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
client MDEV-14978 fix client.client-env-variable test 2024-10-19 16:53:16 +02:00
compat MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-04-19 10:59:58 +04:00
csv MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
encryption Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
engines Fix typos in user-facing messages 2025-04-19 02:47:33 +04:00
events Merge 11.4 into 11.7 2024-12-02 17:51:17 +02:00
federated Merge 11.4 into 11.8 2025-03-05 20:39:47 +02:00
funcs_1 MDEV-10164: Add support for TRIGGERS that fire on multiple events 2025-04-19 18:36:03 +07:00
funcs_2 Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera Merge branch '11.8' into main 2025-04-18 17:11:01 +02:00
galera_3nodes Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera_3nodes_sr Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera_sr Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
gcol Merge 11.4 into 11.8 2025-03-05 20:39:47 +02:00
handler Merge 11.4 into 11.7 2025-01-09 09:41:38 +02:00
heap Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
innodb MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
innodb_fts Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
innodb_gis Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
innodb_i_s Merge 10.5 into 10.6 2023-04-11 16:15:19 +03:00
innodb_zip fix incorrect merge 15700f54c2 2025-04-18 09:41:24 +02:00
jp MDEV-33698 tests in the jp suite fail 2024-05-24 15:50:57 +04:00
json MariaDB 11.4.4 release 2024-11-08 07:17:00 +01:00
large_tests fix failing large_tests.maria_recover_encrypted 2024-04-22 18:38:39 +02:00
maria MDEV-32732 Support DESC indexes in loose scan optimization 2025-04-28 13:30:58 +10:00
mariabackup Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
merge MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
mtr/t Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
mtr2 Fix for overlayed include files on Windows and a test case 2013-11-10 14:37:32 +04:00
multi_source MDEV-36340: Reset Connects_Tried with Master_Retry_Count=X 2025-04-22 12:05:27 -06:00
optimizer_unfixed_bugs deprecate SQL_NOTES variable in favor of NOTE_VERBOSITY 2024-02-03 11:22:20 +01:00
parts MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
perfschema MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR 2025-04-19 10:59:58 +04:00
perfschema_stress
period cleanup: select ... into tests 2025-02-11 20:31:25 +01:00
plugins Merge 11.4 into 11.7 2025-01-09 09:41:38 +02:00
roles 12.0 branch 2025-02-12 12:37:38 +01:00
rpl Merge branch '11.8' into main 2025-04-18 17:11:01 +02:00
s3 Merge branch '11.7' into 11.8 2025-02-11 20:29:43 +01:00
sql_sequence Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
storage_engine MDEV-32104 remove deprecated features 2023-09-30 14:43:12 +02:00
stress MDEV-34453 Trying to read 16384 bytes at 70368744161280 outside the bounds of the file: ./ibdata1 2024-09-20 20:26:43 +05:30
sys_vars MDEV-14091 Support password protected SSL key in server. 2025-04-19 14:04:10 +03:00
sysschema MDEV-31736: format_bytes implementation 2024-11-26 13:10:01 +04:00
unit Merge branch '11.4' into 11.5 2024-08-05 17:50:18 +02:00
vcol fix incorrect merge 15700f54c2 2025-04-18 09:41:24 +02:00
versioning fix incorrect merge 15700f54c2 2025-04-18 09:41:24 +02:00
wsrep Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00