← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/repair.test

  • Committer: Brian Aker
  • Date: 2009-01-15 03:28:20 UTC
  • Revision ID: brian@tangent.org-20090115032820-lt6jzt5plvadzb1y
MyISAM fix.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/repair.test
61
61
# BUG#23175 - MYISAM crash/repair failed during repair
62
62
#
63
63
CREATE TABLE t1(a CHAR(255), KEY(a)) ENGINE=MyISAM;
64
 
SET myisam_sort_buffer_size=4096;
 
64
SET GLOBAL myisam_sort_buffer_size=4096;
 
65
SHOW VARIABLES LIKE "myisam_sort_buffer_size";
65
66
# fails with ER_NOT_KEYFILE but really 'myisam_sort_buffer_size is too small'
66
67
--error ER_NOT_KEYFILE
67
68
INSERT INTO t1 VALUES
84
85
SET GLOBAL myisam_repair_threads=2;
85
86
REPAIR TABLE t1;
86
87
SET GLOBAL myisam_repair_threads=1;
87
 
SET myisam_sort_buffer_size=@@global.myisam_sort_buffer_size;
 
88
SET GLOBAL myisam_sort_buffer_size=DEFAULT;
88
89
DROP TABLE t1;
89
90
 
90
91
#
92
93
#              myisam_sort_buffer_size
93
94
#
94
95
CREATE TABLE t1(a CHAR(255), KEY(a)) ENGINE=MyISAM;
95
 
SET myisam_sort_buffer_size=16384;
 
96
SET GLOBAL myisam_sort_buffer_size=16384;
96
97
INSERT INTO t1 VALUES
97
98
('0'),('0'),('0'),('0'),('0'),('0'),('0'),('0'),('0'),('0'),
98
99
('0'),('0'),('0'),('0'),('0'),('0'),('0'),('0'),('0'),('0'),
113
114
SET GLOBAL myisam_repair_threads=2;
114
115
REPAIR TABLE t1;
115
116
SET GLOBAL myisam_repair_threads=1;
116
 
SET myisam_sort_buffer_size=@@global.myisam_sort_buffer_size;
 
117
SET GLOBAL myisam_sort_buffer_size=DEFAULT;
117
118
DROP TABLE t1;
118
119
 
119
120
--echo End of 4.1 tests
130
131
REPAIR TABLE tt1 USE_FRM;
131
132
DROP TABLE tt1;
132
133
 
 
134
SET GLOBAL myisam_sort_buffer_size=DEFAULT;