Bug #47787 Test main.not_partition fails due to changes in error message
Submitted: 2 Oct 2009 10:28 Modified: 7 Apr 2010 13:45
Reporter: Olav Sandstå Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:6.0.14 OS:Any
Assigned to: Mattias Jonsson CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[2 Oct 2009 10:28] Olav Sandstå
Description:
When running the test main.not_partition it fails with the following errors:

main.not_partition                       [ fail ]
        Test ended at 2009-10-02 12:19:58

CURRENT_TEST: main.not_partition
--- /home/os136802/mysql/develop/repo/opt-bug35080/mysql-test/r/not_partition.result    Tue Sep 29 13:40:24 2009
+++ /home/os136802/mysql/develop/repo/opt-bug35080/mysql-test/r/not_partition.reject    Fri Oct  2 13:19:58 2009
@@ -1,47 +1,47 @@
 DROP TABLE IF EXISTS t1;
 FLUSH TABLES;
 SELECT * FROM t1;
-ERROR 42000: Unknown table engine 'partition'
+ERROR 42000: Unknown storage engine 'partition'
 TRUNCATE TABLE t1;
-ERROR 42000: Unknown table engine 'partition'
+ERROR 42000: Unknown storage engine 'partition'
 ANALYZE TABLE t1;
 Table  Op      Msg_type        Msg_text
-test.t1        analyze Error   Unknown table engine 'partition'
+test.t1        analyze Error   Unknown storage engine 'partition'
 test.t1        analyze error   Corrupt
 CHECK TABLE t1;
 Table  Op      Msg_type        Msg_text
-test.t1        check   Error   Unknown table engine 'partition'
+test.t1        check   Error   Unknown storage engine 'partition'
 test.t1        check   error   Corrupt
 OPTIMIZE TABLE t1;
 Table  Op      Msg_type        Msg_text
-test.t1        optimize        Error   Unknown table engine 'partition'
+test.t1        optimize        Error   Unknown storage engine 'partition'
 test.t1        optimize        error   Corrupt
 REPAIR TABLE t1;
 Table  Op      Msg_type        Msg_text
-test.t1        repair  Error   Unknown table engine 'partition'
+test.t1        repair  Error   Unknown storage engine 'partition'
 test.t1        repair  error   Corrupt
 ALTER TABLE t1 REPAIR PARTITION ALL;
 Table  Op      Msg_type        Msg_text
-test.t1        repair  Error   Unknown table engine 'partition'
+test.t1        repair  Error   Unknown storage engine 'partition'
 test.t1        repair  error   Corrupt
 ALTER TABLE t1 CHECK PARTITION ALL;
 Table  Op      Msg_type        Msg_text
-test.t1        check   Error   Unknown table engine 'partition'
+test.t1        check   Error   Unknown storage engine 'partition'
 test.t1        check   error   Corrupt
 ALTER TABLE t1 OPTIMIZE PARTITION ALL;
 Table  Op      Msg_type        Msg_text
-test.t1        optimize        Error   Unknown table engine 'partition'
+test.t1        optimize        Error   Unknown storage engine 'partition'
 test.t1        optimize        error   Corrupt
 ALTER TABLE t1 ANALYZE PARTITION ALL;
 Table  Op      Msg_type        Msg_text
-test.t1        analyze Error   Unknown table engine 'partition'
+test.t1        analyze Error   Unknown storage engine 'partition'
 test.t1        analyze error   Corrupt
 ALTER TABLE t1 REBUILD PARTITION ALL;
-ERROR 42000: Unknown table engine 'partition'
+ERROR 42000: Unknown storage engine 'partition'
 ALTER TABLE t1 ENGINE Memory;
-ERROR 42000: Unknown table engine 'partition'
+ERROR 42000: Unknown storage engine 'partition'
 ALTER TABLE t1 ADD (new INT);
-ERROR 42000: Unknown table engine 'partition'
+ERROR 42000: Unknown storage engine 'partition'
 DROP TABLE t1;

How to repeat:
1. Use 6.0 code base
2. Configure without support for the Partition storage engine.
3. Compile
4. Run the test:

     ./mysql-test-run.pl not_partition

Suggested fix:
Update either the error message or the result file from the test depending on which should be the correct error message.
[2 Oct 2009 13:13] Valeriy Kravchuk
Thank you for the problem report. Verified just as described with recent mysql-6.0-codebase from bzr.
[6 Oct 2009 16:05] Alexander Nozdrin
NOTE: It is skipped in PB.
[7 Apr 2010 13:45] Mattias Jonsson
Closing, already in mysql-6.0-codebase tree, test only no documentation needed