dbaplus Community
Feb 24, 2022 · Backend Development
Why Does SET SQL_SELECT_LIMIT=1 Cause Missing Rows in MySQL Connections?
A mysterious issue where some MySQL queries return only one row after executing SET SQL_SELECT_LIMIT=1 is traced to the MySQL driver’s Statement.setMaxRows method, which sets a session variable that can pollute pooled connections, leading to unexpected row limits.
Connection PoolHikariCPJDBC
0 likes · 8 min read