Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.8.2, 11.4.2, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
None
-
Docker official image https://hub.docker.com/_/mariadb
Description
The following statement returns error when run by an user created with GRANT ALL PRIVILEGES - it works anyway when run as root:
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
|
The reported error message is
ANY command denied to user 'syncope'@'172.17.0.1' for table 'attrs'
|
The syncope user is able anyway to create views not involving JSON columns.
Attachments
Issue Links
- relates to
-
MDEV-17399 Add support for JSON_TABLE
-
- Closed
-
- links to