Bug #58197 main.variables-big fails on windows
Submitted: 15 Nov 2010 10:24 Modified: 11 Dec 2010 17:56
Reporter: Mattias Jonsson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1+ OS:Microsoft Windows
Assigned to: Mattias Jonsson CPU Architecture:Any

[15 Nov 2010 10:24] Mattias Jonsson
Description:
test main.variables-big fails on windows, since it does not use unix sockets, the 'SHOW PROCESSLIST' output differs (includes the ip port).

How to repeat:
Run:
perl mysql-test-run.pl --big variables-big
on windows

Suggested fix:
Fixed by changing:
--replace_column 1 <Id> 6 <Time>
to
--replace_column 1 <Id> 3 <Host> 6 <Time>
[15 Nov 2010 10:29] Mattias Jonsson
Adding the 'big-tests' to default.weekly in 5.1 too, after discussion with Anitha Gopi.
[15 Nov 2010 15:18] 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/123931

3505 Mattias Jonsson	2010-11-15
      Bug#58197: main.variables-big fails on windows
      
      The test result differs on windows, since
      it writes out 'localhost:<port>' instead of
      only 'localhost', since it uses tcp/ip instead
      of unix sockets on windows.
      
      Fixed by replacing that column.
      
      Also requires --big-test from some long running tests
      and added a weekly run of all test requiring --big-test.
     @ mysql-test/collections/default.weekly
        Added a run of big-test (already exists in 5.5).
     @ mysql-test/r/variables-big.result
        Updated results
     @ mysql-test/suite/parts/t/part_supported_sql_func_innodb.test
        requiring --big-test since the test takes long time
     @ mysql-test/suite/parts/t/partition_alter1_1_2_innodb.test
        requiring --big-test since the test takes long time
     @ mysql-test/suite/parts/t/partition_alter1_2_innodb.test
        requiring --big-test since the test takes long time
     @ mysql-test/suite/parts/t/partition_alter4_innodb.test
        requiring --big-test since the test takes long time
     @ mysql-test/t/disabled.def
        Disabled two tests since they fail and was already
        reported as bugs (but was never run since they requires
        --big-test flag).
     @ mysql-test/t/variables-big.test
        Replacing column 3 in process list since it
        is not the same on windows as in unix.
[15 Nov 2010 16:46] Horst Hunger
Ready to push.
[16 Nov 2010 0:14] 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/123960

3127 Mattias Jonsson	2010-11-16 [merge]
      Manual merge of bug#58197 to mysql-5.5.
      
      Including adding test in 5.5 requiring --big-test
      flag from mysql-test-run.pl and also disabled
      tests that fails.
     @ mysql-test/collections/default.weekly
        Added all tests requiring --big-test in alphabetical order
     @ mysql-test/r/information_schema-big.result
        Updated result
     @ mysql-test/r/variables-big.result
        updated results
     @ mysql-test/t/disabled.def
        Added tests that fails (has not been run
        regularly since they need --big-test)
[20 Nov 2010 0:08] Paul Dubois
Changes to test suite. No changelog entry needed.
[5 Dec 2010 12:43] Bugs System
Pushed into mysql-trunk 5.6.1 (revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (version source revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (merge vers: 5.6.1) (pib:23)
[15 Dec 2010 5:51] Bugs System
Pushed into mysql-5.1 5.1.55 (revid:sunanda.menon@oracle.com-20101215054055-vgwki317xg1wphhh) (version source revid:sunanda.menon@oracle.com-20101215054055-vgwki317xg1wphhh) (merge vers: 5.1.55) (pib:23)
[16 Dec 2010 22:33] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)