MariaDB [test]> create view v as select * from json_table('{"a":"b"}',"$" columns(a varchar(8) path '$.a')) x;

ERROR 1352 (HY000): View's SELECT refers to a temporary table 'x'

MySQL [test]> create view v as select * from json_table('{"a":"b"}',"$" columns(a varchar(8) path '$.a')) x;

Query OK, 0 rows affected (0.098 sec)

MySQL [test]> select * from v;

+------+

| a    |

+------+

| b    |

+------+

1 row in set (0.005 sec)