<p dir="auto">servel.yaml : max.connections.size.per.query &gt;1 and Large amount of data queried<br>
sql :<br>
SELECT<br>
aci.sys_contract_id,<br>
aci.contract_no,<br>
aci.contract_name,<br>
aci.sys_contract_id,<br>
acoi.sys_contract_id,<br>
acoi.object_name,<br>
acoi.sys_object_id,<br>
aci.progress_status,<br>
aci.journal_progress_status<br>
FROM<br>
app1_contract_info aci<br>
LEFT JOIN app1_contract_object_info acoi ON aci.sys_contract_id = acoi.sys_contract_id<br>
where<br>
aci.contract_name = 'sample1' and aci.sys_contract_id not in ('15679933204395H')<br>
group BY/order by<br>
acoi.sys_object_id</p>
<p dir="auto">sys_contract_id is sharding coloum.</p>
<p dir="auto">result: no result and mysql can not receive.</p>
<p dir="auto">but this sql is successd ：<br>
SELECT<br>
aci.sys_contract_id,<br>
aci.contract_no,<br>
aci.contract_name,<br>
aci.sys_contract_id,<br>
acoi.sys_contract_id,<br>
acoi.object_name,<br>
acoi.sys_object_id,<br>
aci.progress_status,<br>
aci.journal_progress_status<br>
FROM<br>
app1_contract_info aci<br>
LEFT JOIN app1_contract_object_info acoi ON aci.sys_contract_id = acoi.sys_contract_id<br>
where<br>
aci.contract_name = 'sample1' and aci.sys_contract_id not in ('15679933204395H')</p>
<h3 dir="auto">Which version of Sharding-Jdbc do you using?（您使用的Sharding-Jdbc版本为？）</h3>
<p dir="auto">2.0.0.M3</p>
<h3 dir="auto">Expected behavior （您预期的结果是）</h3>
<p dir="auto">兼容spring-boot2.0</p>
<h3 dir="auto">Actual behavior （实际运行的结果是）</h3>
<p dir="auto">spring-boot升级2.0后解析不了这样的配置格式，报错<br>
java.lang.IllegalArgumentException: Could not resolve placeholder '0..1' in value "demo.user_${0..1}"</p>