Add array_agg test to AbstractTestQueries
@@ -643,6 +643,12 @@ public abstract class AbstractTestQueries
assertQuery("SELECT CARDINALITY(a) FROM (SELECT ARRAY[orderkey, orderkey + 1] AS a FROM orders ORDER BY orderkey) t", "SELECT 2 FROM orders");
}
+ @Test
+ public void testArrayAgg()
+ {
+ assertQuery("SELECT clerk, cardinality(array_agg(orderkey)) FROM orders GROUP BY clerk", "SELECT clerk, count(*) FROM orders GROUP BY clerk");
+ }
+
@Test
public void testRows()
{
