bug: 2022-09-26 The associated query of multiple tables of the Tianmu engine is slow

[adofsauron]

Describe the problem

Mysql Column Storage engine - Multiple table JOIN query slow - Locate the cause

SELECT
	contract.id,
	SUM(item_quantity) AS total_nums,
	SUM(detail_price) AS total_prices
FROM
	contract
JOIN contract_detail ON
	contract.id = contract_detail.contract_id
JOIN day_dimension ON
	contract_detail.sign_day = day_dimension.day_str
GROUP BY
	contract.id;

Expected behavior

No response

How To Reproduce

No response

Environment

No response

Are you interested in submitting a PR to solve the problem?

• Yes, I will!

[konghaiya]

ACK