From dd7753dece6f6121fbba719fe7f0632fca38fc6b Mon Sep 17 00:00:00 2001
From: unknown <pem@mysql.com>
Date: Wed, 26 Oct 2005 16:35:59 +0200
Subject: Follow-up for BUG#14233 fix. Changed backup method for the mysql.proc
 table in sp-destruct.test since using "create ... as ..." didn't preserve
 everything, which made the system_mysql_db test fail.

mysql-test/r/sp-destruct.result:
  Updated result.
mysql-test/t/sp-destruct.test:
  Changed backup method for mysql.proc.
---
 mysql-test/r/sp-destruct.result | 8 --------
 1 file changed, 8 deletions(-)

(limited to 'mysql-test/r/sp-destruct.result')

diff --git a/mysql-test/r/sp-destruct.result b/mysql-test/r/sp-destruct.result
index 4f3af87c012..65d72d2098b 100644
--- a/mysql-test/r/sp-destruct.result
+++ b/mysql-test/r/sp-destruct.result
@@ -1,6 +1,3 @@
-use mysql;
-drop table if exists proc_backup;
-create table proc_backup as select * from proc;
 use test;
 drop procedure if exists bug14233;
 drop function if exists bug14233;
@@ -33,10 +30,6 @@ create view v1 as select bug14233_f();
 ERROR 42S02: Table 'mysql.proc' doesn't exist
 insert into t1 values (0);
 ERROR 42S02: Table 'mysql.proc' doesn't exist
-use mysql;
-create table proc as select * from proc_backup;
-alter table proc add primary key (db,name,type);
-use test;
 flush table mysql.proc;
 flush privileges;
 delete from mysql.proc where name like 'bug14233%';
@@ -81,7 +74,6 @@ create trigger t1_ai after insert on t1 for each row call bug14233_3();
 insert into t1 values (0);
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'wpsj sa ^#!@ ' at line 3
 delete from mysql.proc where name like 'bug14233%';
-drop table mysql.proc_backup;
 drop trigger t1_ai;
 drop table t1;
 drop view v1;
-- 
cgit v1.2.1