diff options
author | Alexey Botchkov <holyfoot@askmonty.org> | 2021-03-24 23:37:05 +0400 |
---|---|---|
committer | Alexey Botchkov <holyfoot@askmonty.org> | 2021-04-21 10:21:44 +0400 |
commit | 3edc4a09989a6254512e98ddcbee8d085c8c7aec (patch) | |
tree | 0f0c114eff547d4813c8f3bd3d1dcc6e5751b801 /mysql-test/suite/json | |
parent | 6a5f86bf59f2f8a72e468f082a556ebd5c9cdc91 (diff) | |
download | mariadb-git-3edc4a09989a6254512e98ddcbee8d085c8c7aec.tar.gz |
MDEV-25229 SON_TABLE: Server crashes in hton_name upon MATCH .. AGAINST.
No plugin for the JSON_TABLE so get the storage type name directly.
Diffstat (limited to 'mysql-test/suite/json')
-rw-r--r-- | mysql-test/suite/json/r/json_table.result | 5 | ||||
-rw-r--r-- | mysql-test/suite/json/t/json_table.test | 7 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/json/r/json_table.result b/mysql-test/suite/json/r/json_table.result index bf8d46183b1..7a7f4c724ab 100644 --- a/mysql-test/suite/json/r/json_table.result +++ b/mysql-test/suite/json/r/json_table.result @@ -554,5 +554,10 @@ View Create View character_set_client collation_connection v CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select `jt`.`o` AS `o` from JSON_TABLE('{}', '$' COLUMNS (NESTED PATH '$.*' COLUMNS (NESTED PATH '$.*' COLUMNS (`o` FOR ORDINALITY)))) `jt` latin1 latin1_swedish_ci DROP VIEW v; # +# MDEV-25229 JSON_TABLE: Server crashes in hton_name upon MATCH .. AGAINST. +# +SELECT val, MATCH(val) AGAINST( 'MariaDB') FROM JSON_TABLE('{"db":"xx"}', '$' COLUMNS(val VARCHAR(32) PATH '$**.*')) AS jt; +ERROR HY000: The storage engine JSON_TABLE function doesn't support FULLTEXT indexes +# # End of 10.6 tests # diff --git a/mysql-test/suite/json/t/json_table.test b/mysql-test/suite/json/t/json_table.test index aaec4341147..3adb6385083 100644 --- a/mysql-test/suite/json/t/json_table.test +++ b/mysql-test/suite/json/t/json_table.test @@ -431,5 +431,12 @@ SHOW CREATE VIEW v; DROP VIEW v; --echo # +--echo # MDEV-25229 JSON_TABLE: Server crashes in hton_name upon MATCH .. AGAINST. +--echo # + +--error ER_TABLE_CANT_HANDLE_FT +SELECT val, MATCH(val) AGAINST( 'MariaDB') FROM JSON_TABLE('{"db":"xx"}', '$' COLUMNS(val VARCHAR(32) PATH '$**.*')) AS jt; + +--echo # --echo # End of 10.6 tests --echo # |