RootCauseunvalidated
The `rollup` clause adds the sum rows. — group by rollup(col_1, col_2). Tension: the resultset contains only either the normal rows (`0 = 0`) or the grand total row (`1 = 1`), but not the subtotals (`1 != 0` or `0 != 1`). Outcome: The condition `grouping(col_1) = grouping(col_2)` ensures.
e3b76ba8-c2f6-4a83-930c-e07778d35549
The rollup clause adds the sum rows. — group by rollup(col_1, col_2). Tension: the resultset contains only either the normal rows (0 = 0) or the grand total row (1 = 1), but not the subtotals (1 != 0 or 0 != 1). Outcome: The condition grouping(col_1) = grouping(col_2) ensures.