[MDEV-22294] JSON_TABLE: Cannot create a view selecting from json_table - Jira

bb-10.5-hf 6dfb3fab2
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'

It works in MySQL:

MySQL 8.0.19
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)

relates to

MDEV-17399 Add support for JSON_TABLE

There are no comments yet on this issue.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server