Bug #38789 Backup: funcs_1.is_tables_mysql fails in pushbuild
Submitted: 14 Aug 2008 7:50 Modified: 8 Sep 2008 18:07
Reporter: Jorgen Loland Email Updates:
Status: Closed
Category:Server: Backup Severity:S3 (Non-critical)
Version:6.0.6-backup OS:Any
Assigned to: Jorgen Loland Target Version:6.0
Triage: D3 (Medium)

[14 Aug 2008 7:50] Jorgen Loland 
Description:
funcs_1.is_tables_mysql        [ fail ]

---
/data0/pushbuild/pb2-3/pb/bzr_mysql-6.0-backup/41/mysql-6.0.6-alpha-pb41/mysql-test/suite/funcs_1/r/is_tables_mysql.result	2008-08-12
06:44:21.000000000 +0300
+++
/data0/pushbuild/pb2-3/pb/bzr_mysql-6.0-backup/41/mysql-6.0.6-alpha-pb41/mysql-test/suite/funcs_1/r/is_tables_mysql.reject	2008-08-12
08:32:32.000000000 +0300
@@ -282,7 +282,7 @@
 CREATE_TIME	#CRT#
 UPDATE_TIME	#UT#
 CHECK_TIME	#CT#
-TABLE_COLLATION	latin1_swedish_ci
+TABLE_COLLATION	utf8_general_ci
 CHECKSUM	NULL
 CREATE_OPTIONS	#CO#
 TABLE_COMMENT	#TC#
@@ -305,7 +305,7 @@
 CREATE_TIME	#CRT#
 UPDATE_TIME	#UT#
 CHECK_TIME	#CT#
-TABLE_COLLATION	latin1_swedish_ci
+TABLE_COLLATION	utf8_general_ci
 CHECKSUM	NULL
 CREATE_OPTIONS	#CO#
 TABLE_COMMENT	#TC#

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases

How to repeat:
Run funcs_1.is_tables_mysql
[14 Aug 2008 8:47] 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/51609

2683 Jorgen Loland	2008-08-14
      Bug#38789 - Backup: funcs_1.is_tables_mysql fails in pushbuild
      
      Problem: create table scripts for mysql.online_backup% have 
      changed to character set utf8. Test result files did not reflect
      this.
      
      Solution: update test result files
[14 Aug 2008 8:51] Jorgen Loland 
The test is_columns_mysql also failed because of the changed table definition. The
submitted fix also applies to that test result file.
[14 Aug 2008 9:29] Oystein Grovlen 
Patch is good, and may be pushed.
[14 Aug 2008 10:31] 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/51619

2683 Jorgen Loland	2008-08-14
      Bug#38789 - Backup: funcs_1.is_tables_mysql fails in pushbuild
      
      Problem: create table scripts for mysql.online_backup% have 
      changed to character set utf8. Test result files did not reflect
      this.
      
      Solution: update test result files
[14 Aug 2008 12:21] 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/51630

2683 Jorgen Loland	2008-08-14
      Bug#38789 - Backup: funcs_1.is_tables_mysql fails in pushbuild
            
      Problem: create table scripts for mysql.online_backup% have 
      changed to character set utf8. Test result files did not reflect
      this.
            
      Solution: update test result files
[14 Aug 2008 14:07] 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/51638

2674 Jorgen Loland	2008-08-14
      Bug#38789 - Backup: funcs_1.is_tables_mysql fails in pushbuild
            
      Problem: create table scripts for mysql.online_backup% have 
      changed to character set utf8. Test result files did not reflect
      this.
            
      Solution: update test result files
[25 Aug 2008 15:33] 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/52469
[8 Sep 2008 18:07] Paul DuBois 
Test case changes. No changelog entry needed.
[13 Sep 2008 22:15] Bugs System 
Pushed into 6.0.6-alpha  (revid:jorgen.loland@sun.com-20080814084835-vqjd7hb2877yd0uy)
(version source revid:hakan@mysql.com-20080716105246-eg0utbybp122n2w9) (pib:3)