@terrymanu terrymanu released this Sep 28, 2018 · 250 commits to dev since this release

Assets 2

New Features

Sharding-Proxy

  1. ISSUE #1046 Support multiple database schema

Enhancements

core

  1. ISSUE #1205 Execute engine enhancement

Sharding-Opentracing

  1. ISSUE #1172 Opentracing enhancement

API changes

  1. ISSUE #1289 Adjust Hint API
  2. ISSUE #1302 Refine package structure
  3. ISSUE #1305 Deprecated and remove sharding-jdbc-transaction-parent module

Bug Fixes

Core

  1. ISSUE #1265 RoundRobinMasterSlaveLoadBalanceAlgorithm throw an ArrayIndexOutOfBoundsException when AtomicInteger overflow

@terrymanu terrymanu released this Sep 5, 2018 · 1284 commits to dev since this release

Assets 2

New Features

Sharding-Proxy

  1. ISSUE #902 Support XA transaction

Enhancements

Core

  1. ISSUE #373 Support order by ?

Sharding-JDBC

  1. ISSUE #1153 Reconstruct orchestration module to make it independent

API changes

  1. ISSUE #1153 Adjust the maven artifactId for Orchestration module
  2. ISSUE #1203 Change Spring namespace xsd for Sharding + Master-slave configuration

Bug Fixes

Core

  1. ISSUE #1186 Dead lock may occur on MEMORY_STRICTLY mode when get connection on concurrency environment
  2. ISSUE #1120 Derived columns of GROUP BY / ORDER BY appear in query result

Sharding-JDBC

  1. ISSUE #1116 Throw NullPointerException when Using transaction

@terrymanu terrymanu released this Aug 7, 2018 · 2543 commits to dev since this release

Assets 2

New Features

Core

  1. ISSUE #980 Support DCL

Sharding-Proxy

  1. ISSUE #916 Support authorization
  2. ISSUE #936 Support registry center

Enhancements

Core

  1. ISSUE #935 Use YAML instead of JSON to store configurations in registry center
  2. ISSUE #1004 Properties can configure for Sharding and Master-slave independent

Bug Fixes

Core

  1. ISSUE #919 Inline expression with groovy may cause memory leak
  2. ISSUE #1015 Support SQL like SELECT id, COUNT(*) FROM table GROUP BY 1,2

Sharding-JDBC

  1. ISSUE #372 Reuse PreparedStatement cause cache of route result do not clean
  2. ISSUE #993 Fail to parsing PostgreSQL due to the quotation
  3. ISSUE #1011 Can't resolve placeholder in Spring Boot YAML configuration

@terrymanu terrymanu released this May 21, 2018 · 4827 commits to dev since this release

Assets 2

Milestones

  1. Sharding-Proxy launch. Support the use of Sharding-Sphere in the form of database to support for MySQL CLI and GUI client

New Features

Core

  1. ISSUE #290 Support batch INSERT
  2. ISSUE #501 Support OR
  3. ISSUE #1111 Support MySQL DAL

Enhancements

Core

  1. ISSUE #610 Route unicast for DQL without table
  2. ISSUE #701 Caching parsed results to improve performance
  3. ISSUE #773 Support sharding and autoincrement key of INSERT without column names

Sharding-JDBC

  1. ISSUE #652 Support Spring Boot Starter 2.X
  2. ISSUE #702 Support $->{..} for inline expression
  3. ISSUE #719 Support inject key generator objects by spring namespace
  4. ISSUE #720 Support inject sharding algorithm objects by spring namespace

Bug Fixes

Core

  1. ISSUE #628 Support data type jsonb for PostgreSQL
  2. ISSUE #646 When aliases in SELECT ITEMS correspond to the real column names of GROUP BY or ORDER BY, there is no need to generate derived columns
  3. ISSUE #806 NOT IN parse exception
  4. ISSUE #827 Endless loop for bad SQL like SELECT * FROM table WHERE id IN ()
  5. ISSUE #993 Fail to parsing PostgreSQL due to the quotation

Sharding-JDBC

  1. ISSUE #629 Support transaction isolation on JDBC
  2. ISSUE #735 Unexpected slave datasource routing result when using Round-robin load-balance algorithm in Mybatis

@terrymanu terrymanu released this Feb 16, 2018 · 5948 commits to dev since this release

Assets 2

New Features

Core

  1. ISSUE #600 Support TCL

Bug Fixes

Core

  1. ISSUE #540 Support SQL that alias is the keyword
  2. ISSUE #577 Support new line for YAML configuration

Sharding-JDBC

  1. ISSUE #522 Slave database does not need to execute the DDL for read-write splitting

@haocao haocao released this Jan 18, 2018 · 5983 commits to dev since this release

Assets 2

Enhancements

Core

  1. ISSUE #475 Support CREATE INDEX
  2. ISSUE #525 Support DROP INDEX

Bug Fixes

Core

  1. ISSUE #521 ShardingProperties is invalid in YAML configuration
  2. ISSUE #529 Table name capitalization cannot be queried
  3. ISSUE #541 IS NOT NULL parse error
  4. ISSUE #557 When GROUP BY and ORDER BY aliases are inconsistent, stream merging should be used
  5. ISSUE #559 Support parsing numbers beginning with minus and decimal (e.g. -.12)
  6. ISSUE #567 Add escape char for derived columns or alias when using MySQL

Sharding-JDBC

  1. ISSUE #520 Exception is no longer DuplicateKeyException when the unique key conflict

@haocao haocao released this Dec 15, 2017 · 6050 commits to dev since this release

Assets 2

Enhancements

Core

  1. ISSUE #490 Using rownum greater than or equal to or less than or equal to the result of paging is incorrect in Oracle
  2. ISSUE #496 Logical table names in sharding configuration can be case sensitive
  3. ISSUE #497 Close registry center gracefully

Bug Fixes

Sharding-JDBC

  1. ISSUE #489 Uses RuntimeBeanReference to prevent the creation of InnerBean on spring namespace
  2. ISSUE #491 Can't close connection by ResultSet.getStatement().getConnection().close()

@terrymanu terrymanu released this Dec 3, 2017 · 6086 commits to dev since this release

Assets 2

Milestones

  1. API adjust. Brand new groupId and artifactId for Maven, package name and spring namespace name. Simplify and enhance API configuration, inline expression fully configuration support
  2. Support spring-boot-starter of Sharding-JDBC
  3. Dynamic configuration. ZooKeeper and etcd can be used as registry to dynamically modify data sources and sharding configurations
  4. Database orchestration. Fusing database access procedures to access databases and disable access to slave databases
  5. ConfigMap support. Predefined metadata can be obtained in the sharding and read-write separation strategy
  6. Tracking system support. You can view the invocation chain of Sharding-JDBC through sky-walking and other Opentracing based APM systems

Enhancements

Core

  1. ISSUE #386 Support SQL that does not contain table names, such as SELECT 1

Sharding-JDBC

  1. ISSUE #407 Support Hyphen properties for sharding-jdbc-spring-boot-starter
  2. ISSUE #424 Providing SQL overall execution events

Bug Fixes

Core

  1. ISSUE #387 Prevent errors from keywords process when '`' exists in function + column name
  2. ISSUE #419 When SQL is rewritten, it does not determine whether alias is a keyword without the escape character, which results in SQL exception
  3. ISSUE #464 SQL if the varchar type is not closed due to the absence of matching single quotes, and the next varchar in SQL is the wrong SQL of Chinese characters, it will lead to higher use of CPU

Sharding-JDBC

  1. ISSUE #394 Can't only close statement
  2. ISSUE #398 Use Hint routing to shield case sensitivity
  3. ISSUE #404 Sharding-jdbc's spring-boot-starter does not support HikariDataSource
  4. ISSUE #436 Read-write splitting, when the RoundRobin algorithm is configured from the database and MyBatis is used, it can only be routed to the same slave library
  5. ISSUE #452 Sharding of DDL statements to more than one table causes a connection leak
  6. ISSUE #472 Before Connection executes createStatement, it calls getMetaData first and then setAutoCommit can not take effective connection to the database that was created later

@terrymanu terrymanu released this Nov 20, 2017 · 6200 commits to dev since this release

Assets 2

Milestones

  1. Data governance. Fusing database access procedures to access databases and disable access to slave databases
  2. ConfigMap support. Predefined metadata can be obtained in the sharding and read-write separation strategy

Bug Fixes

  1. ISSUE #436 Read-write separation, when the RoundRobin algorithm is configured from the database and MyBatis is used, it can only be routed to the same slave library
  2. ISSUE #452 Sharding of DDL statements to more than one table causes a connection leak

@terrymanu terrymanu released this Nov 6, 2017 · 6240 commits to dev since this release

Assets 2

Milestones

  1. The database access governance of the client can fuse the database access

Enhancements

  1. ISSUE #407 Sharding-jdbc's spring-boot-starter compatibility uses two ways of attribute configuration: minus sign and hump
  2. ISSUE #424 Providing SQL overall execution events

Bug Fixes

  1. ISSUE #404 Sharding-jdbc's spring-boot-starter does not support HikariDataSource
  2. ISSUE #419 When SQL is rewritten, it does not determine whether alias is a keyword without the escape character, which results in SQL exception