title: LIMIT changing sort order on query
body: <p>Two requests with differing LIMIT number are yielding different sorting results.</p>
  <p><code>SELECT &quot;acgti&quot;.&quot;id&quot; AS &quot;id&quot;, &quot;acgti&quot;.&quot;ac_node_id&quot; AS &quot;ac_node_id&quot;, &quot;acgti&quot;.&quot;ac_msn_number&quot; AS &quot;ac_msn_number&quot;, &quot;acgti&quot;.&quot;ac_production_site&quot; AS &quot;ac_production_site_short_name&quot;, &quot;acgti&quot;.&quot;ac_program_id&quot; AS &quot;ac_program_id&quot;, &quot;acgti&quot;.&quot;ac_fal_rank&quot; AS &quot;ac_fal_rank&quot;, &quot;acgti&quot;.&quot;ac_status&quot; AS &quot;ac_status&quot;, &quot;acgti&quot;.&quot;logical_station_production_site&quot; AS &quot;logical_station_production_site&quot;, &quot;acgti&quot;.&quot;logical_station_short_name&quot; AS &quot;logical_station_short_name&quot;, &quot;acgti&quot;.&quot;rgti_node_id&quot; AS &quot;rgti_node_id&quot;, &quot;acgti&quot;.&quot;rgti_release_number&quot; AS &quot;rgti_release&quot;, &quot;acgti&quot;.&quot;rgti_reference&quot; AS &quot;rgti_reference&quot;, &quot;acgti&quot;.&quot;rgti_title&quot; AS &quot;rgti_title&quot;, &quot;acgti&quot;.&quot;rgti_title_second_lang&quot; AS &quot;rgti_title_second_lang&quot;, &quot;acgti&quot;.&quot;status&quot; AS &quot;status&quot;, &quot;acgti&quot;.&quot;created_on&quot; AS &quot;created_on&quot;, &quot;acgti&quot;.&quot;updated_on&quot; AS &quot;updated_on&quot;, &quot;acgti&quot;.&quot;attestation_type&quot; AS &quot;attestation_type&quot;, &quot;created_by&quot;.&quot;fullname&quot; AS &quot;created_by&quot;, CONCAT(&quot;acgti&quot;.&quot;ac_customer_version_name&quot;, '/', &quot;acgti&quot;.&quot;ac_customer_version_rank&quot;) AS &quot;ac_version_and_rank&quot; FROM &quot;ac_gti&quot; &quot;acgti&quot; LEFT JOIN &quot;ext_usr_user&quot; &quot;created_by&quot; ON &quot;created_by&quot;.&quot;username&quot;=&quot;acgti&quot;.&quot;created_by&quot;  LEFT JOIN &quot;ext_usr_user&quot; &quot;updated_by&quot; ON &quot;updated_by&quot;.&quot;username&quot;=&quot;acgti&quot;.&quot;updated_by&quot; WHERE &quot;acgti&quot;.&quot;ac_production_site&quot; IN ('A350 TJN', 'A350 TLS') ORDER BY &quot;acgti&quot;.&quot;rgti_reference&quot; ASC NULLS FIRST LIMIT 10</code></p>
  <p>Yields :</p>
  <p><a href="https://i.stack.imgur.com/6DMCT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6DMCT.png" alt="enter image description here" /></a></p>
  <p><code>SELECT &quot;acgti&quot;.&quot;id&quot; AS &quot;id&quot;, &quot;acgti&quot;.&quot;ac_node_id&quot; AS &quot;ac_node_id&quot;, &quot;acgti&quot;.&quot;ac_msn_number&quot; AS &quot;ac_msn_number&quot;, &quot;acgti&quot;.&quot;ac_production_site&quot; AS &quot;ac_production_site_short_name&quot;, &quot;acgti&quot;.&quot;ac_program_id&quot; AS &quot;ac_program_id&quot;, &quot;acgti&quot;.&quot;ac_fal_rank&quot; AS &quot;ac_fal_rank&quot;, &quot;acgti&quot;.&quot;ac_status&quot; AS &quot;ac_status&quot;, &quot;acgti&quot;.&quot;logical_station_production_site&quot; AS &quot;logical_station_production_site&quot;, &quot;acgti&quot;.&quot;logical_station_short_name&quot; AS &quot;logical_station_short_name&quot;, &quot;acgti&quot;.&quot;rgti_node_id&quot; AS &quot;rgti_node_id&quot;, &quot;acgti&quot;.&quot;rgti_release_number&quot; AS &quot;rgti_release&quot;, &quot;acgti&quot;.&quot;rgti_reference&quot; AS &quot;rgti_reference&quot;, &quot;acgti&quot;.&quot;rgti_title&quot; AS &quot;rgti_title&quot;, &quot;acgti&quot;.&quot;rgti_title_second_lang&quot; AS &quot;rgti_title_second_lang&quot;, &quot;acgti&quot;.&quot;status&quot; AS &quot;status&quot;, &quot;acgti&quot;.&quot;created_on&quot; AS &quot;created_on&quot;, &quot;acgti&quot;.&quot;updated_on&quot; AS &quot;updated_on&quot;, &quot;acgti&quot;.&quot;attestation_type&quot; AS &quot;attestation_type&quot;, &quot;created_by&quot;.&quot;fullname&quot; AS &quot;created_by&quot;, CONCAT(&quot;acgti&quot;.&quot;ac_customer_version_name&quot;, '/', &quot;acgti&quot;.&quot;ac_customer_version_rank&quot;) AS &quot;ac_version_and_rank&quot; FROM &quot;ac_gti&quot; &quot;acgti&quot; LEFT JOIN &quot;ext_usr_user&quot; &quot;created_by&quot; ON &quot;created_by&quot;.&quot;username&quot;=&quot;acgti&quot;.&quot;created_by&quot;  LEFT JOIN &quot;ext_usr_user&quot; &quot;updated_by&quot; ON &quot;updated_by&quot;.&quot;username&quot;=&quot;acgti&quot;.&quot;updated_by&quot; WHERE &quot;acgti&quot;.&quot;ac_production_site&quot; IN ('A350 TJN', 'A350 TLS') ORDER BY &quot;acgti&quot;.&quot;rgti_reference&quot; ASC NULLS FIRST LIMIT 20</code></p>
  <p>Yields different order :</p>
  <p><a href="https://i.stack.imgur.com/BOO1q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BOO1q.png" alt="enter image description here" /></a></p>
  <p>We couldn't figure why, what is going on here?</p>