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-11-12 21:09:38

CURRENT_TEST: columnstore/future.query_accelerator
mysqltest: At line 352: query 'SELECT
c_name,
c_custkey,
o_orderkey,
o_orderdate,
o_totalprice,
SUM(l_quantity) AS quantity
FROM customer, orders, lineitem
WHERE o_orderkey IN (
SELECT l_orderkey
FROM lineitem
GROUP BY l_orderkey HAVING SUM(l_quantity) > 300
)
AND c_custkey = o_custkey
AND o_orderkey = l_orderkey
GROUP BY c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice
ORDER BY o_totalprice DESC, o_orderdate, o_orderkey
LIMIT 100' failed: ER_INTERNAL_ERROR (1815): Internal error: MCS-1000: 'sub-query' and '$added_sub_tpchqa_lineitem_0' are not joined.

The result from queries just before the failure was:
< snip >
QUERY 18
QUERY 18
SELECT
c_name,
c_custkey,
o_orderkey,
o_orderdate,
o_totalprice,
SUM(l_quantity) AS quantity
FROM customer, orders, lineitem
WHERE o_orderkey IN (
SELECT l_orderkey
FROM lineitem
GROUP BY l_orderkey HAVING SUM(l_quantity) > 300
)
AND c_custkey = o_custkey
AND o_orderkey = l_orderkey
GROUP BY c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice
ORDER BY o_totalprice DESC, o_orderdate, o_orderkey
LIMIT 100;

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 55 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$