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:38:00 UTC

[jira] [Updated] (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 updated SOLR-15890:
----------------------------------
    Attachment: SOLR-15890.patch

> 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
>            Priority: Major
>         Attachments: SOLR-15890.patch
>
>
> Solr's basic select will return all results if a limit is not added to a 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