REPAIR VIEW was introduced in MariaDB 10.0.18 and MariaDB
5.5.43.
 
Syntax
------ 
REPAIR [NO_WRITE_TO_BINLOG | LOCAL] VIEW view_name[,
view_name] ... [FROM MYSQL]
 
Description
----------- 
The REPAIR VIEW statement was introduced to assist with
fixing MDEV-6916, an issue introduced in MariaDB 5.2 where
the view algorithms were swapped compared to their MySQL on
disk representation. It checks whether the view algorithm is
correct. It is run as part of mysql_upgrade, and should not
normally be required in regular use.
 
By default it corrects the checksum and if necessary adds
the mariadb-version field. If the optional FROM MYSQL clause
is used, and no mariadb-version field is present, the MERGE
and TEMPTABLE algorithms are toggled.
 
By default, REPAIR VIEW statements are written to the binary
log and will be replicated. The NO_WRITE_TO_BINLOG keyword
(LOCAL is an alias) will ensure the statement is not written
to the binary log.
 
Note that REPAIR VIEW in MariaDB 10.0.18 and MariaDB 5.5.43
could crash the server (see MDEV-8115). Upgrade to a later
version.
 


URL: https://mariadb.com/kb/en/repair-view/