zhunina

'stm=conn.createStatement()+stm.setFetchSize(Integer.MIN_VALUE) 'makes 'stm.setMaxRows(1)' lost efficacy

2

``` public class TestStatement { Connection conn=null; Statement stm=null; String sql_simple_sql="select * from t3"; String[] sql_muti_sql=new String[2]; String create_sql="create table t3(id int primary key,name varchar(8))"; String drop_sql="DROP TABLE IF EXISTS...

'select syntax' results in implicit submission with ddl on no-sharding-tables preceding

1

``` mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select * from t5 limit 1 for update; +--------------------+------+------+ | id | name | sex | +--------------------+------+------+ | 940051999573934080...

Using date algorithm,default node is not useful for the values which is greater than the boundary with no 'sEndDate'

1

1. ``` current sharding-date-alg yyyy-MM-dd 2000-01-01 15 1 ``` 2. ``` mysql> insert into history values('2000-01-31',1,'aa'); ERROR 1064 (HY000): Index: 2, Size: 2 mysql> insert into history values('1000-01-31',1,'aa'); Query OK,...

The messages is misunderstood when 'insert syntax' has spelling mistakes

3

``` mysql> insert into t5 vlaues('aa'); ERROR 1064 (HY000): NullPointerException mysql> insert into t3 vlaues(3,'aa'); ERROR 1064 (HY000): bad insert sql, sharding column/joinKey:ID not provided,INSERT INTO t3 vlaues (3, 'aa')...