Page MenuHomePhabricator

il_from not always the same size
Closed, ResolvedPublic

Description

Looking through the dbs on dbstore1003 & dbstore1004, I see some il_from being int(8) unsigned and some being int(10) unsigned. Just flagging in case this is an accident. (The docs say it should be int(10))

Event Timeline

The value is just a display value, it doesn't affect the real operation or data under it.

Please note that int(8) unsigned and int(10) unsigned are all the exact same actual data type (4 byte integer, from 0 to 4294967295). https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html

the display width attribute is deprecated for integer data types and support for it will be removed in a future MySQL version

Marostegui claimed this task.

Resolving - if you feel this is not fully resolved, please feel free to reopen!
Thanks