joeytrasatti-openai 1b450c7912 Persist thread section moves before the first turn (#39523) ...

## Why

New non-ephemeral threads have no persisted rollout or preview until their first
turn, so moving them into a section could leave them absent from section-filtered
thread lists.

## What changed

- Materialize and flush a non-ephemeral thread before applying an explicit
  section move.
- Include explicitly sectioned threads with empty previews in section-filtered
  queries, and update the partial indexes to cover them.

## Testing

- Add an app-server test that moves a newly started thread into and out of the
  pinned section before its first turn.
- Cover empty-preview threads in recency and section-position query tests.

GitOrigin-RevId: aa3c4daf9890f06c08b93cd60f146099cbc6cfb2

2026-08-19 17:57:40 +00:00

..

0001_threads.sql

…

0002_logs.sql

…

0003_logs_thread_id.sql

…

0004_thread_dynamic_tools.sql

…

0005_threads_cli_version.sql

…

0006_memories.sql

…

0007_threads_first_user_message.sql

…

0008_backfill_state.sql

…

0009_stage1_outputs_rollout_slug.sql

…

0010_logs_process_id.sql

…

0011_logs_partition_prune_indexes.sql

…

0012_logs_estimated_bytes.sql

…

0013_threads_agent_nickname.sql

…

0014_agent_jobs.sql

…

0015_agent_jobs_max_runtime_seconds.sql

…

0016_memory_usage.sql

…

0017_phase2_selection_flag.sql

…

0018_phase2_selection_snapshot.sql

…

0019_thread_dynamic_tools_defer_loading.sql

…

0020_threads_model_reasoning_effort.sql

…

0021_thread_spawn_edges.sql

…

0022_threads_agent_path.sql

…

0023_drop_logs.sql

…

0024_remote_control_enrollments.sql

…

0025_thread_timestamps_millis.sql

…

0026_thread_dynamic_tools_namespace.sql

…

0027_threads_cwd_sort_indexes.sql

…

0028_device_key_bindings.sql

…

0029_thread_goals.sql

…

0030_threads_thread_source.sql

…

0031_drop_device_key_bindings.sql

…

0032_threads_preview.sql

…

0033_thread_goal_stopped_statuses.sql

…

0034_drop_thread_goals.sql

feat: dedicated goal DB (#23300)

2026-05-19 11:11:41 +02:00

0035_drop_memory_tables.sql

Move memory state to a dedicated SQLite DB (#24591)

2026-05-26 20:07:25 +02:00

0036_threads_visible_sort_indexes.sql

Index visible thread list ordering (#27391)

2026-06-10 11:52:17 -05:00

0037_remote_control_enrollments_enabled.sql

feat(app-server): persist remote-control desired state (#27445)

2026-06-11 21:28:52 -07:00

0038_external_agent_config_imports.sql

[codex] Record external agent import results (#28396)

2026-06-15 23:17:24 -07:00

0039_threads_recency_at.sql

[codex] Restore thread recency with compatible migration history (#28671)

2026-06-17 18:52:18 +00:00

0040_threads_history_mode.sql

feat(app-server): add history_mode to thread (#29927)

2026-06-26 09:12:42 -07:00

0041_threads_name.sql

Persist names for paginated threads (#34229)

2026-07-19 21:13:13 +00:00

0042_drop_agent_jobs.sql

Remove CSV-backed agent jobs (#34413)

2026-07-20 21:00:17 +00:00

0043_threads_is_pinned.sql

Add persisted thread pinning to the app server (#34840)

2026-07-22 22:54:28 +00:00

0044_external_agent_config_imports_provider_id.sql

Record externally completed agent config imports (#34981)

2026-07-23 17:55:22 +00:00

0045_threads_section.sql

Add persisted sections for organizing threads (#35722)

2026-07-28 05:26:16 +00:00

0046_threads_section_order.sql

Add persisted manual ordering for thread sections (#36007)

2026-07-29 18:37:22 +00:00

0047_rollout_migration_state.sql

Add rollout migration tooling and background migration (#37348)

2026-08-07 01:26:42 +00:00

0048_thread_section_appearance.sql

Add appearance metadata to thread sections (#37898)

2026-08-10 23:32:42 +00:00

0049_projects.sql

Add experimental app-server project APIs (#38940)

2026-08-17 04:01:37 +00:00

0050_threads_section_empty_preview_indexes.sql

Persist thread section moves before the first turn (#39523)

2026-08-19 17:57:40 +00:00