vibesql 0.1.2

SQL database engine with SQL:1999 compliance
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141

# VibeSQL Test Organization

This directory contains integration tests for VibeSQL, organized by feature area for easy navigation and discoverability.

## Directory Structure

Tests are organized into feature-based subdirectories that mirror the crate structure:

### Core Execution Tests

- **`executor/`** - Query execution and operations
  - Basic CRUD operations (`basic_crud.rs`)
  - Complex queries and joins (`complex_queries.rs`, `northwind_joins.rs`)
  - Set operations (`set_operations.rs`)
  - Aggregates and window functions (`aggregate_patterns.rs`, `window_functions.rs`)
  - CTEs and subqueries (`cte.rs`, `subquery_without_from.rs`)
  - SELECT variations (`select_without_from.rs`, `count_star.rs`)
  - Predicates and WHERE clauses (`predicates.rs`, `complex_where_clauses.rs`)

### Function Tests

- **`functions/`** - Built-in SQL functions
  - String functions (`string_functions.rs`)
  - Spatial/geometric functions (`spatial_functions.rs`)
  - NULL handling (`coalesce.rs`, `nullif_basic.rs`, `is_null_expressions.rs`)
  - Boolean logic (`boolean_short_circuit.rs`, `null_boolean_logic.rs`)
  - Numeric formatting (`numeric_formatting.rs`)
  - Assertions (`assertions.rs`)

### DDL Tests

- **`ddl/`** - Data Definition Language
  - Table operations (`alter_table.rs`)
  - View creation (`create_view.rs`)
  - Schema objects (`create_schema_embedded.rs`, `schema_ddl.rs`)
  - Advanced objects (`create_domain.rs`, `create_type.rs`, `advanced_objects.rs`)

### Storage Tests

- **`storage/`** - Storage engine and indexes
  - Index operations (`update_hash_indexes.rs`)
  - Performance tests (`update_pk_performance.rs`, `insert_constraint_performance.rs`)
  - Transactions (`transaction_features.rs`)
  - Referential integrity (`referential_integrity.rs`, `cascade_operations.rs`)

### Security Tests

- **`security/`** - Access control and privileges
  - GRANT operations (`grant_tests.rs`)
  - REVOKE operations (`revoke_privileges.rs`, `revoke_nonexistent.rs`)

### Compliance Tests

- **`compliance/`** - SQL standard conformance
  - SQLLogicTest suite (`sqllogictest_suite.rs`, `sqllogictest_basic.rs`)
  - SQL:1999 conformance (`sqltest_conformance.rs`)
  - Benchmark tests (`sqllogictest_benchmark.rs`)

### Integration Tests

- **`integration/`** - End-to-end scenarios
  - Web demo tests (`web_demo_*.rs`)
  - Benchmark examples (`benchmark_example.rs`)
  - Resource limits (`resource_limits.rs`)
  - Metrics and monitoring (`metrics.rs`)

### Regression Tests

- **`regression/`** - Issue-specific test cases
  - Individual issue reproductions (`issue_*.rs`)
  - Ensures fixed bugs stay fixed

### Parser Tests

- **`parser/`** - SQL parsing and syntax
  - Error handling (`error_handling.rs`)
  - Comments and directives (`directive_comments.rs`)
  - Identifiers (`delimited_identifiers.rs`)

## Running Tests

### Run All Tests
```bash
cargo test
```

### Run Tests for Specific Feature
```bash
# Run all executor tests
cargo test --test "*" -- executor

# Run specific test file
cargo test --test basic_crud

# Run tests matching pattern
cargo test count_star
```

### Run Integration Tests Only
```bash
cargo test --tests
```

### Run with Output
```bash
cargo test -- --nocapture
```

## Adding New Tests

When adding new tests, place them in the appropriate feature directory:

1. **Identify the feature area** - executor, functions, storage, etc.
2. **Create/update test file** in that directory
3. **Use descriptive names** - `{feature}_{aspect}.rs`
4. **Keep tests focused** - one feature area per file

Example:
```bash
# Adding a new aggregate function test
touch tests/functions/aggregate_functions.rs

# Adding a new JOIN algorithm test
touch tests/executor/merge_join.rs
```

## Test Organization Benefits

**For AI Agents**:
- Quick feature discovery through directory structure
- Pattern-based navigation (`tests/{feature}/`)
- Clear test coverage visibility

**For Developers**:
- Easy to find tests for specific features
- Logical grouping reduces cognitive load
- Scales well as test count grows

## Legacy Structure

Prior to this organization, all 73 integration tests were in a flat `tests/` directory with inconsistent naming (`test_*`, `e2e_*`, `*_tests`). The new structure provides better discoverability and maintainability.