My SQL Dump

MySQL musings by a self professed MySQL Geek

Previous Entry Add to Memories Share Next Entry
Flexviews 1.7.0 GA released
swanhart
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 (consumer_safe.sh)


You can get it here: http://flexvie.ws

Can't wait to get involved

(Anonymous)

2011-04-14 02:18 pm (UTC)

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

flexviews without aggregate-functions

(Anonymous)

2011-05-11 07:21 am (UTC)

Hi

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.

SET v_sql = CONCAT('INSERT INTO ',
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?

Hallvard

Re: flexviews without aggregate-functions

swanhart

2011-05-11 08:34 am (UTC)

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

Thanks!

Re: flexviews without aggregate-functions

(Anonymous)

2011-05-11 01:48 pm (UTC)

Done :)

future of flexviews

(Anonymous)

2012-05-16 02:57 pm (UTC)

Is this project going to be developed further?

Re: future of flexviews

swanhart

2012-05-25 06:14 pm (UTC)

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?

You are viewing swanhart