Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug39438.test

raw
1 #
2 # Bug#39438 Testcase for Bug#39436 crashes on 5.1 in fil_space_get_latch
3 # http://bugs.mysql.com/39438
4 #
5 # This test must be run with innodb_file_per_table=1 because the crash
6 # only occurs if that option is turned on and DISCARD TABLESPACE only
7 # works with innodb_file_per_table.
8 #
9
10
11 SET default_storage_engine=InnoDB;
12
13 # we care only that the following SQL commands do not crash the server
14 -- disable_query_log
15 -- disable_result_log
16
17 DROP TABLE IF EXISTS bug39438;
18
19 CREATE TABLE bug39438 (id INT) ENGINE=INNODB;
20
21 # remove: XXX Uncomment the following ALTER and remove those lines after
22 # remove: applying the patch.
23 # remove: Obviously this test is useless without this ALTER command,
24 # remove: but it causes warnings to be printed by mysqld and the whole
25 # remove: mysql-test suite fails at the end (returns non-zero). Please
26 # remove: apply this patch to the mysql source tree, remove those lines
27 # remove: and uncomment the following ALTER. We do not care about the
28 # remove: warnings, this test is to ensure mysqld does not crash.
29 # remove: === modified file 'mysql-test/lib/mtr_report.pl'
30 # remove: --- mysql-test/lib/mtr_report.pl 2008-08-12 10:26:23 +0000
31 # remove: +++ mysql-test/lib/mtr_report.pl 2008-10-01 11:57:41 +0000
32 # remove: @@ -412,7 +412,10 @@
33 # remove:
34 # remove: # When trying to set lower_case_table_names = 2
35 # remove: # on a case sensitive file system. Bug#37402.
36 # remove: - /lower_case_table_names was set to 2, even though your the file system '.*' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems./
37 # remove: + /lower_case_table_names was set to 2, even though your the file system '.*' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems./ or
38 # remove: +
39 # remove: + # this test is expected to print warnings
40 # remove: + ($testname eq 'main.innodb_bug39438')
41 # remove: )
42 # remove: {
43 # remove: next; # Skip these lines
44 # remove:
45 #ALTER TABLE bug39438 DISCARD TABLESPACE;
46
47 # this crashes the server if the bug is present
48 SHOW TABLE STATUS;
49
50 DROP TABLE bug39438;