MySQL Bugs: #77849: Add missing decoding support for all data types in MySQL-5.5

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

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.

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