MySQL: Use bool instead of my_bool since my_bool has been deprecated in MySQL 8.0.1
From the official MySQL docs:
The my_bool type is no longer used in MySQL source code. Any third-party code that used this type to represent C boolean variables should use the bool or int C type instead.
In order to compile the FTS code in newer operating systems, which only have MySQL 8.x libraries, the my_bool
type should be removed.