diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-12-20 16:52:02 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-12-20 16:52:02 +0100 |
commit | eb1404238346405edc51b0b916a8e0650f061cf0 (patch) | |
tree | 9433ad8a370ad46fbcb3e5178afcb9aa475cb408 /mysql-test | |
parent | 8d70097c216081e8013a548bfbde156e48985816 (diff) | |
download | mariadb-git-eb1404238346405edc51b0b916a8e0650f061cf0.tar.gz |
MDEV-14613: Assertion `fixed == 0' failed in Item_func::fix_fields
fix_fields calls fixed.
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/func_misc.result | 15 | ||||
-rw-r--r-- | mysql-test/t/func_misc.test | 21 |
2 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index 0462a1dc48a..218b11a2fc2 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -1523,5 +1523,20 @@ str str1 b c ::10.0.5.9 ::10.0.5.9 1 0 DROP TABLE t1; # +# MDEV-14613: Assertion `fixed == 0' failed in Item_func::fix_fields +# +CREATE TABLE `t1` ( +`numgtfmt` char(10) COLLATE utf8_bin NOT NULL +) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +create view v1(numgtfmt) +as +select 'x' from t1 +union +select 'x' from t1 ; +SELECT * FROM v1 WHERE numgtfmt = NAME_CONST('wnumgtfmt',_utf8'QEDITIONS' COLLATE 'utf8_bin'); +numgtfmt +DROP VIEW v1; +DROP TABLE t1; +# # End of 10.2 tests # diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test index 5d0dc52a6af..e2684ab4957 100644 --- a/mysql-test/t/func_misc.test +++ b/mysql-test/t/func_misc.test @@ -1153,5 +1153,26 @@ SELECT str, str1, b,c FROM t1; DROP TABLE t1; --echo # +--echo # MDEV-14613: Assertion `fixed == 0' failed in Item_func::fix_fields +--echo # + +CREATE TABLE `t1` ( + `numgtfmt` char(10) COLLATE utf8_bin NOT NULL +) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; + +create view v1(numgtfmt) +as +select 'x' from t1 +union +select 'x' from t1 ; + +SELECT * FROM v1 WHERE numgtfmt = NAME_CONST('wnumgtfmt',_utf8'QEDITIONS' COLLATE 'utf8_bin'); + +# Cleanup +DROP VIEW v1; +DROP TABLE t1; + + +--echo # --echo # End of 10.2 tests --echo # |