summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2021-10-26 17:53:17 +0400
committerSergei Golubchik <serg@mariadb.org>2021-10-29 18:29:02 +0200
commitda4479ef9d67af524784ad26d37509ab6d29665f (patch)
tree90d36010c47ef30c52599c4a3fce44c0e91ae8cf
parent6bf5a3beb377d42d14c5cc68abd3e55aa05ee2db (diff)
downloadmariadb-git-preview-10.7-MDEV-4958-uuid.tar.gz
MDEV-26732 Assertion `0' failed in Item::val_nativepreview-10.7-MDEV-4958-uuid
add a test case
-rw-r--r--plugin/type_uuid/mysql-test/type_uuid/type_uuid.result8
-rw-r--r--plugin/type_uuid/mysql-test/type_uuid/type_uuid.test6
2 files changed, 14 insertions, 0 deletions
diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result
index 77e718ca93c..43ef4e911dc 100644
--- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result
+++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.result
@@ -3144,3 +3144,11 @@ INSERT INTO t1 VALUES ('00----000000000000000000000000000024');
INSERT INTO t1 VALUES ('5796dac11a1c11--------------ecab4ef859-713e4be4');
INSERT INTO t1 VALUES ('5796dac11a1c11---------------ecab4ef859-713e4be4');
DROP TABLE t1;
+#
+# MDEV-26732 Assertion `0' failed in Item::val_native
+#
+SELECT uuid() AS f, var_pop('x') FROM dual HAVING f > '';
+f var_pop('x')
+Warnings:
+Warning 1292 Truncated incorrect DOUBLE value: 'x'
+Warning 1292 Incorrect uuid value: ''
diff --git a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.test b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.test
index c3c704ad29d..65574ac11d3 100644
--- a/plugin/type_uuid/mysql-test/type_uuid/type_uuid.test
+++ b/plugin/type_uuid/mysql-test/type_uuid/type_uuid.test
@@ -1646,3 +1646,9 @@ INSERT INTO t1 VALUES ('00----000000000000000000000000000024');
INSERT INTO t1 VALUES ('5796dac11a1c11--------------ecab4ef859-713e4be4');
INSERT INTO t1 VALUES ('5796dac11a1c11---------------ecab4ef859-713e4be4');
DROP TABLE t1;
+
+--echo #
+--echo # MDEV-26732 Assertion `0' failed in Item::val_native
+--echo #
+
+SELECT uuid() AS f, var_pop('x') FROM dual HAVING f > '';