bk commit into 5.0 tree (msvensson:1.2558)

[msvensson]

Below is the list of changes that have just been committed into a local
5.0 repository of msvensson. When msvensson 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@stripped, 2007-10-26 11:02:14+02:00, msvensson@stripped +1 -0
  Improve include/check-testcase.test

  mysql-test/include/check-testcase.test@stripped, 2007-10-26 11:02:12+02:00, msvensson@stripped +36 -20
    Remove all use of "exec mysqldump" to make it faster
    and more exact what is checked.

diff -Nrup a/mysql-test/include/check-testcase.test b/mysql-test/include/check-testcase.test
--- a/mysql-test/include/check-testcase.test	2006-01-26 17:54:29 +01:00
+++ b/mysql-test/include/check-testcase.test	2007-10-26 11:02:12 +02:00
@@ -1,34 +1,50 @@
+
 #
 # This test is executed twice for each test case if mysql-test-run is passed
-# the flag --check-testcase.
-# Before every testcase it's run with mysqltest in record mode and will
-# thus produce an output file
-# that can be compared to output from after the tescase.
-# In that way it's possible to check that a testcase does not have
+# the flag --check-testcase. Before every testcase it is run with mysqltest
+# in record mode and will thus produce an output file that can be compared
+# to output from after the tescase.
+# In that way its possible to check that a testcase does not have
 # any unwanted side affects.
 #
 
-#
-# Dump all global variables
-#
+# Dump all global variables except those
+# that are supposed to change
 show global variables;
 
-#
-# Dump all databases
-#
+# 5.1 has one variable that is suppsed to change...
+#show global variables where Variable_name != 'timestamp';
+
+# Dump all databases, there should be none
+# except mysql, test and information_schema
 show databases;
 
-#
-# Dump the "test" database, all it's tables and their data
-#
---exec $MYSQL_DUMP --skip-comments test
+# The test database should not contain any tables
+show tables from test;
 
-#
-# Dump the "mysql" database and it's tables
-# Select data separately to add "order by"
-#
---exec $MYSQL_DUMP --skip-comments --no-data mysql
+# Dump the "mysql" database and its tables
 use mysql;
+show tables;
+show create table columns_priv;
+show create table db;
+show create table func;
+show create table help_category;
+show create table help_keyword;
+show create table help_relation;
+show create table help_relation;
+show create table host;
+show create table proc;
+show create table procs_priv;
+show create table tables_priv;
+show create table time_zone;
+show create table time_zone_leap_second;
+show create table time_zone_name;
+show create table time_zone_transition;
+show create table time_zone_transition_type;
+show create table user;
+
+# Select data from system tables to make sure they have been properly
+# restored after test
 select * from columns_priv;
 select * from db order by host, db, user;
 select * from func;