mirror of
https://github.com/MariaDB/server.git
synced 2025-10-28 09:26:12 +01:00
5bd91f6c0e
JSON_TABLE is marked as a special "*any_db*" table. Because this special marking is processed all the way though to get_column_grant where its processed like its in database called "*any_db*". As this doesn't exist, only those users with global privileges can create views on a JSON_TABLE. Under a Prepared Statement protocol a Create_tmp_table is used for the JSON_TABLE, but it gets assigned an "" database name. We correct this to give it "*any_db*" like the SQL parser indicating that no database is needed. To commonly correct the fill_effective_table_privileges by looking explictly for the "*any_db*", those tables that have this as the database name get SELECT privileges. While correcting the database for the JSON_TABLE, lets give it a "json_table" name rather than "(temporary)" for greater clarity in warning messages. |
||
|---|---|---|
| .. | ||
| json_no_table.result | ||
| json_table.result | ||
| json_table_binlog.result | ||
| json_table_mysql.result | ||
| json_table_notembedded.result | ||
| rpl_json_char.result | ||
| rpl_json_longtext.result | ||
| rpl_json_mediumtext.result | ||
| rpl_json_text.result | ||
| rpl_json_tinytext.result | ||
| rpl_json_varchar.result | ||
| type_json.result | ||