MySQL 9.4 Reference Manual Including MySQL NDB Cluster 9.4
The JSON_DUALITY_VIEWS table provides
information about JSON duality views accessible by the current
user. There is one row in this table for each such view.
The JSON_DUALITY_VIEWS table contains
the columns listed here:
TABLE_CATALOG
View catalog; this is always def.
TABLE_SCHEMA
View schema.
TABLE_NAME
View name.
DEFINER
User who created the view.
SECURITY_TYPE
One of INVOKER or
DEFINER.
JSON_COLUMN_NAME
This is always data.
ROOT_TABLE_CATALOG
Catalog of the root table; this is always
def.
ROOT_TABLE_SCHEMA
Schema of the root table.
ROOT_TABLE_NAME
Name of the root table.
ALLOW_INSERT
1 if inserts are allowed, otherwise
0.
ALLOW_UPDATE
1 if updates are allowed, otherwise
0.
ALLOW_DELETE
1 if deletes are allowed, otherwise
0.
READ_ONLY
1 if insert, update, or delete are not
allowed, otherwise 0. (In other words, this
is 1 only when
ALLOW_INSERT,
ALLOW_UPDATE, and
ALLOW_DELETE are all 0.)
STATUS
One of valid or invalid.
The root table name and other information are shown only if the
user has some type of privilege on the root table; the user must
also have SHOW VIEW and
SELECT privileges on the view.
The JSON_DUALITY_VIEWS table was
added in MySQL 9.4.0.