tidb-server 1.0 Pre-GA

• The SQL query optimizer:
  • Adjust the cost model
  • Use index scan to handle the where clause with the compare expression which has different types on each side
  • Support the Greedy algorithm based Join Reorder
• Many enhancements have been introduced to be more compatible with MySQL
• Support Natural Join
• Support the JSON type (Experimental), including the query, update and index of the JSON fields
• Prune the useless data to reduce the consumption of the executor memory
• Support configuring prioritization in the SQL statements and automatically set the prioritization for some of the statements according to the query type
• Completed the expression refactor and the speed is increased by about 30%