Integration Test Guidelines

Integration tests use testserver, a fully functional CockroachDB server with all components in-memory and in the same process. They're SLOW to spin up (can add seconds per test case), so use them only when necessary.

When to Use Integration Tests

Use for:

• SQL execution and query validation
• Transaction behavior
• Schema operations
• Distributed systems behavior

Avoid for:

• Pure logic and data transformations
• Parsing and validation
• Anything that can be unit tested