Range-diff !555
back to !555 store: break dashboard updated_at ties by id
1: 2a8f1d3 ! 1: 540541e store: break dashboard updated_at ties by id
@@ internal/store/dashboardplan_test.go: func TestDashboardQueriesUseIndexes(t *tes
}
}
- ## internal/store/migrations/0076_recent_id_order.down.sql (new) ##
+ ## internal/store/migrations/0078_recent_id_order.down.sql (new) ##
@@
+DROP INDEX issues_recent;
+DROP INDEX merge_requests_recent;
+CREATE INDEX issues_recent ON issues(updated_at DESC);
+CREATE INDEX merge_requests_recent ON merge_requests(updated_at DESC);
- ## internal/store/migrations/0076_recent_id_order.up.sql (new) ##
+ ## internal/store/migrations/0078_recent_id_order.up.sql (new) ##
@@
+-- The dashboard breaks updated_at ties by id, newest first. The 0035
+-- indexes carry rowid ascending after updated_at, so that order would