diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2021-12-09 16:49:40 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2021-12-09 16:49:40 +0300 |
| commit | c88e37ff857a83387c4d86829fbaf2e277e4cf9f (patch) | |
| tree | e24cc4fb24a448a32fae9fb11a132112d0bba411 /mysql-test/main/explain_json.test | |
| parent | 1e8bcbd0a0bfa07052e9458830672ea215c8664a (diff) | |
| download | mariadb-git-c88e37ff857a83387c4d86829fbaf2e277e4cf9f.tar.gz | |
MDEV-27204: [ERROR] Json_writer: a member name was expected, Assertion `got_namebb-10.8-MDEV-27204-v2
[Adjusting Sergei Krivonos's patch]
"duplicates_removal" may contain multiple elements inside it and
so should have a JSON array as a value (and not object).
Diffstat (limited to 'mysql-test/main/explain_json.test')
| -rw-r--r-- | mysql-test/main/explain_json.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/explain_json.test b/mysql-test/main/explain_json.test index cfbc0cfa10c..3767939d3e3 100644 --- a/mysql-test/main/explain_json.test +++ b/mysql-test/main/explain_json.test @@ -419,3 +419,13 @@ 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 t1 (a INT); +INSERT INTO t1 VALUES (1),(2); +explain FORMAT=JSON +SELECT * FROM t1 t0 +WHERE t0.a IN (SELECT t2.a FROM t1 t2 WHERE t0.a IN (SELECT t3.a FROM t1 t3)); +DROP TABLE t1; |