MySQL Datatype - BIGINT, INT, MEDIUMINT, SMALLINT, TINYINT all "shaving" off sizes
Description
Environment
Linux and MySQL
Attachments
5
- 13 Nov 2013, 08:00 PM
- 13 Nov 2013, 08:00 PM
- 13 Nov 2013, 08:00 PM
- 13 Nov 2013, 08:00 PM
- 13 Nov 2013, 08:00 PM
Activity
Show:
Nathan Voxland November 25, 2013 at 11:03 PM
Appears to be working now. Probably fixed by an earlier issue
Create schema using mysql.sql.
Dump DB (to generate dump_SQL.sql)
Generate changeLog (to generate changelog_sql.xml).
Push to new database.
Generate changeLog (to generate changelog_LB.xml).
Dump DB (to generate dump_LB.sql)
Compare the two "dump" SQL files and note that the sizing for the INT's is slightly smaller than the previous ones. Obviously, we would expect these to be the same size.