Issue here is, sys schema views dependent on information schema(I_S)
tables are marked as invalid views after upgrade.

During upgrade if I_S version is changed then old I_S tables are
dropped and new tables are created. The views referencing the I_S
tables are marked as invalid after dropping the old version tables.
But the state of those views is not updated after creating a
new I_S tables. Currently, the referencing view state is updated
only if table/view is user defined. For I_S, performance schema
or other mysql schema tables, the referencing views state is not
updated.

To fix the issue, above mentioned limitation is removed and now
the referencing views state is updated for all types of tables
except temporary and data-dictionary tables.

CREATE/ALTER view operations uses thread lock TL_IGNORE. But while
updating referencing views state and metadata, TL_WRITE lock is
acquired by mistake. As part of this patch, thread lock for
referencing views is changed to TL_IGNORE.

Change-Id: I87e0f7b2207c47102440ba0a70f710462d654083