diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2021-03-26 12:18:02 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2021-04-21 10:21:45 +0400 |
| commit | 48dffa3c302066347717932d641e9dc0ccb3ab5a (patch) | |
| tree | f9393aa6c44a41b771a8e311c4a6d4a3bb7faadf /mysql-test | |
| parent | e2d5eb67a16ad858a738e9c6d1766c7b59386947 (diff) | |
| download | mariadb-git-48dffa3c302066347717932d641e9dc0ccb3ab5a.tar.gz | |
MDEV-25155 JSON_TABLE: Status variable Feature_json is not incremented.
feature_json variable incremented.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/status.result | 6 | ||||
| -rw-r--r-- | mysql-test/main/status.test | 2 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/status.result b/mysql-test/main/status.result index 37c551328f0..d25cde89ee1 100644 --- a/mysql-test/main/status.result +++ b/mysql-test/main/status.result @@ -438,6 +438,12 @@ json_valid('123') SHOW STATUS LIKE 'Feature_json'; Variable_name Value Feature_json 1 +select * from json_table ('{}', '$' COLUMNS(x FOR ORDINALITY)) a; +x +1 +SHOW STATUS LIKE 'Feature_json'; +Variable_name Value +Feature_json 2 connection default; set @@global.concurrent_insert= @old_concurrent_insert; SET GLOBAL log_output = @old_log_output; diff --git a/mysql-test/main/status.test b/mysql-test/main/status.test index 221a24aedf4..78626615d45 100644 --- a/mysql-test/main/status.test +++ b/mysql-test/main/status.test @@ -436,6 +436,8 @@ SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME SHOW STATUS LIKE 'Feature_json'; select json_valid('123'); SHOW STATUS LIKE 'Feature_json'; +select * from json_table ('{}', '$' COLUMNS(x FOR ORDINALITY)) a; +SHOW STATUS LIKE 'Feature_json'; # Restore global concurrent_insert value. Keep in the end of the test file. --connection default |