Skip to content

Release 2.18.09.0
Compare
Choose a tag to compare
@yanhuqing666 yanhuqing666 released this 31 Aug 07:37
2.18.09.0/tag
0d91c8f

Features:

  • Slow query log, support mysqldumpslow and pt-query-digest #663 . For more details, see:Slow query log
  • Trace for query, like profiling in MySQL #628 . For more details, see:trace
  • Refactor reload @@config_all #586 #601 . For more details, see:reload
  • Dryrun:check config before reload #629 . For more details, see:dryrun
  • Pause and resume used for data expansion #548 . For more details, see:Pause and resume
  • Create database in manager port . For more details, see:Create database
  • Sharding rule support insert null value #567 . For more details, see:rule
  • Select for global table send to the still available dataNode if some dataNodes could not be reached #587
  • Improve the sql statistics,delete/update/insert will be recorded #595
  • Add maxcon for both server and user #574 . For more details, see:server.xml and user

Bug-fixes:

  • Backend conns were killed in an distribution transaction, commit may hang and the inner thread will be occupied #676
  • Subquery union all with all constants order error #666
  • Initialization meta data may randomly cause service stuck when server start #660
  • When where is mis-spell as wher, wher is used as alias #126 (reopen by 2.18.07.0 )
  • Complex query with table alias will cause error when has ` #651
  • With date sharding rule, if sBeginDate is ommitted, do reload will get NPE #625
  • If dataNode's database is not created, execute ddl will get "lost connection ..." #636
  • SubQuery with ”select *“ may cause connection closed and StackOverflow #624
  • manager cmd may get result set of previous manager cmd #631
  • Error when executing "join" syntax with "on" condition and contains subquery #640
  • Error when join with "where" condition and the row values contains null #634
  • Error executing "drop table if exists tableName " when tableName not in schema.xml #638
  • JMX may fail without com.sun.management.jmxremote.host with Java 8 #664
  • Error when query with schema_name.table_name #639
  • Error when union syntax contains no-table-select #359
  • Loss connection when explain link subquery without space #537
  • Error when use between...and... connection subquery #429
  • Union & concat & join can't work together #581
  • Business port and manager port both blocked when exists database in config not created and the database is not used by table #598
  • When doing complex inner join between a small table and a big tanle ,it may get Error #588
  • Join table alias can't use uppercase #582
  • Complex sub query may got error "field not found:autoalias_null.autoalias_scalar" #593
  • Change close funcation of backend conns.

Breaking backward compatibility:

  • Benchmark in server.xml for user is deprecated ,use maxcon to replace #574. For more details, see:server.xml and user

Different from MySQL

  • The log fomart of slow query log is a little different from mysql, but support tools(mysqldumpslow and pt-query-digest) for MySQL
Assets 3
Loading