bk commit into 5.0 tree (gluh:1.2169) BUG#19599

[gluh]

Below is the list of changes that have just been committed into a local
5.0 repository of gluh. When gluh does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.2169 06/06/05 15:45:15 gluh@stripped +3 -0
  Bug#19599 duplication of information_schema column value in a CONCAT expr with user var
  mark result string using String::mark_as_const()
  which prevents CONCAT from reusing it as a buffer
  for concatenation result.

  sql/item_strfunc.h
    1.107 06/06/05 15:45:09 gluh@stripped +1 -0
    Bug#19599 duplication of information_schema column value in a CONCAT expr with user var
    mark result string using String::mark_as_const()
    which prevents CONCAT from reusing it as a buffer
    for concatenation result.

  mysql-test/t/information_schema.test
    1.81 06/06/05 15:45:09 gluh@stripped +10 -0
    Bug#19599 duplication of information_schema column value in a CONCAT expr with user var
    test case

  mysql-test/r/information_schema.result
    1.106 06/06/05 15:45:09 gluh@stripped +9 -0
    Bug#19599 duplication of information_schema column value in a CONCAT expr with user var
    test case

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	gluh
# Host:	eagle.intranet.mysql.r18.ru
# Root:	/home/gluh/MySQL/Bugs/5.0.19599

--- 1.106/sql/item_strfunc.h	Thu May 18 22:33:57 2006
+++ 1.107/sql/item_strfunc.h	Mon Jun  5 15:45:09 2006
@@ -674,6 +674,7 @@ public:
                                  str->charset(), conv_charset, &errors))
         null_value= 1;
       use_cached_value= 1;
+      str_value.mark_as_const();
       safe= (errors == 0);
     }
     else

--- 1.105/mysql-test/r/information_schema.result	Tue May 23 12:45:19 2006
+++ 1.106/mysql-test/r/information_schema.result	Mon Jun  5 15:45:09 2006
@@ -1121,3 +1121,12 @@ NULL	test	v2	select 1 AS `1`	NONE	NO	mys
 drop view v1, v2;
 drop table t1;
 drop user mysqltest_1@localhost;
+set @a:= '.';
+create table t1(f1 char(5));
+create table t2(f1 char(5));
+select concat(@a, table_name), @a, table_name
+from information_schema.tables where table_schema = 'test';
+concat(@a, table_name)	@a	table_name
+.t1	.	t1
+.t2	.	t2
+drop table t1,t2;

--- 1.80/mysql-test/t/information_schema.test	Tue May 23 20:05:32 2006
+++ 1.81/mysql-test/t/information_schema.test	Mon Jun  5 15:45:09 2006
@@ -838,3 +838,13 @@ connection default;
 drop view v1, v2;
 drop table t1;
 drop user mysqltest_1@localhost;
+
+#
+# Bug#19599 duplication of information_schema column value in a CONCAT expr with user var
+#
+set @a:= '.';
+create table t1(f1 char(5));
+create table t2(f1 char(5));
+select concat(@a, table_name), @a, table_name
+from information_schema.tables where table_schema = 'test';
+drop table t1,t2;