Skip to content

KeySet pagination optimizer works with ignored columns

Mario Celi requested to merge 417043-keyset-optimizer-allows-ignored-columns into master

What does this MR do and why?

When we ignore a column in ActiveRecord, select statements will be explicit about the columns it wants to select instead of using the more generic SELECT "table".*

This is a problem with the KeySetOrder optimizer since the select statement will try to select columns that were not selected in the original scope if scope.select_values are specified

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #417043 (closed)

Merge request reports