#4940 - XML DB aggregate expression support

Identifier #4940
Issue type Feature request or suggestion
Title XML DB aggregate expression support
Status Open
Handling member Deleted
Addon core_database_drivers
Description Currently the XML database driver does not support expressions involving aggregate functions.

Consider this query we were considering doing...

SELECT recipient_id,SUM(amount_points)+SUM(gift_points)-(SELECT SUM(amount_points)+SUM(gift_points) FROM cms11_points_ledger refund WHERE refund.status='refund' AND refund.date_and_time>=START AND refund.date_and_time<END AND refund.recipient_id=normal.recipient_id) AS points FROM cms11_points_ledger normal WHERE normal.status='normal' AND normal.date_and_time>=START AND normal.date_and_time<END GROUP BY recipient_id ORDER BY points DESC;

We cannot do that because of the limitation in the XML database driver.
Steps to reproduce

Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated