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/4e6b3e4b-4f3a-4ae0-ac38-acabe7fa7d66?testReportRun=1&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NjaGVtYWNoYW5nZXIvc2NwbGFuOnNjcGxhbl90ZXN0) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):

```
+ DescriptorID: 104
+ JobID: 1
+ *scop.RemoveJobStateFromDescriptor
+ DescriptorID: 105
+ JobID: 1
+ *scop.RemoveJobStateFromDescriptor
+ DescriptorID: 107
+ JobID: 1
+ *scop.RemoveJobStateFromDescriptor
+ DescriptorID: 108
+ JobID: 1
+ *scop.RemoveJobStateFromDescriptor
DescriptorID: 109
- *scop.RemoveJobStateFromDescriptor
- DescriptorID: 104
- JobID: 1
- *scop.RemoveJobStateFromDescriptor
- DescriptorID: 105
- JobID: 1
- *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.UpdateSchemaChangerJob
DescriptorIDsToRemove:
- 104
- 105
- - 106
- - 107
- - 108
- - 109
+ - 107
+ - 108
+ - 109
+ - 110
IsNonCancelable: true
JobID: 1

--- FAIL: TestPlanDataDriven/drop_function (35.32s)
```

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

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

Same failure on other branches

- #174600 pkg/sql/schemachanger/scplan/scplan_test: TestPlanDataDriven failed [C-test-failure O-robot P-3 T-sql-foundations branch-master]

/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 reproduce TestPlanDataDriven/drop_function at commit 807558e5e81666af257c811e925e4cae570abc28, using the linked test invocation and race=true parameters. Compare the generated plan with the failure diff and inspect the drop_function data-driven case. Done means the cause is understood and the test passes with the intended descriptor and job-state plan.

Written by the indexing model from the issue text.