diff options
| author | Julius Goryavsky <julius.goryavsky@mariadb.com> | 2021-12-26 12:51:04 +0100 |
|---|---|---|
| committer | Julius Goryavsky <julius.goryavsky@mariadb.com> | 2021-12-26 12:51:04 +0100 |
| commit | 55bb933a880bf048ebc4ce6c6e239dcc8268958d (patch) | |
| tree | a3a24c56995df41758205f8f6a4e3cbccf793a19 /mysql-test/main/ps.result | |
| parent | be20b3b03f9c522d17b3454214981506549063eb (diff) | |
| parent | 681b7784b6bb3d735d0a745f5891844f43becc90 (diff) | |
| download | mariadb-git-55bb933a880bf048ebc4ce6c6e239dcc8268958d.tar.gz | |
Merge branch 10.4 into 10.5st-10.5-julius
Diffstat (limited to 'mysql-test/main/ps.result')
| -rw-r--r-- | mysql-test/main/ps.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/ps.result b/mysql-test/main/ps.result index 1b77d713185..f718bfb5dce 100644 --- a/mysql-test/main/ps.result +++ b/mysql-test/main/ps.result @@ -5569,6 +5569,19 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables DEALLOCATE PREPARE stmt; DROP TABLE t1, t2, t3; +# +# MDEV-21866: Assertion `!result' failed in convert_const_to_int upon 2nd execution of PS +# +CREATE TABLE t1 (a BIGINT DEFAULT -1); +CREATE VIEW v1 AS SELECT DISTINCT a FROM t1; +PREPARE stmt FROM 'SELECT * FROM v1 WHERE a <=> NULL'; +EXECUTE stmt; +a +EXECUTE stmt; +a +DEALLOCATE PREPARE stmt; +DROP VIEW v1; +DROP TABLE t1; # End of 10.2 tests # # |