tcph's q11 query fails with enabled QA:

ubuntu@ip-172-31-13-58:~/MariaDBEnterprise/storage/columnstore/columnstore/tests/scripts$ sudo ./run_mtr.sh --record --test_full_name future.query_accelerator
・ Adding mtr warnings functions...
patching file mtr_warnings.sql
Hunk #2 succeeded at 269 (offset -2 lines).
/usr/share/mariadb/mariadb-test
MTR Warnings function added
・ Test results are RECORDED
・ Running suite future with test query_accelerator and --extern=false
Logging: ./mtr --force --record --max-test-fail=0 --testcase-timeout=60 --suite=columnstore/future query_accelerator
VS config:
vardir: /usr/share/mariadb/mariadb-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/share/mariadb/mariadb-test/var'...
Checking supported features...
MariaDB Version 11.4.9-5-MariaDB-enterprise

- SSL connections supported
  Collecting tests...
  Installing system database...

==============================================================================

## TEST RESULT TIME (ms) or COMMENT

worker[01] Using MTR*BUILD_THREAD 300, with reserved ports 19000..19029
worker[01] mysql-test-run: WARNING: running this script as \_root* will cause some tests to be skipped
columnstore/future.query_accelerator [ fail ]
Test ended at 2025-1

CURRENT_TEST: columnstore/future.query_accelerator
mysqltest: At line 234: query 'SELECT
ps_partkey,
SUM(ps_supplycost _ ps_availqty) AS value
FROM partsupp, supplier, nation
WHERE ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_name = 'GERMANY'
GROUP BY ps_partkey
HAVING SUM(ps_supplycost _ ps_availqty) > (
SELECT SUM(ps_supplycost _ ps_availqty) _ 0.0001
FROM partsupp, supplier, nation
WHERE ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_name = 'GERMANY'
)
ORDER BY value DESC, ps_partkey' failed: ER_INTERNAL_ERROR (1815): Internal error: MCS-1000: 'nation, sub-query, supplier' and 'partsupp' are not joined.

The result from queries just before the failure was:
< snip >
13478 Customer#000013478 395513.1358 -778.11 KENYA 9VIsvIeZrJpC6OOdYheMC2vdtq8Ai0Rt 24-983-202-8240 r theodolites. slyly unusual pinto beans sleep fluffily against the asymptotes. quickly r
SELECT "QUERY 11";
QUERY 11
QUERY 11
SELECT
ps_partkey,
SUM(ps_supplycost _ ps_availqty) AS value
FROM partsupp, supplier, nation
WHERE ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_name = 'GERMANY'
GROUP BY ps_partkey
HAVING SUM(ps_supplycost _ ps_availqty) > (
SELECT SUM(ps_supplycost _ ps_availqty) _ 0.0001
FROM partsupp, supplier, nation
WHERE ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_name = 'GERMANY'
)
ORDER BY value DESC, ps_partkey;

More results from queries before failure can be found in /usr/share/mariadb/mariadb-test/var/log/query_accelerator.log

- saving '/usr/share/mariadb/mariadb-test/var/log/columnstore/future.query_accelerator/' to '/usr/share/mariadb/mariadb-test/var/log/future.query_accelerator/'

---

The servers were restarted 0 times
Spent 0.000 of 42 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): columnstore/future.query_accelerator

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, MariaDB's bug tracker is found at
https://jira.mariadb.org

mysql-test-run: \*\*\* ERROR: there were failing test cases
・ reports or coredumps:
no new reports or coredumps
/tmp
ubuntu@ip-172-31-13-58:~/MariaDBEnterprise/storage/columnstore/columnstore/tests/scripts$

==============================================================================================================

ubuntu@ip-172-31-13-58:~/MariaDBEnterprise/storage/columnstore/columnstore/tests/scripts$ cat /usr/share/mariadb/mariadb-test/var/log/query_accelerator.log

<<<removed logs from previous successfull querries>>>

SELECT "QUERY 11";
QUERY 11
QUERY 11
SELECT
ps_partkey,
SUM(ps_supplycost _ ps_availqty) AS value
FROM partsupp, supplier, nation
WHERE ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_name = 'GERMANY'
GROUP BY ps_partkey
HAVING SUM(ps_supplycost _ ps_availqty) > (
SELECT SUM(ps_supplycost _ ps_availqty) _ 0.0001
FROM partsupp, supplier, nation
WHERE ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_name = 'GERMANY'
)
ORDER BY value DESC, ps_partkey;
ubuntu@ip-172-31-13-58:~/MariaDBEnterprise/storage/columnstore/columnstore/tests/scripts$