// the following queries all return no rows in H2 selectConstAggregationWithGroupBy SELECT 1 a, COUNT(*) b, MAX(1) c FROM empty_mapping GROUP BY a; a:i | b:l | c:i ---------------+---------------+--------------- 1 |2 |1 ; subselectWithConst SELECT 1, * FROM (SELECT * FROM empty_mapping) s; 1:i --------------- 1 1 ; subselectWithInnerConst SELECT * FROM (SELECT 1, * FROM empty_mapping) s; 1:i --------------- 1 1 ;