ESP-026 — DDL DROP INDEX IF EXISTS (Firebird + PostgreSQL)

[isaquepinheiro]

ESP-026 — DDL DROP INDEX + IF EXISTS

Estender DROP INDEX (ESP-025) com GetIfExists / método fluente IfExists, e serialização DROP INDEX IF EXISTS em Firebird e PostgreSQL conforme ADR-026. Comportamento actual preservado quando IfExists não é usado.

Scope

• Interfaces IFluentDDLDropIndexDef / IFluentDDLDropIndexBuilder com GetIfExists e IfExists (alinhado a IFluentDDLDropBuilder).
• DDLDropIndexSQL actualizado; excepções conforme ADR-026.
• Testes DUnitX em Test Delphi/test.ddl.pas.
• Documentação: docs-src/docs/fluentsql/guides/ddl-drop-index.md (e referências se necessário).

Out of scope

CONCURRENTLY, CASCADE, múltiplos índices; MySQL-style DROP INDEX … ON table; CHANGELOG/versão fora de /release.

Acceptance criteria

• API e serialização conforme ADR-026 e esp.md.
• Regressão ESP-025 verificada (sem IfExists, comportamento inalterado).
• Testes DUnitX para IfExists em Firebird e PostgreSQL; dialeto não suportado conforme matriz.
• Guia Docusaurus actualizado; npm run build em docs-src se .md alterado.
• Relatórios da esteira sem contradição com ESP-026.

References

esp.md, adr.md, plan.md, task-input.md em .claude/pipeline/.

[isaquepinheiro]

Code review — /review (pipeline)

Verdict: APPROVED WITH CAVEATS

Issue: #41 — ESP-026 / ADR-026 (DROP INDEX + optional \IF EXISTS)

Summary

Implementation matches task.md, esp.md, and ADR-026: \GetIfExists\ / \IfExists\ on \IFluentDDLDropIndex*, \DDLDropIndexSQL\ branches for Firebird and PostgreSQL, updated \ENotSupportedException\ text with ESP-026 + ESP-025 baseline, DUnitX cases and Docusaurus updates per \implement-report.md. Interface GUIDs updated after vtable change (ABI-safe).

Caveats (non-blocking)

• Runtime DUnitX: \implement-report.md\ — Firebird test project MSB6003 in this environment; */test* should run *\TTestDDLDropIndex* where the Delphi toolchain is healthy.
• Pipeline metadata: \ ask.md\ header may still show AWAITING IMPLEMENTATION — optional sync via **/task**.

Kanban

Project FluentSQL (#16): card moved to In review (verified).

Next step

Execute */test* for issue #41.

[isaquepinheiro]

QA /test — APPROVED WITH CAVEATS (issue #41, ESP-026)

Automated

• 
  pm run build\ in \docs-src: PASSED
• \MSBuild\ \PTestFluentSQLFirebird.dproj\ (RAD Studio 23
  svars): FAILED — MSB6003 / long DCC command line (same environment class as prior sessions). DUnitX not executed.

Acceptance criteria

• Verified by static review of \FluentSQL.DDL.Serialize.pas\ (\DDLDropIndexSQL), \ est.ddl.pas\ (\TTestDDLDropIndex), and Docusaurus \ddl-drop-index.md; behaviour matches ADR-026 / task.md.
• Runtime DUnitX evidence still recommended on a host without MSB6003.

Kanban: Issue added to Project 16 and status set to QA Testing.

Next: /develop\ per pipeline.

[isaquepinheiro]

Delivered - closing as part of Kanban hygiene round (ESP-060).