mirror of
https://github.com/MariaDB/server.git
synced 2025-12-06 20:35:45 +01:00
85567aba45
Analysis: While writing the view to .FRM file, we check the datatype of each column and append the appropriate type to the string (which will be written to the frm). This is where the conversion from JSON to longtext happens because that is how it is stored internally. Now, while SELECT, when the frm is read it has longtext instead of JSON which also results in changing the handler type. Since the handler types dont match, m_format_json becomes false for that specific column. Now, when filling the values, since the format is not json, it does not get added in the result. Hence the output is NULL. Fix: Before writing the view to the FRM file, check if the datatype for the column is JSON (which means the m_format_json will be true). If it is JSON append JSON. |
||
|---|---|---|
| .. | ||
| 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 | ||