GPT Final Approval — 22-P1 Helper Functions Prompt rev8

Date: 2026-05-06 Reviewer: GPT-5.5 Thinking / Incomex Hội đồng AI Reviewed: knowledge/dev/laws/dieu44-trien-khai/prompts/22-p1-iu-native-create-helper-functions-prompt.md rev8

Verdict

APPROVED FOR DISPATCH.

Rev8 is sufficiently hardened for P1 execution.

Why this is acceptable now

The prompt now covers the main scale and schema-evolution risks:

• helper reads a column → preflight checks that column;
• no CREATE OR REPLACE;
• helper DDL is transaction-wrapped;
• rollback check uses exact helper names;
• no row DML;
• no hardcoded test vocab/address;
• tests use CTE samples, not string substitution;
• unique guard requires sole-key canonical_address uniqueness;
• trigger checks require enabled O/A, not merely not-disabled;
• L2 is blocker, not warning;
• lifecycle_status coupling removed;
• PUBLIC execute is revoked and verified;
• count drift is audit-only, not false rollback;
• verify_existing diagnostic becomes P2 readiness warning/blocker, not P1 false failure.

Non-blocking notes for Agent execution

1. If any preflight prerequisite fails, STOP before BEGIN; upload report.
2. If any DDL/test fails inside transaction, ROLLBACK and upload partial report.
3. Do not retry with modified SQL.
4. Do not create IU/UV/birth rows.
5. Do not seed iu_create.* defaults.
6. Do not grant adapter roles in P1.
7. If verify_existing returns diagnostic issues, P1 may still PASS, but P2 readiness must mark WARNING/BLOCKER for GPT/User review.

Dispatch instruction

Đọc prompt từ KB rồi thực hiện:

knowledge/dev/laws/dieu44-trien-khai/prompts/22-p1-iu-native-create-helper-functions-prompt.md

Mục tiêu: Tạo 5 helper functions cho IU creation contract. Preflight kiểm mọi cột helpers đọc. Transaction-wrapped. Tests CTE. ROLLBACK nếu fail. Không tạo IU rows.

Report tại:
knowledge/dev/laws/dieu44-trien-khai/reports/22-p1-iu-native-create-helper-functions-report.md

Next gate

After Agent report, GPT/User review before any P2 main fn_iu_create design/execution.