#10998 D1 - Lowercase BEGIN for trigger definition fails remotely but not locally
D1 backend bug, not wrangler. PR #5889 fixed local case-insensitivity; remote backend lacks fix. Tracked internally as CFSQL-1402. Labeled `internal`.
No action - awaiting D1 backend team fix (CFSQL-1402).
Analysis Report
Issue Review: cloudflare/workers-sdk#10998
Summary
D1 remote backend rejects lowercase begin/end keywords in trigger definitions, while local execution accepts them.
Findings
- Created: 2025-10-16
- Updated: 2025-10-17
- Version: wrangler 4.42.1 → 4.60.0
- Component: D1 (backend)
- Labels: bug, internal, d1
- Comments: 2 (maintainer confirmed and tracked internally)
Key Evidence
- Root cause identified: PR #5889 (merged June 2024) fixed case-insensitivity for
BEGIN/CASEkeywords in local D1 execution, but the remote D1 backend does not have this fix - Maintainer confirmed: @petebacondarwin acknowledged this is a backend issue and created internal Jira ticket CFSQL-1402
- Internal tracking: CFSQL-1402 (status: "Needs Triage", priority: P4 Normal)
internallabel applied: Confirms this requires Cloudflare Platform team support, not a wrangler code fix
Reproduction Summary
-- Fails on remote D1 (lowercase 'begin'):
create trigger ... begin update ... end;
-- Works on remote D1 (uppercase 'BEGIN'):
create trigger ... BEGIN update ... end;
Recommendation
Status: KEEP OPEN
Reasoning: This is a legitimate D1 backend bug, not a wrangler issue. The fix needs to happen in the D1 backend (tracked as CFSQL-1402), not in wrangler. The issue is correctly labeled with internal and serves as public visibility for users encountering this problem.
Action: No action needed on workers-sdk side. Issue should remain open for user visibility and will be resolved when CFSQL-1402 is addressed by the D1 backend team.
Notes & Feedback (0)
No notes yet.