From 921e1cc4bb217b74f29e3e0b28df253df34c8d83 Mon Sep 17 00:00:00 2001
From: "svoj@mysql.com/june.mysql.com" <>
Date: Tue, 19 Feb 2008 18:16:17 +0400
Subject: 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/t/func_misc.test | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'mysql-test/t/func_misc.test')

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
 
-- 
cgit v1.2.1