No one noticed how MySQL 8.0 came out

Unexpectedly for myself, I discovered that mysql was suddenly released just the other day (April 19), and there are no articles on Habré — everyone is discussing you-know-what.

I will try to translate the squeeze from "What's new". For those who follow the development, there probably will not be anything or almost nothing new, for those interested from time to time - it may seem interesting. I must say that in the original post more detailed
analysis of all items - there is only a brief squeeze with references.

Original

• SQL Window functions - window functions
• Common Table Expressions - Constructions like `` `sql
  WITH
  cte1 AS (SELECT a, b FROM table1),
  cte2 AS (SELECT c, d FROM table2)
  SELECT b, d FROM cte1 JOIN cte2
  WHERE cte1.a = cte2.c;
  

Now it’s possible to do some kind of tricks. Bring me Fibonacci numbers or walk me around a tree.

• NOWAIT and SKIP LOCKED - Deny the query to wait for a lock at the table level and at the level of individual rows, respectively.
• Descending Indexes - Descending Indexes
• Grouping - grouping function in GROUP BY constructs
• Regular Expressions - finally done REGEXP_REPLACE
• Character Sets - shut down what they could
• Cost Model - Query Optimizer Insides
• Histograms - histograms for analyzing the query execution plan.
• JSON Extended syntax - new features, improved sorting and partial updates. With JSON table functions, you can use SQL expressions for data in JSON.
• GIS Geography support - now supports various coordinate systems - Spatial Reference Systems (SRS), the corresponding data types, indexes and functions.
• DDL expressions have become atomic and fall-protected, metadata in the transaction table.
• Significant improvements in the "observability" of the system - improved Performance Schema, Information Schema, Configuration Variables, and Error Logging.
• Improvements in remote administration, working with rollback of changes in tablespaces, new DDL elements
• Security - translated the community edition to OpenSSL, added SQL roles,
  crushed the privilege "SUPER" into smaller ones,
• Changed the default authorization and increased the requirements for passwords.
• Improved InnoDB performance on various types of loads.
• Added Resource Group - feature that allows the user to explicitly decompose the load on the cores.
• Repaired the work of the boolean operations with the varbinary (16) type, which simplified the work with ipv6-addresses.

Special thanks for clarifying the comments - petropavel