Codex DbSqlLikeMem Fix Tests for SQL Provider Behavior
Reproduce failing tests and compare mock results with the real database provider. Keep regression coverage and preserve genuine provider-specific behavior.
中文Install in Codex
Codex with a DbSqlLikeMem checkout and the failing output. Use an isolated test environment and fixtures for provider comparisons.
- Copy the entire pinned `.codex/skills/fix-tests/` directory to `.agents/skills/fix-tests/` in the target checkout.
- Open Codex in that checkout and invoke `$fix-tests` with the example task and desired output.
Example task
Invoke `$fix-tests` to reproduce a query-ordering difference using two fixture rows that include a null. Compare the assertion and isolated database result before changing the mock.What to check
A regression case records the provider behavior and supports a focused change to the expectation or implementation.
Original SKILL.md on GitHub · Updated
Frequently asked question
What if the mock and provider agree and the assertion still fails?
Check the assertion against the observed semantics and record the test data and result that establish the expected behavior.