October: BOOLEAN requires an integer - does not accept true/false default values

[corepay]

• OctoberCMS Build: 447
• PHP Version: 7.32
• Database Engine: MySQL 5.7
• Plugins Installed: Builder

Description:

Error when adding default value of false or FALSE as default value

Boolean fields require an integer when they should accept values as per SQL standard – TRUE, FALSE, and UNKNOWN.

Steps To Reproduce:

[bennothommo]

@corepay In MySQL, the boolean type is a synonym for tinyint(1), so the default has to be specified as either 0 or 1 to fit the data type.

[LukeTowers]

@BennoThommo I believe laravel handles that when you pass true vs false into the default() method so the builder plugin should probably support that too

[bennothommo]

@LukeTowers You're correct, however, currently the Builder plugin adds true and false as strings if entered in as the default value in the datatable. It would be an improvement if it could handle those values correctly - I'll add it as a "good first issue" for the Builder plugin.

[bennothommo]

@corepay If you're interested in allowing true and false as a default value in the database builder of the Builder plugin, please feel free to contribute a PR to the following issue: https://github.com/rainlab/builder-plugin/issues/280

[corepay]

Thank you for the attention. Cant help with a PR however, not a developer...just an architect that knows just enough about coding to be annoying.

Very much appreciate your hard work though.

[bennothommo]

@corepay Not a problem. Thank you for the report! :)