ss - oscar

My SQL Dump

MySQL musings by a self professed MySQL Geek

Previous Entry Share Next Entry
Flexviews 1.7.0 GA released
ss - oscar
I am happy to announce the GA release of Flexviews. I've numbered the release 1.7.0 GA.
There are a small number of bug fixes and enhancements:

  • Fixes for views which have aggregate functions but no GROUP BY expressions could have had problems during incremental update.
  • GA support for all aggregate functions except GROUP_CONCAT and AVG(distinct).
  • The PERCENTILE_XX (ie PERCENTILE_90 for a 90th percentile calculation) is now stable too

FlexCDC got a number of fixes and improvements:

  • TIMESTAMP columns are now properly supported
  • Now mysqlbinlog errors are detected, and the program exits gracefully
  • FlexCDC now logs to a log file instead of writing to STDOUT/STDERR
  • There are new PHP scripts for adding and removing table changelogs
  • Also, a new wrapper script (

You can get it here:

  • 1

Can't wait to get involved

Hey - I am definitely delighted to discover this. cool job!

flexviews without aggregate-functions


We're trying to use flexviews to denormalize a database - so there is no aggregate functions, just simplifying the joins we have to use in our application.

I ran into some trouble when i'm executing the refresh-method. Got an "column-count doesent match row-count"-error.

After a little debugging it seems the SP "apply_delta" has a bug in the section where it deals with non-aggregate-functions.

v_mview_schema, '.', v_mview_name,
' SELECT (NULL - we added this), ', flexviews.get_delta_aliases(v_mview_id,'',FALSE),
' FROM ', v_delta_table,
' WHERE dml_type = 1 AND uow_id > ', v_refreshed_to_uow_id,
' AND uow_id <= ', v_until_uow_id);

When we added a null-column for the auto-inc it seemed to work. Is this a bug, or are we not using it correctly?


Re: flexviews without aggregate-functions

This looks like a bug. Can you please post an example on the bug tracker please?


Re: flexviews without aggregate-functions

Done :)

future of flexviews

Is this project going to be developed further?

Re: future of flexviews

There are a few open bugs posted on the bug tracker which need to be resolved, but I haven't had the time to work on Flexviews recently. Hopefully that will change soon.

Is there something in particular you are having a problem with, or are you just seeing if the project is still active?

  • 1

Log in