From d0edf322306221f2e662a54a9feecc78378d6dfe Mon Sep 17 00:00:00 2001 From: He Zhenxing Date: Thu, 4 Sep 2008 11:26:12 +0800 Subject: Use MyISAM for all tables created in mtr_warnings.sql --- mysql-test/include/mtr_warnings.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'mysql-test/include/mtr_warnings.sql') diff --git a/mysql-test/include/mtr_warnings.sql b/mysql-test/include/mtr_warnings.sql index 8343683bf55..cf259703a4f 100644 --- a/mysql-test/include/mtr_warnings.sql +++ b/mysql-test/include/mtr_warnings.sql @@ -8,7 +8,7 @@ use mtr|| -- CREATE TABLE suspicious_patterns ( pattern VARCHAR(255) -)|| +) ENGINE=MyISAM|| -- @@ -46,7 +46,7 @@ INSERT INTO suspicious_patterns VALUES -- CREATE TABLE test_supressions ( pattern VARCHAR(255) -)|| +) ENGINE=MyISAM|| -- @@ -69,7 +69,7 @@ END -- CREATE TABLE global_supressions ( pattern VARCHAR(255) -)|| +) ENGINE=MyISAM|| -- Declare a trigger that makes sure @@ -227,7 +227,7 @@ BEGIN CREATE TEMPORARY TABLE error_log ( row INT AUTO_INCREMENT PRIMARY KEY, line mediumtext NULL - ); + ) ENGINE=MyISAM; SELECT variable_value INTO @log_error FROM information_schema.global_variables @@ -255,7 +255,7 @@ BEGIN WHERE line REGEXP "^CURRENT_TEST:"; DELETE FROM error_log WHERE row < @max_row; - CREATE TEMPORARY TABLE suspect_lines AS + CREATE TEMPORARY TABLE suspect_lines ENGINE=MyISAM AS SELECT DISTINCT el.line, 0 as "supressed" FROM error_log el, suspicious_patterns ep WHERE el.line REGEXP ep.pattern; -- cgit v1.2.1