Q13



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 20:58:42

CURRENT_TEST: columnstore/future.query_accelerator
mysqltest: At line 270: query 'SELECT
c_count,
COUNT(*) AS custdist
FROM (
SELECT c_custkey, COUNT(o_orderkey) AS c_count
FROM customer LEFT OUTER JOIN orders
ON c_custkey = o_custkey
AND o_comment NOT LIKE '%special%requests%'
        GROUP BY c_custkey
) AS c_orders
GROUP BY c_count
ORDER BY custdist DESC, c_count DESC' failed: ER_INTERNAL_ERROR (1815): Internal error: MCS-1000: 'customer, orders' and 'sub-query' are not joined.

The result from queries just before the failure was:
< snip >
l_shipmode	high_line_count	low_line_count
MAIL	647	945
SHIP	620	943
set columnstore_unstable_optimizer=on;
set optimizer_switch="index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_merge_sort_intersection=off,index_condition_pushdown=off,derived_merge=off,derived_with_keys=off,firstmatch=off,loosescan=off,materialization=on,in_to_exists=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=off,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=off,join_cache_hashed=off,join_cache_bka=off,optimize_join_buffer_size=off,table_elimination=off,extended_keys=off,exists_to_in=off,orderby_uses_equalities=off,condition_pushdown_for_derived=on,split_materialized=off,condition_pushdown_for_subquery=off,rowid_filter=off,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=off,cset_narrowing=off,sargable_casefold=off";
SELECT  "QUERY 13";
QUERY 13
QUERY 13
SELECT
c_count,
COUNT(*) AS custdist
FROM (
SELECT c_custkey, COUNT(o_orderkey) AS c_count
FROM customer LEFT OUTER JOIN orders
ON c_custkey = o_custkey
AND o_comment NOT LIKE '%special%requests%'
        GROUP BY c_custkey
) AS c_orders
GROUP BY c_count
ORDER BY custdist DESC, c_count DESC;

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