diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-04-13 10:26:01 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-04-13 10:26:01 +0300 |
| commit | 6e6318b29b446f76f01f2ef65d1460870b607d2a (patch) | |
| tree | 8c22bb7661b77c91b28532ddd7c150d4bf010146 /mysql-test/main/ps.test | |
| parent | 450c017c2d9e490d92c949d5164b4a99b6b3f5db (diff) | |
| parent | e262eb165c197083df9f4986ab54c5b2dcbd6290 (diff) | |
| download | mariadb-git-6e6318b29b446f76f01f2ef65d1460870b607d2a.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/ps.test')
| -rw-r--r-- | mysql-test/main/ps.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/ps.test b/mysql-test/main/ps.test index ecabc5126d3..218698a6613 100644 --- a/mysql-test/main/ps.test +++ b/mysql-test/main/ps.test @@ -4964,5 +4964,25 @@ DEALLOCATE PREPARE stmt; DROP TABLE t1; --echo # +--echo # MDEV-25108: Running of the EXPLAIN EXTENDED statement produces extra warning +--echo # in case it is executed in PS (prepared statement) mode +--echo # +CREATE TABLE t1 (c int); +CREATE TABLE t2 (d int); + +--echo # EXPLAIN EXTENDED in regular way (not PS mode) +EXPLAIN EXTENDED SELECT (SELECT 1 FROM t2 WHERE d = c) FROM t1; +SHOW WARNINGS; + +--echo # Now run the same EXPLAIN EXTENDED in PS mode. Number of warnings +--echo # and their content must be the same as in case running the statement +--echo # in regular way +PREPARE stmt FROM "EXPLAIN EXTENDED SELECT (SELECT 1 FROM t2 WHERE d = c) FROM t1"; +EXECUTE stmt; +SHOW WARNINGS; + +DEALLOCATE PREPARE stmt; +DROP TABLE t1, t2; +--echo # --echo # End of 10.2 tests --echo # |