I'm having difficulty migrating one form of query from MySQL to InfiniDB. This query summarises data in a table by the start of the week:
CREATE TABLE `avg_daily` (
`unit_id` int(11) DEFAULT NULL,
`dtime` date DEFAULT NULL,
`rtt_avg` int(11) DEFAULT NULL,
`successes` smallint(5) DEFAULT NULL,
`failures` smallint(5) DEFAULT NULL
) ENGINE=InfiniDB DEFAULT CHARSET=latin1;
mysql> SELECT DATE_ADD(dtime, INTERVAL DAYOFWEEK(dtime) DAY), COUNT(*) FROM avg_daily GROUP BY 1;
ERROR 122 (HY000): There was an internal error encountered in the Calpont Engine while processing this query. The query was cancelled. You may resubmit it if you like. The error came from PrimitiveServer.
I tried a few other examples that used DATE_FORMAT, but just get back unsupported aggregation column errors.