https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33368
--- Comment #8 from Tomás Cohen Arazi <tomasco...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
