summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_misc.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2020-01-03 15:05:50 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2020-01-03 15:05:50 +0100
commit9d036f840ad5925edac419c0cb6ce838ad0f3a2f (patch)
tree83ba4380b935ae385c83acad6ba2781940c42fe8 /mysql-test/main/func_misc.test
parent2cff807d3f2149d17e776fbddb0fc9e23fa64e1b (diff)
parent7753a290645ca4af8b11f2fff1f47c3a64d45732 (diff)
downloadmariadb-git-9d036f840ad5925edac419c0cb6ce838ad0f3a2f.tar.gz
Merge branch '10.3' into 10.4
Diffstat (limited to 'mysql-test/main/func_misc.test')
-rw-r--r--mysql-test/main/func_misc.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/func_misc.test b/mysql-test/main/func_misc.test
index ea76bce3f6e..7d19c9e58af 100644
--- a/mysql-test/main/func_misc.test
+++ b/mysql-test/main/func_misc.test
@@ -1139,6 +1139,21 @@ PREPARE stmt FROM "SELECT 'x' ORDER BY NAME_CONST( 'f', 'foo' )";
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
+--echo #
+--echo # MDEV-19680: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) ||
+--echo # (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))'
+--echo # or alike failed upon SELECT with mix of functions from simple view
+--echo #
+
+CREATE TABLE t1 (a INT) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (1),(2);
+CREATE VIEW v1 AS SELECT * FROM t1;
+
+SELECT ISNULL( BENCHMARK(1, MIN(a))) FROM v1;
+
+DROP VIEW v1;
+DROP TABLE t1;
+
--echo #
--echo # Start of 10.2 tests