| 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; |