You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
drug_resource table contains columns: id, name, code, purchase_price, etc.
when query select min(purchase_price) from drug_resource where id > 15 and id <18, should rewrite the sql, such as select min(purchase_price) from drug_resource_5 where id > 15 and id < 18, query on every shard, then calculate each result.
max same as min
Describe the solution you'd like
A clear and concise description of what you want to happen.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.
The text was updated successfully, but these errors were encountered:
dk-lockdown
changed the title
support min(field) on sharded table
support min(field)、max(field) on sharded table
May 22, 2022
Is your feature request related to a problem? Please describe.
if topology is like that:
drug_resource table contains columns: id, name, code, purchase_price, etc.
when query
select min(purchase_price) from drug_resource where id > 15 and id <18
, should rewrite the sql, such asselect min(purchase_price) from drug_resource_5 where id > 15 and id < 18
, query on every shard, then calculate each result.max
same asmin
Describe the solution you'd like
A clear and concise description of what you want to happen.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.
The text was updated successfully, but these errors were encountered: