diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-03-03 09:41:50 +0200 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-03-03 09:41:50 +0200 |
commit | ddbc6126920c1ad0300f7f9734348309f5073de7 (patch) | |
tree | f98a56b0fef476345979f3a228de8ffd27da0ea6 /mysql-test/main/ps.result | |
parent | 0f81ca6a0bb21fbba4bca93a7555f7c8e6357b47 (diff) | |
parent | 676987c4a14069d415c56d0f259aaaa7ca742c23 (diff) | |
download | mariadb-git-ddbc6126920c1ad0300f7f9734348309f5073de7.tar.gz |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/ps.result')
-rw-r--r-- | mysql-test/main/ps.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/ps.result b/mysql-test/main/ps.result index d51414d8f54..d1a17f90934 100644 --- a/mysql-test/main/ps.result +++ b/mysql-test/main/ps.result @@ -5479,5 +5479,22 @@ EXISTS(SELECT 1 FROM t1 GROUP BY a IN (select a from t1)) 0 DROP TABLE t1; # +# MDEV-25006: Failed assertion on executing EXPLAIN DELETE statement as a prepared statement +# +CREATE TABLE t1(c1 CHAR(255) PRIMARY KEY); +PREPARE stmt FROM 'EXPLAIN DELETE b FROM t1 AS a JOIN t1 AS b'; +EXECUTE stmt; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE a system NULL NULL NULL NULL 0 Const row not found +1 SIMPLE b system NULL NULL NULL NULL 0 Const row not found +DROP TABLE t1; +CREATE TABLE t1(a INT); +PREPARE stmt FROM 'EXPLAIN DELETE FROM t1.* USING t1'; +EXECUTE stmt; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 0 Const row not found +DEALLOCATE PREPARE stmt; +DROP TABLE t1; +# # End of 10.2 tests # |