diff options
| author | Sergei Krivonos <sergei.krivonos@mariadb.com> | 2021-12-08 17:16:34 +0200 |
|---|---|---|
| committer | Sergei Krivonos <sergei.krivonos@mariadb.com> | 2021-12-09 03:53:36 +0200 |
| commit | b0161776d91fd22198b3bf0c25dc7d1f90027dd6 (patch) | |
| tree | 8d9b6d5025fbb9b8ce2634f6731f2af292cc0950 /mysql-test/main/explain_json.test | |
| parent | 1e8bcbd0a0bfa07052e9458830672ea215c8664a (diff) | |
| download | mariadb-git-bb-10.8-MDEV-27204.tar.gz | |
MDEV-27204: fixed Explain_basic_join::print_explain_json_interns "duplicates_removal" arraysbb-10.8-MDEV-27204
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; |