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.