[Enhancement] rollup support for ccr

[dataroaring]

Search before asking

• I had searched in the issues and found no similar issues.

Description

Currently, rollup is not synced to downstream in ccr. while adding column to rollup generates binglog. This would result in breakdown of ccr job.

Solution

1. add basic cases for rollup in ccr, including create table with rollup, adding rollup, adding column to rollup index, removing column from rollup index, modifying column, modifying order by, for database job and table job.
2. find not supported operation and add supporting. Some of them are difficult, e.g. add a rollup should result in a fullsync or partial sync, rather than a sql to downstream.
3. update documentation.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[dataroaring]

drop mv should be supported together.