[Koha-bugs] [Bug 33368] borrowers.flags is about to reach the limit

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33368

--- Comment #8 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
(In reply to Victor Grousset/tuxayo from comment #7)
> It works! However I don't get why because bigint(11) still has 11 for the
> number of digits. But it works up to at least 40 bits/flags. And MariaDB's
> doc doesn't have anything suspicious like the number for bigint being there
> for compatibility/historical reasons and not being used.
> https://mariadb.com/kb/en/bigint/
> 
> Anyway, second signoff added so it can still be used as a signoff and Nick
> can pass QA if they know the answer to the above and don't want to wait.

(11) i.e. the 'display width' is not relevant to the storage size, which is the
problem here. Any INT data type will have the same known limit.

It is only relevant if you define things like zero  padding, and then you know
it will fill with zeroes up to 11 digits.

For reference:
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html#:~:text=The%20maximum%20display%20width%20is,digits%20that%20can%20be%20stored.

-- 
You are receiving this mail because:
You are watching all bug changes.