With Drupal 9.5.3, a group by like this:

$query->groupBy("myfieldname WITH ROLLUP");

will result in

(...) Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'myfieldnameWITHROLLUP' (...)

... since spaces are stripped.

Is there any other proper way to add the "WITH ROLLUP"?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.