vibesql-executor 0.2.0

Query execution engine for vibesql SQL database
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
142
143
144

//! Test modules for executor crate
//!
//! Tests are organized by feature area:
//! - `expression_eval`: Expression evaluator tests (literals, column refs, binary ops)
//! - `limit_offset`: LIMIT/OFFSET pagination tests
//! - `select_basic_projection`: Basic SELECT projection tests (wildcards, specific columns)
//! - `select_order_by`: ORDER BY clause tests
//! - `select_derived_columns`: Derived column lists (SQL:1999 E051-07/08) tests
//! - `select_where`: WHERE clause filtering tests
//! - `select_distinct`: DISTINCT keyword tests for duplicate removal
//! - `aggregate_count_sum_avg_tests`: COUNT, SUM, AVG functions with NULL handling
//! - `aggregate_min_max_tests`: MIN, MAX functions on integers and strings
//! - `aggregate_group_by_tests`: GROUP BY clause with aggregates
//! - `aggregate_having_tests`: HAVING clause filtering
//! - `aggregate_edge_case_tests`: Decimal precision, mixed types, CASE expressions
//! - `aggregate_distinct`: DISTINCT aggregation tests
//! - `aggregate_without_from`: Aggregate functions without FROM clause (issue #937)
//! - `aggregate_caching`: Aggregate result caching tests (Phase 2 of issue #1038)
//! - `cte_scalar_subquery_tests`: CTE references in scalar subqueries (issue #2602, TPC-H Q15
//!   pattern)
//! - `recursive_cte_tests`: Recursive CTE tests with UNION and UNION ALL (issue #4480, #4483,
//!   #4485)
//! - `select_joins`: JOIN operation tests
//! - `scalar_subquery_basic_tests`: Basic scalar subquery execution tests
//! - `scalar_subquery_error_tests`: Scalar subquery error handling tests
//! - `scalar_subquery_correlated_tests`: Correlated scalar subquery tests
//! - `subquery_mysql_compat`: MySQL 8.0 compatibility tests for subqueries (issue #1814)
//! - `error_display`: ExecutorError Display implementation tests
//! - `comparison_ops`: Comparison operator tests
//! - `between_predicates`: BETWEEN predicate execution tests
//! - `operator_edge_cases`: Unary operators, NULL propagation, complex nested expressions
//! - `predicate_tests`: IN/NOT IN, LIKE/NOT LIKE, BETWEEN, POSITION, TRIM, CAST tests (organized by
//!   type)
//! - `predicate_pushdown`: Table-local predicate pushdown optimization tests (Phase 2)
//! - `privilege_checker_tests`: Privilege enforcement tests
//! - `query_timeout_tests`: Query timeout enforcement tests (issue #1014)
//! - `quantified_comparison_tests`: Quantified comparison tests (ALL, ANY, SOME with subqueries)
//! - `create_table_tests`: CREATE TABLE executor tests (basic table creation, data types, spatial
//!   types)
//! - `fulltext_search`: Full-text search integration tests (MATCH...AGAINST natural language,
//!   boolean mode)
//! - `triggers`: Organized trigger test suite (DDL, INSERT/UPDATE/DELETE firing, coordination,
//!   conditions, error handling, pseudo-variables)
//! - `truncate_cascade_tests`: TRUNCATE TABLE CASCADE/RESTRICT tests (issue #1393)
//! - `truncate_table_tests`: TRUNCATE TABLE tests (single table, multiple tables, IF EXISTS)
//! - `view_tests`: VIEW support tests (CREATE/DROP/SELECT, OR REPLACE, CASCADE)
//! - `index_scan_tests`: Index scan optimization tests (Phase 5a of issue #1387)
//! - `index_optimization`: Index optimization edge case tests (BETWEEN, IN, commute, numeric types
//!   - issue #1821)
//! - `order_by_index_optimization_tests`: ORDER BY index optimization tests (Phase 5b of issue
//!   #1429)
//! - `alter_table_constraints`: ALTER TABLE ADD/DROP PRIMARY KEY and FOREIGN KEY tests (Phase 6 of
//!   issue #1388)
//! - `non_unique_disk_index_tests`: Non-unique disk-backed index integration tests (issue #1575, PR
//!   #1571)
//! - `sql_mode_tests`: SET SQL_MODE tests for runtime dialect switching (issue #2658)

mod aggregate_caching;
mod aggregate_count_sum_avg_tests;
mod aggregate_distinct;
mod aggregate_edge_case_tests;
mod aggregate_group_by_tests;
mod aggregate_having_tests;
mod aggregate_min_max_tests;
mod aggregate_random_patterns;
mod aggregate_without_from;
mod alter_rename_collision;
mod alter_rename_column_triggers;
mod alter_table_constraints;
mod auto_increment_tests;
mod between_predicates;
mod changes_function_tests;
mod common;
mod comparison_ops;
mod count_star_fast_path;
mod covering_index_tests;
mod create_table_constraints;
mod create_table_tests;
mod cte_scalar_subquery_tests;
mod delete_returning;
mod error_display;
mod expression_eval;
mod expression_index_dml_tests;
mod expression_index_tests;
mod fk_cascade_triggers;
mod foreign_key_mismatch;
mod fulltext_search;
mod function_tests;
mod index_hint_validation;
mod index_optimization;
mod index_scan_tests;
mod insert_returning;
mod issue_938_integer_type_preservation;
mod join_aggregation;
mod lazy_evaluation_tests;
mod limit_offset;
mod natural_join;
mod non_unique_disk_index_tests;
mod not_operator_tests;
mod operator_edge_cases;
mod order_by_compaction_tests;
mod order_by_index_optimization_tests;
mod phase3_join_optimization;
mod predicate_pushdown;
mod predicate_tests;
mod prefix_index_tests;
mod privilege_checker_tests;
mod procedures;
mod quantified_comparison_tests;
mod query_timeout_tests;
mod raise_trigger_tests;
mod recursive_cte_tests;
mod trigger_case_body_tests;
mod rowid_tests;
mod scalar_subquery_basic_tests;
mod scalar_subquery_caching_tests;
mod scalar_subquery_correlated_tests;
mod scalar_subquery_error_tests;
mod search_count_tests;
mod secondary_index_fast_path;
mod select_basic_projection;
mod select_derived_columns;
mod select_distinct;
mod select_into_tests;
mod select_joins;
mod select_order_by;
mod select_values;
mod select_where;
mod select_window_aggregate;
mod select_without_from;
mod set_operations_associativity;
mod sql_mode_tests;
mod subquery_mysql_compat;
mod timeout_enforcement;
mod transaction_tests;
mod triggers;
mod truncate_cascade_tests;
mod truncate_table_tests;
mod unique_index_tests;
mod update_returning;
mod vector_distance_operators;
mod view_tests;
mod window1_quick_wins;
mod window1_residuals;