[SOLR-15890] Add a limit to the Admin SQL panel if one is not included in the stmt

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Fix Version/s: 9.0
• Assignee: Joel Bernstein
• Reporter: Joel Bernstein
• Created: 03/Jan/22 19:36
• Updated: 12/May/22 00:35
• Resolved: 03/Jan/22 21:41

Description

Solr's basic select will return all results if a limit is not added to the SQL query. Unlimited SQL queries are not ideal from the admin SQL screen. It's safer to append a LIMIT clause to every SQL query that does not include a LIMIT, rather than surprise the user with a massive result set.

Users can override the LIMIT by adding a LIMIT clause to their SQL statement.