[wp-trac] [WordPress Trac] #33697: utf8mb4 conversion runs on "term_relationships" when perhaps it should not

[WordPress Trac]

#33697: utf8mb4 conversion runs on "term_relationships" when perhaps it should not
--------------------------+----------------------
 Reporter:  tollmanz      |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.2
 Severity:  normal        |  Resolution:  invalid
 Keywords:                |     Focuses:
--------------------------+----------------------

Comment (by pento):

 Are you getting a warning when you run the `ALTER TABLE`? Because it works
 for me:

 {{{
 mysql> SHOW TABLE STATUS LIKE "wp_term_relationships"\G
 *************************** 1. row ***************************
            Name: wp_term_relationships
          Engine: InnoDB
         Version: 10
      Row_format: Compact
            Rows: 1
  Avg_row_length: 16384
     Data_length: 16384
 Max_data_length: 0
    Index_length: 16384
       Data_free: 0
  Auto_increment: NULL
     Create_time: 2015-09-03 02:38:27
     Update_time: NULL
      Check_time: NULL
       Collation: utf8_unicode_ci
        Checksum: NULL
  Create_options:
         Comment:
 1 row in set (0.00 sec)

 mysql> ALTER TABLE wp_term_relationships CONVERT TO CHARACTER SET utf8mb4
 COLLATE utf8mb4_unicode_ci;
 Query OK, 1 row affected (0.00 sec)
 Records: 1  Duplicates: 0  Warnings: 0

 mysql> SHOW TABLE STATUS LIKE "wp_term_relationships"\G
 *************************** 1. row ***************************
            Name: wp_term_relationships
          Engine: InnoDB
         Version: 10
      Row_format: Compact
            Rows: 1
  Avg_row_length: 16384
     Data_length: 16384
 Max_data_length: 0
    Index_length: 16384
       Data_free: 0
  Auto_increment: NULL
     Create_time: 2015-09-03 02:38:43
     Update_time: NULL
      Check_time: NULL
       Collation: utf8mb4_unicode_ci
        Checksum: NULL
  Create_options:
         Comment:
 1 row in set (0.00 sec)
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/33697#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform