sql-create

What problem does it solve?

This Skill helps developers and QA engineers quickly produce well-formed CUBRID CTP SQL testcase drafts from bug reports or feature requests, eliminating repetitive formatting, naming, and structural errors that slow down test authoring.

Core Features & Use Cases

• Structured Test Generation: Produce .sql files with the required header block, numbered evaluate labels, paired server-message markers when needed, and setup/cleanup sections following CTP conventions.
• Directory & Naming Guidance: Recommend correct placement under sql/_13_issues or feature directories and filename patterns for bug fixes and new features.
• Answer File Workflow: Explain how to generate .answer files using the sql-runone skill or create a placeholder answer when execution is not possible.
• Self-Review Checklist: Validate presence of header, evaluate labels, DROP TABLE IF EXISTS, server-message pairing, and queryPlan guidance for optimizer tests.

Quick Start

Create a draft SQL testcase for CBRD-12345 in the appropriate sql/*/cases directory including header, evaluate labels, DROP/CREATE setup and cleanup, and instructions to generate the .answer via sql-runone.