Inconsistency in DBMS Type

Support
#1

Hi, while working with native queries with a MySQL database, I noticed that the BPM_PROC_DEFINITION table uses a TINYINT for the active boolean property in the corresponding entity. This is unexpected because it does not comply with the recommended mapping of DBMS Types.
https://doc.cuba-platform.com/manual-6.10/dbms_types.html
I was expecting a BOOLEAN column.

I just wanted to pass this along, in case it is an issue. Thanks.

#3

Hi,
In MySQL boolean is a synonym for tinyint(1). From the MySQL documentation:

These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true

Scripts of the BPM addon use boolean type: bpm/10.create-db.sql at master · cuba-platform/bpm · GitHub