diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2018-08-06 15:50:22 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2018-08-08 19:44:04 +0200 |
| commit | 017adbeb3940ac162dcb8dd99478375a37edec02 (patch) | |
| tree | 2da9e7ce4d4c02d8106c395ee2b48881101035cf /mysql-test/t/func_isnull.test | |
| parent | 68ebfb31f215247d2fa08c8ed97a320191afc179 (diff) | |
| download | mariadb-git-bb-5.5-MDEV-15475.tar.gz | |
MDEV-15475: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed on EXPLAIN EXTENDED with constant table and viewbb-5.5-MDEV-15475
Print constant ISNULL fireld independent.
Fix of printing of view FRM and CREATE VIEW output
Diffstat (limited to 'mysql-test/t/func_isnull.test')
| -rw-r--r-- | mysql-test/t/func_isnull.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_isnull.test b/mysql-test/t/func_isnull.test index 4c59fa3cbe8..7d1a7e83a1a 100644 --- a/mysql-test/t/func_isnull.test +++ b/mysql-test/t/func_isnull.test @@ -83,6 +83,22 @@ SELECT * FROM t2 LEFT JOIN v1 ON t2.d1=v1.d1 WHERE v1.d1 IS NULL; DROP VIEW v1; DROP TABLE t1,t2; + +--echo # +--echo # MDEV-15475: Assertion `!table || (!table->read_set || +--echo # bitmap_is_set(table->read_set, field_index))' +--echo # failed on EXPLAIN EXTENDED with constant table and view +--echo # + +CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=MyISAM; +CREATE VIEW v1 AS SELECT * FROM t1; +INSERT INTO t1 VALUES (1); +EXPLAIN EXTENDED SELECT ISNULL(pk) FROM v1; +EXPLAIN EXTENDED SELECT IFNULL(pk,0) FROM v1; +# Cleanup +DROP VIEW v1; +DROP TABLE t1; + --echo # --echo # End of 5.5 tests --echo # |