basalt-26.3.2-rc-20260908: pkg/sql/schemachanger/scplan/scplan_test: TestPlanDataDriven failed

pkg/sql/schemachanger/scplan/scplan_test.TestPlanDataDriven [failed](https://mesolite.cluster.engflow.com/invocations/default/bb2803f0-20da-4132-9bf9-2818a577ee69?testReportRun=2&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NjaGVtYWNoYW5nZXIvc2NwbGFuOnNjcGxhbl90ZXN0) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):

```
*scop.RemoveJobStateFromDescriptor
DescriptorID: 106
JobID: 1
*scop.RemoveJobStateFromDescriptor
DescriptorID: 107
- JobID: 1
- *scop.RemoveJobStateFromDescriptor
- DescriptorID: 108
- JobID: 1
- *scop.RemoveJobStateFromDescriptor
- DescriptorID: 109
JobID: 1
*scop.RemoveJobStateFromDescriptor
DescriptorID: 110
JobID: 1
*scop.RemoveJobStateFromDescriptor
@@ -3119,24 +3113,30 @@
DescriptorID: 116
JobID: 1
*scop.RemoveJobStateFromDescriptor
DescriptorID: 117
JobID: 1
+ *scop.RemoveJobStateFromDescriptor
+ DescriptorID: 118
+ JobID: 1
+ *scop.RemoveJobStateFromDescriptor
+ DescriptorID: 119
+ JobID: 1
*scop.UpdateSchemaChangerJob
DescriptorIDsToRemove:
- 104
- 105
- 106
- 107
- - 108
- - 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
+ - 118
+ - 119
IsNonCancelable: true
JobID: 1

--- FAIL: TestPlanDataDriven/drop_database (48.80s)
```

Parameters:
- attempt=1
- race=true
- run=2
- shard=1
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

/cc @cockroachlabs/sql-foundations

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestPlanDataDriven.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Start with pkg/sql/schemachanger/scplan/scplan_test and the TestPlanDataDriven/drop_database case. Reproduce the failure from the linked test report with race=true, run=2, and shard=1, then compare the generated plan output around RemoveJobStateFromDescriptor and UpdateSchemaChangerJob. Done means the test passes with the correct expected plan.

Written by the indexing model from the issue text.