diff options
Diffstat (limited to 'mysql-test/main/explain_json.test')
| -rw-r--r-- | mysql-test/main/explain_json.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/explain_json.test b/mysql-test/main/explain_json.test index cfbc0cfa10c..8c96fb07107 100644 --- a/mysql-test/main/explain_json.test +++ b/mysql-test/main/explain_json.test @@ -419,3 +419,11 @@ explain format=json select * from t1 order by a desc, b desc; explain format=json select * from t1 order by a desc, b ; drop table t1; +--echo # +--echo # MDEV-27204: [ERROR] Json_writer: a member name was expected, Assertion `got_name == named_item_expected()' failed +--echo # + +CREATE TABLE t (a INT); +INSERT INTO t VALUES (1),(2); +ANALYZE FORMAT=JSON SELECT * FROM t t1 WHERE t1.a IN (SELECT t2.a FROM t t2 WHERE t1.a IN (SELECT t3.a FROM t t3)); +DROP TABLE t; |