Recognises a non-idempotent load

N-301 · Skill knobit · Activity: Design the integration patterns · Competence: Data integration and interoperability

A load that inserts again on retry.

Can AI do this?

Not settled yet The benchmark tested this, but the models' answers do not settle yet whether they master it. 0 of 4 models in the current benchmark master it.

Model	Tier	Probability of mastery	Status
gemini-4-argon	Flagship	83%	Not shown
gemini-3.5-flash-lite	Low cost	83%	Not shown
gpt-6-luna	Low cost	83%	Not shown
claude-haiku-5-5	Low cost	83%	Not shown

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: The flow and its idempotency key

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: IF-001 card settlement: INSERT, no key, "rerun on failure" Acceptable: MERGE on txn_id; rerun safe

Also known as: Non-idempotent load

Related knobits

Builds on

N-351 Explains idempotency, error handling and replay

Usually followed by

N-331 Designs an idempotent load on a natural key

All 15 knobits of Design the integration patterns.

Source: Review checklist 03-integration-patterns, row 1 (EIP idempotent receiver)