CREATE VIEW AS SELECT involving JSON column requires root privileges

    CREATE VIEW user_search AS

    SELECT u.id as any_id, u.*, attrs.*

    FROM SyncopeUser u, JSON_TABLE(COALESCE(plainAttrs, '[{}]'), '$[*]' COLUMNS (

    plainSchema VARCHAR(255) PATH '$.schema',

    NESTED PATH '$.values[*]' COLUMNS (

    binaryValue LONGBLOB PATH '$.binaryValue',

    booleanValue INT PATH '$.booleanValue',

    dateValue BIGINT(20) PATH '$.dateValue',

    doubleValue DOUBLE PATH '$.doubleValue',

    longValue BIGINT(20) PATH '$.longValue',

    stringValue VARCHAR(255) PATH '$.stringValue'),

    attrUniqueValue JSON PATH '$.uniqueValue')

    ) AS attrs

ANY command denied to user 'syncope'@'172.17.0.1' for table 'attrs'