Tuesday, July 23, 2019

Some 'Small' Changes in MySQL 8.0.17

I would like to point out some 'small' things you may not have noticed in the MySQL 8.0.17 Release Notes.  They are small changes compared to things like MVIs, InnoDB cloning, and the like but these are the types of changes that are subtle that may catch you unaware.

1. Host names have grown from 60 to 255 characters.  However your SSL/TLS package may not be able to handle the longer names.

2. If you are an old C/C++ programmer, 'C-style &&, ||, and ! operators that are synonyms for the standard SQL AND, OR, and NOT operators, respectively, are deprecated and support for them will be removed in a future MySQL version'.

3. The ZERO fill attribute is being deprecated as is unsigned FLOAT, DOUBLE, and DECIMAL. You can no longer AUTO_INCREMENT FLOAT and DOUBLE columns.

4. The optimizer will rewrite your WHERE foo to WHERE foo != 0 to ensure complete predicates are being used to plan your query.

5 comments:

  1. This Is To Inform You About This Blog "Africans Music Website" That They Have Many Feature Such As
    So If You're Interested In Any Of This Please Do Check The Site Out

    Latest Nigeria Music And Videos

    ReplyDelete
  2. Clone local replica (WL#9209) This work by Debarun Banerjee creates a server plugin that can be used to retrieve a snapshot of the running system. This work adds syntax https://www.assignmentdone.co.uk/ for taking a physical snapshot of the database and store it on the machine where the database server is running.

    ReplyDelete
  3. Excellent blog & I love your
    latest foreign Music you have a good work here... It's hard to find good quality writing like yours nowadays..

    Excellent blog & I love your
    latest naija Music

    ReplyDelete

Due to spammers I now moderate comments