Bug #24997 warnings test case failure
Submitted: 12 Dec 2006 9:37 Modified: 8 Jan 2007 14:56
Reporter: Lars Thalmann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1 OS:
Assigned to: Magnus BlÄudd CPU Architecture:Any

[12 Dec 2006 9:37] Lars Thalmann
Description:
warnings                       [ fail ]

Errors are (from e:/pb/mysql-5.1-new-rpl/142/mysql-5.1.15-beta-pb142/mysql-test/var-n_mix-5/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/warnings.result	Mon Dec 11 16:22:05 2006
--- r/warnings.reject	Mon Dec 11 20:09:36 2006
***************
*** 168,177 ****
  drop table t1;
  create table t1 (id int) engine=NDB;
  Warnings:
! Warning	1266	Using storage engine MyISAM for table 't1'
  alter table t1 engine=NDB;
  Warnings:
! Warning	1266	Using storage engine MyISAM for table 't1'
  drop table t1;
  set table_type=MYISAM;
  Warnings:
--- 168,177 ----
  drop table t1;
  create table t1 (id int) engine=NDB;
  Warnings:
! Error	1286	Unknown table engine 'NDB'
  alter table t1 engine=NDB;
  Warnings:
! Error	1286	Unknown table engine 'NDB'
  drop table t1;
  set table_type=MYISAM;
  Warnings:

How to repeat:
Pushbuild

Suggested fix:
Test case broken?
[15 Dec 2006 14:05] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/17049

ChangeSet@1.2374, 2006-12-15 15:04:46+01:00, msvensson@neptunus.(none) +4 -0
  Bug#24997 warnings test case failure
   - Move the specific test case to a separate file that is run only
     if we have a disabled handler.
[15 Dec 2006 14:06] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/17050

ChangeSet@1.2374, 2006-12-15 15:05:50+01:00, msvensson@neptunus.(none) +5 -0
  Bug#24997 warnings test case failure
   - Move the specific test case to a separate file that is run only
     if we have a disabled handler.
[8 Jan 2007 14:29] Guilhem Bichot
Hello MMJ,
thanks for pointing this out.
Yes, Brian's cset (as I see it in mysql-5.1-arch) can replace this one, however, Brian has this comment in the cset:
"Cleaning up warning for windows. Innodb is compiled but disable on Windows, so it should be fine. NDB wasn't compiled in, which is what caused the issue."
I don't really understand ... InnoDB disabled on Windows? even if this is true, I guess this is not to last... ?