‘ONLY_FULL_GROUP_BY’ is not present.

reported by an alpha customer in google groups:

I plan to use the Columnstore as a DB backend to Pentaho, an open source Business Intelligence platform. The current Alpha release is working smoothly for a lot of things, the performance is great, I am happy with it. But, in some cases the BI solution (the Mondrian part, to be more precise) generates a query that not fully compliant with the SQL-92 regarding the use of group by. Normally, MariaDB would accept these queries in case the ‘ONLY_FULL_GROUP_BY’ mode is not set, so it is not present in the ‘sql_mode’ variable. When I check the ‘sql_mode’ on this alpha release, I get this:

'IGNORE_SPACE,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

So, the ‘ONLY_FULL_GROUP_BY’ is not present. Despite of this the DB server does not accept a query like this:

select year, month, service_group, count from bi.income
group by service_group;

I get an error:

SQL Error [1815] [HY000]: Internal error: IDB-2021: bi.income.year is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be included in the GROUP BY clause.

Any idea, suggestion regarding how can I set the Columnstore up to accept such type of queries?

I am pretty sure that many others will be affected by this behavior. More or less everybody who plans to use it as an OLAP DB backend.