Bug #59624 funcs_1 Suite Tests Failing With Result Difference When Run Using Embedded Mode
Submitted: 20 Jan 2011 6:55 Modified: 29 Jun 2011 13:31
Reporter: Vinay Fisrekar Email Updates:
Status: Closed Impact on me:
None 
Category:Tests Severity:S3 (Non-critical)
Version:All OS:Any
Assigned to: Vinay Fisrekar CPU Architecture:Any

[20 Jan 2011 6:55] Vinay Fisrekar 
Description:
funcs_1 tests are failing with due to result difference on information_schema table contents.
Not sure if its a test issue or bug. Test are failing for both innodb and myisam engine.

Test failure on mysql-5.6 , mysql-5.5 , mysql-5.1
suite/funcs_1.is_columns_is_embedded 
suite/funcs_1.is_columns_myisam_embedded 
suite/funcs_1.is_columns_mysql_embedded 
suite/funcs_1.is_statistics_mysql_embedded suite/funcs_1.is_table_constraints_mysql_embedded suite/funcs_1.is_tables_mysql_embedded

Additional Test failure on mysql-5.1 (faling with message as - failed: 1071: Specified key was too long; max key length is 767 bytes)
suite/funcs_1.innodb_func_view 
suite/funcs_1.memory_func_view 
suite/funcs_1.myisam_func_view

How to repeat:
Download source code and compile it in embedded mode.

1) Download source code

2) compile with embedded mode
   BUILD/compile-pentium-debug-max

3) perl mysql-test-run.pl  --suite=suite/funcs_1 --force --suite-timeout=500 --max-test-fail=0 --retry-failure=0 --embedded-server --mysqld=--default-storage-engine=innodb --mysqld=--innodb

or 

perl mysql-test-run.pl  --suite=suite/funcs_1 --force --suite-timeout=500 --max-test-fail=0 --retry-failure=0 --embedded-server --mysqld=--default-storage-engine=myisam
[20 Jan 2011 7:59] Valeriy Kravchuk 
Verified with current mysql-5.5 on 32-bit Ubuntu 10.04:

...
Completed: Failed 7/58 tests, 87.93% were successful.

Failing test(s): suite/funcs_1.is_columns_is_embedded suite/funcs_1.is_columns_myisam_embedded suite/funcs_1.is_columns_mysql_embedded suite/funcs_1.is_statistics_mysql_embedded suite/funcs_1.is_table_constraints_mysql_embedded suite/funcs_1.is_tables_mysql_embedded suite/funcs_1.is_engines_innodb
[2 Feb 2011 4:12] 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/130165

3572 Vinay Fisrekar	2011-02-02
      Bug#59624 : funcs_1 Suite Tests Failing With Result Difference When Run Using Embedded Mode
      
      Updating result files for embedded mode tests
[2 Feb 2011 4: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/130166

3295 Vinay Fisrekar	2011-02-02
      Bug#59624 : funcs_1 Suite Tests Failing With Result Difference When Run Using Embedded Mode
      
      Updating result files for embedded mode tests
[2 Feb 2011 4:17] 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/130167

3587 Vinay Fisrekar	2011-02-02
      Bug#59624 : funcs_1 Suite Tests Failing With Result Difference When Run Using Embedded Mode
      
      Updating result files for embedded mode tests
[29 Jun 2011 13:31] Jon Stephens 
Fixed in 5.6.