Bug #77849 Add missing decoding support for all data types in MySQL-5.5
Submitted: 28 Jul 2015 3:53 Modified: 28 Jul 2015 4:12
Reporter: Neha Kumari Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Utilities: Binlog Events Severity:S3 (Non-critical)
Version:1.0.0 OS:Any
Assigned to: CPU Architecture:Any

[28 Jul 2015 3:53] Neha Kumari
Description:
Currently there is no support for decoding of following data types through Binlog Events:

MYSQL_TYPE_DECIMAL
MYSQL_TYPE_INT24
MYSQL_TYPE_DATE
MYSQL_TYPE_TIME
MYSQL_TYPE_YEAR
MYSQL_TYPE_NEWDATE
MYSQL_TYPE_BIT
MYSQL_TYPE_NEWDECIMAL
MYSQL_TYPE_ENUM
MYSQL_TYPE_SET
MYSQL_TYPE_GEOMETRY

How to repeat:
Create a table with any of the above data types as a type for one of the columns, when  Binlog Events is used to decode and print it the output will be 
"not implemented".

Suggested fix:
Implement the decoding for all the above types.
[7 Aug 2015 13:30] Neha Kumari
This bug http://bugs.mysql.com/bug.php?id=77982
fixes part of the above bug, so the data types implemented as part of 
BUG#77982 are:
MYSQL_TYPE_INT24
MYSQL_TYPE_DATE
MYSQL_TYPE_TIME
MYSQL_TYPE_YEAR
MYSQL_TYPE_BIT

These are still to be implemented:

MYSQL_TYPE_DECIMAL
MYSQL_TYPE_NEWDATE
MYSQL_TYPE_NEWDECIMAL
MYSQL_TYPE_GEOMETRY