zhengfang.sun comments

Repositories
Issues
Comments

Results 4 comments of


                                            zhengfang.sun

"select *, select 3 from table_a" expect syntax error, but get resultset

druid parser parse the sql as select *,(select 3 from table_a limit 1) ,the parse result is wrong.

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

The issue is when Mysql Client start a transaction and doing some DML sql After that execute a DDL sql，the transaction will be commit **e.g.** begin; --(1) insert into test_a...

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

It's because of the dble did not support the sql 'set sql_select_limit' very well ,and jdbc will make sure the result set size when only set the MaxRows parameter

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

Known limitations stays open