Since SQLite doesn't have a ROLL UP directive, it's not possible to test anything that uses it with the current testing configs. We have two options:
Move testing over to MySQL - This is probably the right thing to do.
Drop ROLL UP - This isn't incorrect. The way the reports work now, using ROLL UP, is a bit of a pain, and not very flexible. It will require some pretty significant refactoring, though.
Since SQLite doesn't have a ROLL UP directive, it's not possible to test anything that uses it with the current testing configs. We have two options: Move testing over to MySQL - This is probably the right thing to do. Drop ROLL UP - This isn't incorrect. The way the reports work now, using ROLL UP, is a bit of a pain, and not very flexible. It will require some pretty significant refactoring, though.