CodingJungle Posted February 1, 2020 Share Posted February 1, 2020 Quote As of MySQL 8.0.17, the ZEROFILL attribute is deprecated for numeric data types, as is the display width attribute for integer data types. Support for ZEROFILL and display widths for integer data types will be removed in a future MySQL version. Consider using an alternative means of producing the effect of these attributes. For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. in mysql 8.0.17 the width attribute for integer data types and zerofill for numeric are ignored. this forces the schema checker to throw an error about difference between the schema and what is on the DB, can you guys place a version check in there that will skip this check for 8.0.17 so we can keep them for older mysql versions? my current dev is 8.0.17 and it would be a pita to have to rollback to an earlier version for something so minor, but it might drive a client who is running the support tool a bit insane with "errors with the database", as schema and db can't be resolved. support tool: DevCenter: Link to comment Share on other sites More sharing options...
bfarber Posted February 3, 2020 Share Posted February 3, 2020 Thanks, I've raised this internally to check on it in a future update. Link to comment Share on other sites More sharing options...
bfarber Posted February 3, 2020 Share Posted February 3, 2020 I've looked into this and I can't get the database checker in the support tool, nor the dev center, to produce incorrect results. On MySQL 8.0.17 I still get the display width attribute returned. It's worth noting that "deprecated" is not "removed". What would I need to do in order to duplicate the issue you are seeing here? Link to comment Share on other sites More sharing options...
CodingJungle Posted February 4, 2020 Author Share Posted February 4, 2020 it is also worth noting that a vast majority of your clients are going to be running IPS on a linux box, so it might be something specific to linux: i'm currently running ubuntu/pop!_os 19.10, i don't do any configuration on mysql outside of installing it. i use the command: sudo apt install mysql-server create my user, and leave it be. i've attached the variables that mysql uses while running, using the following command: mysql -u user -p -A -e"SHOW GLOBAL VARIABLES;" > MySQLCurrentSettings.txt and the configuration that it uses. hope this helps. MySQLCurrentSettings.txt sqlconfig.zip Link to comment Share on other sites More sharing options...
CodingJungle Posted March 6, 2020 Author Share Posted March 6, 2020 i was in windows earlier and upgraded mysql on my local wamp setup to 8.0.19, and decided to give this a quick test. so it seems to be a 8.0.19+ that does this. Link to comment Share on other sites More sharing options...
bfarber Posted March 6, 2020 Share Posted March 6, 2020 We have addressed this for 4.5 already. Link to comment Share on other sites More sharing options...
CodingJungle Posted March 6, 2020 Author Share Posted March 6, 2020 2 hours ago, bfarber said: We have addressed this for 4.5 already. okay the last i saw in this thread was you couldn't reproduce it, and i figured that was cause it was something that was maybe different between windows and linux, and just want to let you know i could reproduce in windows 🙂 thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.