Bug #72441 FTS: plugin_type_version in information_schema.plugins table, wrong version

• Submitted: 24 Apr 2014 16:33
• Modified: 12 Jun 2014 7:30
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Duplicate
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.6.18,5.7.5
• OS: Any
• CPU Architecture: Any

[24 Apr 2014 16:33] Shane Bester

Description:
mysql> select plugin_name,plugin_type_version from information_schema.plugins;
+----------------------------+---------------------+
| plugin_name                | plugin_type_version |
+----------------------------+---------------------+
| INNODB_FT_DEFAULT_STOPWORD | 4242084.180         |
| INNODB_FT_DELETED          | 4241952.212         |
| INNODB_FT_BEING_DELETED    | 4241952.212         |
| INNODB_FT_CONFIG           | 4241949.212         |
| INNODB_FT_INDEX_CACHE      | 4242085.52          |
| INNODB_FT_INDEX_TABLE      | 4242085.52          |

How to repeat:
select plugin_name,plugin_type_version from information_schema.plugins where plugin_name like 'innodb_ft%';

Suggested fix:
=== modified file 'storage/innobase/handler/i_s.cc'
--- storage/innobase/handler/i_s.cc     2014-01-27 13:14:37 +0000
+++ storage/innobase/handler/i_s.cc     2014-04-24 16:29:22 +0000
@@ -2904,7 +2904,7 @@

        /* pointer to type-specific plugin descriptor */
        /* void* */
-       STRUCT_FLD(info, &i_s_stopword_fields_info),
+       STRUCT_FLD(info, &i_s_info),

        /* plugin name */
        /* const char* */
@@ -3076,7 +3076,7 @@

        /* pointer to type-specific plugin descriptor */
        /* void* */
-       STRUCT_FLD(info, &i_s_fts_doc_fields_info),
+       STRUCT_FLD(info, &i_s_info),

        /* plugin name */
        /* const char* */
@@ -3163,7 +3163,7 @@

        /* pointer to type-specific plugin descriptor */
        /* void* */
-       STRUCT_FLD(info, &i_s_fts_doc_fields_info),
+       STRUCT_FLD(info, &i_s_info),

        /* plugin name */
        /* const char* */
@@ -3457,7 +3457,7 @@

        /* pointer to type-specific plugin descriptor */
        /* void* */
-       STRUCT_FLD(info, &i_s_fts_index_fields_info),
+       STRUCT_FLD(info, &i_s_info),

        /* plugin name */
        /* const char* */
@@ -3895,7 +3895,7 @@

        /* pointer to type-specific plugin descriptor */
        /* void* */
-       STRUCT_FLD(info, &i_s_fts_index_fields_info),
+       STRUCT_FLD(info, &i_s_info),

        /* plugin name */
        /* const char* */
@@ -4093,7 +4093,7 @@

        /* pointer to type-specific plugin descriptor */
        /* void* */
-       STRUCT_FLD(info, &i_s_fts_config_fields_info),
+       STRUCT_FLD(info, &i_s_info),

        /* plugin name */
        /* const char* */

[24 Apr 2014 16:42] MySQL Verification Team

this was reported earlier, http://bugs.mysql.com/bug.php?id=70178

[12 Jun 2014 7:30] Erlend Dahl

Duplicate of bug#70178, which has been fixed in 5.6.20, 5.7.5.