Hello!
I've found lot of weirdnesses when trying to use COMPLETE refresh views:
- enable() actually does not enable mview: it does not set flexviews.mview.mview_enabled flag
- disable() actually does not disable mview
- add_expr() does not actually work because flexviews.mview.mview_enabled is not set. For example, i can not create KEY for mview. Procedure does not report any warnings/errors but it does not set a key (because it's not enabled)
Does actually Flexviews intended to be used with complete refreshes?