summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_misc.test
diff options
context:
space:
mode:
authorunknown <svoj@mysql.com/june.mysql.com>2008-02-19 18:16:17 +0400
committerunknown <svoj@mysql.com/june.mysql.com>2008-02-19 18:16:17 +0400
commitf802cd51238c7842b789e49ba27d3c119ebb8ce3 (patch)
tree5da3619ac6e455f0f7ea21af3e87a903cfafa055 /mysql-test/t/func_misc.test
parent40f7e296701c9278edfbad970ad90bfd9a33454b (diff)
downloadmariadb-git-f802cd51238c7842b789e49ba27d3c119ebb8ce3.tar.gz
BUG#34289 - Incorrect NAME_CONST substitution in stored procedures
breaks replication NAME_CONST() didn't replicate constant character set and collation correctly. With this fix NAME_CONST() inherits collation from the value argument. mysql-test/r/func_misc.result: A test case for BUG#34289. mysql-test/t/func_misc.test: A test case for BUG#34289. sql/item.cc: Inherit collation from value argument.
Diffstat (limited to 'mysql-test/t/func_misc.test')
-rw-r--r--mysql-test/t/func_misc.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test
index ccb59df5677..17a0dbe50a7 100644
--- a/mysql-test/t/func_misc.test
+++ b/mysql-test/t/func_misc.test
@@ -237,5 +237,11 @@ insert into t1 values (-1), (-2);
select min(a) from t1 group by inet_ntoa(a);
drop table t1;
+#
+# BUG#34289 - Incorrect NAME_CONST substitution in stored procedures breaks
+# replication
+#
+SELECT NAME_CONST('var', 'value') COLLATE latin1_general_cs;
+
--echo End of 5.0 tests