[SOLR-8654] SQL: Unlimited SELECT without an ORDER BY should sort by _version_ desc

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Resolved
• Affects Version/s: 6.0
• Assignee: Joel Bernstein
• Reporter: Joel Bernstein
• Created: 07/Feb/16 22:49
• Updated: 27/Jan/22 15:41
• Resolved: 27/Jan/22 15:41

Description

Currently unlimited SELECT statements will throw an exception if an ORDER BY clause is not provided. This is because unlimited selects are handled by the /export handler which requires a sort. Rather then throw an exception we can just order by the version number.