You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Joel Bernstein (Jira)" <ji...@apache.org> on 2022/01/03 19:44:00 UTC
[jira] [Assigned] (SOLR-15890) Add a limit to the Admin SQL panel if one is not included in the stmt
[ https://issues.apache.org/jira/browse/SOLR-15890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joel Bernstein reassigned SOLR-15890:
-------------------------------------
Assignee: Joel Bernstein
> Add a limit to the Admin SQL panel if one is not included in the stmt
> ---------------------------------------------------------------------
>
> Key: SOLR-15890
> URL: https://issues.apache.org/jira/browse/SOLR-15890
> Project: Solr
> Issue Type: Improvement
> Security Level: Public(Default Security Level. Issues are Public)
> Reporter: Joel Bernstein
> Assignee: Joel Bernstein
> Priority: Major
> Fix For: 9.0
>
> Attachments: SOLR-15890.patch
>
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org