@Test
public void testTooManyGroupingElements()
{
Session session = testSessionBuilder(new SessionPropertyManager(new SystemSessionProperties(
new QueryManagerConfig(),
new TaskManagerConfig(),
new MemoryManagerConfig(),
new FeaturesConfig().setMaxGroupingSets(2048)))).build();
analyze(session, "SELECT a, b, c, d, e, f, g, h, i, j, k, SUM(l)" +
"FROM (VALUES (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12))\n" +
"t (a, b, c, d, e, f, g, h, i, j, k, l)\n" +
"GROUP BY CUBE (a, b, c, d, e, f), CUBE (g, h, i, j, k)");
assertFails(session, TOO_MANY_GROUPING_SETS,
"line 3:10: GROUP BY has 4096 grouping sets but can contain at most 2048",
"SELECT a, b, c, d, e, f, g, h, i, j, k, l, SUM(m)" +
"FROM (VALUES (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13))\n" +
"t (a, b, c, d, e, f, g, h, i, j, k, l, m)\n" +
"GROUP BY CUBE (a, b, c, d, e, f), CUBE (g, h, i, j, k, l)");
assertFails(session, TOO_MANY_GROUPING_SETS,
format("line 3:10: GROUP BY has more than %s grouping sets but can contain at most 2048", Integer.MAX_VALUE),
"SELECT a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, " +
"q, r, s, t, u, v, x, w, y, z, aa, ab, ac, ad, ae, SUM(af)" +
"FROM (VALUES (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, " +
"17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32))\n" +
"t (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, " +
"q, r, s, t, u, v, x, w, y, z, aa, ab, ac, ad, ae, af)\n" +
"GROUP BY CUBE (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, " +
"q, r, s, t, u, v, x, w, y, z, aa, ab, ac, ad, ae)");
}