diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-01-04 09:26:38 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-01-04 09:26:38 +0200 |
| commit | 3f5726768f17342fd6dfec1be1e4d71814bc8564 (patch) | |
| tree | cc85210cf84b11f0543d9a20bcb78f40cb32c140 /mysql-test/main/ps.test | |
| parent | c410f7aaea400eb98f13552725b685a2513aafcb (diff) | |
| parent | 4c3ad24413f234599eda27f4958dd3ff21df3203 (diff) | |
| download | mariadb-git-3f5726768f17342fd6dfec1be1e4d71814bc8564.tar.gz | |
Merge 10.5 into 10.6
Diffstat (limited to 'mysql-test/main/ps.test')
| -rw-r--r-- | mysql-test/main/ps.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/ps.test b/mysql-test/main/ps.test index fa184ab8250..c4ec92540a2 100644 --- a/mysql-test/main/ps.test +++ b/mysql-test/main/ps.test @@ -4991,6 +4991,22 @@ EXECUTE stmt; DEALLOCATE PREPARE stmt; DROP TABLE t1, t2, t3; +--echo # +--echo # MDEV-21866: Assertion `!result' failed in convert_const_to_int upon 2nd execution of PS +--echo # + +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; +EXECUTE stmt; + +# Cleanup +DEALLOCATE PREPARE stmt; +DROP VIEW v1; +DROP TABLE t1; + + --echo # End of 10.2 tests --echo # |