Fixed an issue where tinyint could not be mapped to boolean in MySQL 8.0.19

[seiyeah78]

Summary

• When using MySQL 8.0.19, tinyint is not mapping to boolean throuth ActiveRecord
• This is probably due to the following changes.

Other Information

cited from https://mysqlserverteam.com/the-mysql-8-0-19-maintenance-release-is-generally-available/

Remove integer display width from SHOW CREATE output (WL#13528) This work by Jon Olav Hauglid changes SHOW CREATE to not output integer display width unless ZEROFILL is also used. Without ZEROFILL, integer display width has no effect. This work is a logical consequence of deprecating the display width attribute for integer types (WL#13127).

[eugeneius]

This change will cause TINYINT columns with a display width greater than 1 to be interpreted as boolean attributes instead of integers. I think it will need to be a new framework default to avoid breaking existing applications:

https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/app/templates/config/initializers/new_framework_defaults_6_1.rb.tt

[rails-bot]

This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
Thank you for your contributions.