Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.3.2
-
None
Description
|
12.3 view protocol |
CURRENT_TEST: main.index_intersect_innodb
|
--- /home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/main/index_intersect_innodb.result 2026-07-21 05:31:43.000000000 +0000
|
+++ /home/buildbot/amd64-debian-12-debug-embedded/build/mysql-test/main/index_intersect_innodb.reject 2026-07-21 05:44:55.303420721 +0000
|
@@ -491,7 +491,7 @@
|
WHERE ID BETWEEN 3001 AND 4000 AND Population > 600000
|
AND Country BETWEEN 'S' AND 'Z' ;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE City index_merge PRIMARY,Population,Country PRIMARY,Population 4,4 NULL # Using sort_intersect(PRIMARY,Population); Using where
|
+1 SIMPLE City range PRIMARY,Population,Country PRIMARY 4 NULL # Using where
|
SELECT * FROM City USE INDEX ()
|
WHERE ID BETWEEN 501 AND 1000 AND Population > 700000 AND Country LIKE 'C%';
|
ID Name Country Population
|
Result length mismatch
|
Looks like MDEV-39673 - a stable statistics problem
[Cross reference results](https://buildbot.mariadb.org/cr/?branch=&revision=&platform=&dt=&max_dt=&bbnum=&typ=&info=&test_name=main.index_intersect_innodb&test_variant=&info_text=&failure_text=&limit=100&sort_order=desc#).
A few non-view protcol failures. Also 12.3+ seems to be mostly aarch64. Might be statistics too.
Attachments
Issue Links
- relates to
-
MDBF-1201 add --view tests to branch protection
-
- Closed
-
-
MDEV-23921 main.index_intersect and index_intersect_innodb failed with 'index_merge' when expecting 'range' and 'Country,Name' in wrong order on hppa and armhf
-
- Open
-
-
MDEV-39763 main.innodb_mrr_cpk fails under view protocol
-
- Closed
-