search

strapi / migration-scripts

Collection of Strapi Migration scripts
58 stars 58 forks source link

Specify implicit order for PostgreSQL to fix duplicate issue #96

Closed derrickmehaffy closed 1 year ago

derrickmehaffy commented 1 year ago

Related to internal TID2761

https://www.postgresql.org/docs/current/queries-limit.html

"Thus, using different LIMIT/OFFSET values to select different subsets of a query result will give inconsistent results unless you enforce a predictable result ordering with ORDER BY. This is not a bug; it is an inherent consequence of the fact that SQL does not promise to deliver the results of a query in any particular order unless ORDER BY is used to constrain the order."

derrickmehaffy commented 1 year ago

confirmed working by customer in ticket