Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
CREATE VIEW v AS SELECT * FROM JSON_TABLE('{}', '$' COLUMNS(NESTED PATH '$' COLUMNS(NESTED PATH '$.*' COLUMNS(o FOR ORDINALITY)))) AS jt; |
SELECT * FROM v; |
bb-10.6-mdev17399-hf 49603a0191 |
'SELECT * FROM v' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) `jt`' at line 1
|
frm |
TYPE=VIEW
|
query=select `jt`.`o` AS `o` from JSON_TABLE(\'{}\', \'$\' COLUMNS ()) `jt`
|
md5=f253a6b293f2eaad473af1906b3c1f1a
|
updatable=1
|
algorithm=0
|
definer_user=root
|
definer_host=localhost
|
suid=2
|
with_check_option=0
|
timestamp=2021-03-23 15:15:37
|
create-version=2
|
source=SELECT * FROM JSON_TABLE(\'{}\', \'$\' COLUMNS(NESTED PATH \'$\' COLUMNS(NESTED PATH \'$.*\' COLUMNS(o FOR ORDINALITY)))) AS jt
|
client_cs_name=latin1
|
connection_cl_name=latin1_swedish_ci
|
view_body_utf8=select `jt`.`o` AS `o` from JSON_TABLE(\'{}\', \'$\' COLUMNS ()) `jt`
|
mariadb-version=100600
|
Attachments
Issue Links
- relates to
-
MDEV-17399 Add support for JSON_TABLE
- Closed