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
Sharding-JDBC 5.4 uses the Hint policy. During full-table routing, if the where condition contains the primary key, the modified SQL statement uses union all to connect all table query statements. If there is no primary key, the result is queried from all tables. And merge it. I don't know if I understand it correctly.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Sharding-JDBC 5.4 uses the Hint policy. During full-table routing, if the where condition contains the primary key, the modified SQL statement uses union all to connect all table query statements. If there is no primary key, the result is queried from all tables. And merge it. I don't know if I understand it correctly.
Beta Was this translation helpful? Give feedback.
All reactions