bk commit into 5.0 tree (gluh:1.1906) BUG#10059

[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.1906 05/05/24 16:58:11 gluh@stripped +2 -0
  Fix for bug#10059: SHOW TABLE STATUS FROM `information_schema`; reports uppercase table names
       information schema table names are always upper case table names(discussed with PeterG)

  sql/sql_show.cc
    1.247 05/05/24 16:57:15 gluh@stripped +3 -2
    Fix for bug#10059: SHOW TABLE STATUS FROM `information_schema`; reports uppercase table names
         information schema table names are always upper case table names

  mysql-test/r/information_schema.result
    1.53 05/05/24 16:57:15 gluh@stripped +2 -2
    Fix for bug#10059: SHOW TABLE STATUS FROM `information_schema`; reports uppercase table names
         information schema table names are always upper case table names

# 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.10059

--- 1.246/sql/sql_show.cc	Fri May 20 17:38:15 2005
+++ 1.247/sql/sql_show.cc	Tue May 24 16:57:15 2005
@@ -396,7 +396,8 @@
   else
   {
     if (table_list->schema_table)
-      protocol->store(table_list->schema_table_name, system_charset_info);
+      protocol->store(table_list->schema_table->table_name,
+                      system_charset_info);
     else
       protocol->store(table->alias, system_charset_info);
     if (store_create_info(thd, table_list, &buffer))
@@ -757,7 +758,7 @@
   else
     packet->append("CREATE TABLE ", 13);
   if (table_list->schema_table)
-    alias= table_list->schema_table_name;
+    alias= table_list->schema_table->table_name;
   else
     alias= (lower_case_table_names == 2 ? table->alias :
             share->table_name);

--- 1.52/mysql-test/r/information_schema.result	Fri May 20 17:38:15 2005
+++ 1.53/mysql-test/r/information_schema.result	Tue May 24 16:57:15 2005
@@ -470,7 +470,7 @@
 drop table t1;
 SHOW CREATE TABLE INFORMATION_SCHEMA.character_sets;
 Table	Create Table
-character_sets	CREATE TEMPORARY TABLE `character_sets` (
+CHARACTER_SETS	CREATE TEMPORARY TABLE `CHARACTER_SETS` (
   `CHARACTER_SET_NAME` varchar(64) NOT NULL default '',
   `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL default '',
   `DESCRIPTION` varchar(60) NOT NULL default '',
@@ -479,7 +479,7 @@
 set names latin2;
 SHOW CREATE TABLE INFORMATION_SCHEMA.character_sets;
 Table	Create Table
-character_sets	CREATE TEMPORARY TABLE `character_sets` (
+CHARACTER_SETS	CREATE TEMPORARY TABLE `CHARACTER_SETS` (
   `CHARACTER_SET_NAME` varchar(64) NOT NULL default '',
   `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL default '',
   `DESCRIPTION` varchar(60) NOT NULL default '',