Hello Rahul,
one more addition. Using the build in MySQL driver version 5.x I get the same result as you did. However I just tested it also with the included MySQL 8.x driver and it actually returns BIT for DB Type and Type Name:
So looking at the type name will no longer tell KNIME that this BIT is actually a TINYINT(1) and we can no longer do anything about this discrepancy. I will do some more testing and see if we can safely add a mapping rule from bit to int that you have to explicitly select in the mapping.
Bye
Tobias