tursodatabase/turso

Pattern Findings

1307 matches across 17 categories. Click a row to expand file-level details.

Over-Commented Block625 hits · 585 pts

Severity	File	Line	Snippet
LOW	sql_generation/generation/mod.rs	41	/// ArbitraryFrom trait for generating random values from a given value
LOW	sql_generation/generation/expr.rs	121	// base: Option::arbitrary_from(rng, t),
LOW	sql_generation/generation/expr.rs	141	// Box::new(\|rng\| {
LOW	sql_generation/generation/expr.rs	161	// let table_idx = pick_index(t.tables.len(), rng);
LOW	sql_generation/generation/opts.rs	21	#[serde(deny_unknown_fields, default)]
LOW	sql_generation/generation/predicate/unary.rs	141	num_retries,
LOW	sql_generation/generation/predicate/unary.rs	201	let column_index = rng.random_range(0..row.len());
LOW	sql_generation/generation/predicate/unary.rs	221	// // True Value with negative is still True
LOW	tools/dbhash/src/encoder.rs	1	//! Value encoding for dbhash.
LOW	core/types.rs	961	mod immutable_record {
LOW	core/types.rs	1601	}
LOW	core/types.rs	1621	/// Reference to header section up to data offset
LOW	core/types.rs	2201	SeekOp::LE { eq_only: false } => std::cmp::Ordering::Less,
LOW	core/types.rs	2221	/// - Payload is at least 2 bytes (header size + first serial type)
LOW	core/types.rs	2301	}
LOW	core/types.rs	2321	/// If any condition fails, it falls back to `compare_records_generic()`.
LOW	core/types.rs	2421	///
LOW	core/types.rs	2441	///
LOW	core/types.rs	3101	Found,
LOW	core/util.rs	1161	.map(\|i\| i + 1)
LOW	core/statement.rs	41	/// is the SQLite-compatible notion of "another SQL statement in progress" used
LOW	core/statement.rs	81	/// indicates if the statement is a NORMAL/EXPLAIN/EXPLAIN QUERY PLAN
LOW	core/error.rs	41	InvalidModifier(String),
LOW	core/lib.rs	181	/// Database index for the temp database (always 1 in SQLite).
LOW	core/lib.rs	401	/// Sub state machine for [`Database::header_validation`], driven from
LOW	core/lib.rs	521	}
LOW	core/lib.rs	541	/// state between iterations, but static variables persist - using shuttle's
LOW	core/percentile.rs	201	/// Standard Deviation implementation using Welford's algorithm
LOW	core/schema.rs	101	/// For temp triggers that target a table in a specific database.
LOW	core/schema.rs	3321	pub plan: Box<Plan>,
LOW	core/busy.rs	1	use crate::MonotonicInstant;
LOW	core/busy.rs	41
LOW	core/stats.rs	21	/// - total_rows = 1000
LOW	core/connection.rs	81	pub(crate) db: Arc<Database>,
LOW	core/connection.rs	181	pub(super) page_size: AtomicU16,
LOW	core/connection.rs	221	pub(super) failure_injector: RwLock<Option<Arc<dyn FailureInjector>>>,
LOW	core/connection.rs	261	pub(crate) fk_deferred_violations: AtomicIsize,
LOW	core/connection.rs	281	/// changes. Allows prepared statements to cheaply detect when they need to be
LOW	core/index_method/fts.rs	481	/// FTS index files are stored in a BTree with the schema `(path TEXT, chunk_no INTEGER, bytes BLOB)`.
LOW	core/index_method/fts.rs	501	/// - The cursor is dropped with pending documents
LOW	core/index_method/mod.rs	61	/// special marker which forces tursodb core to treat index method as backing btree - so it will allocate real btree
LOW	core/index_method/mod.rs	101
LOW	core/index_method/mod.rs	121
LOW	core/incremental/operator.rs	221	group_by: Vec<String>,
LOW	core/incremental/operator.rs	1521
LOW	core/incremental/project_operator.rs	21	#[derive(Clone)]
LOW	core/incremental/compiler.rs	861	),
LOW	core/incremental/cursor.rs	41	/// 1. Persistent btree data (committed state)
LOW	core/incremental/cursor.rs	1181
LOW	core/incremental/expr_compiler.rs	21	// do this?
LOW	core/incremental/aggregate_operator.rs	21	use std::fmt::{self, Display};
LOW	core/incremental/aggregate_operator.rs	41	// - Deletes: Must recompute from the BTree when the current min/max is deleted
LOW	core/incremental/aggregate_operator.rs	61	// A clever reuse of infrastructure: SELECT DISTINCT x, y, z is compiled to:
LOW	core/incremental/aggregate_operator.rs	461	/// State for a single group's aggregates
LOW	core/incremental/aggregate_operator.rs	481	// Populated during FetchKey for values mentioned in the delta
LOW	core/incremental/aggregate_operator.rs	1161	//
LOW	core/incremental/dbsp.rs	121	// The DBSP paper uses as a key the whole record, with both the row key and the values. This is a
LOW	core/incremental/view.rs	181	}
LOW	core/translate/group_by.rs	41	/// Label for the instruction that sets the accumulator indicator to true (indicating data exists in the accumulator
LOW	core/translate/group_by.rs	261	Ok(())
565 more matches not shown…

Decorative Section Separators103 hits · 338 pts

Severity	File	Line	Snippet
MEDIUM	core/storage/encryption.rs	30	/// ┌───────────────┐ ┌───────────────┐
MEDIUM	core/storage/encryption.rs	33	/// │ (4048 bytes) │ ────────► │ Content │
MEDIUM	core/storage/encryption.rs	35	/// ├───────────────┤ ├───────────────┤
MEDIUM	core/storage/encryption.rs	37	/// │ (48 bytes) │ ├───────────────┤
MEDIUM	core/storage/encryption.rs	39	/// └───────────────┘ └───────────────┘
MEDIUM	core/storage/encryption.rs	55	/// ┌─────────┬───────┬────────┬──────────────────┐
MEDIUM	core/storage/encryption.rs	60	/// └─────────┴───────┴────────┴──────────────────┘
MEDIUM	core/vdbe/hash_table.rs	4396	// ── Grace hash join tests ──────────────────────────────────────
MEDIUM	core/mvcc/database/tests.rs	6852	// ─── GC helpers ───────────────────────────────────────────────────────────
MEDIUM	core/mvcc/database/tests.rs	6872	// ─── GC unit tests ───────────────────────────────────────────────────────
MEDIUM	core/mvcc/database/tests.rs	7385	// ─── GC quickcheck property tests ────────────────────────────────────────
MEDIUM	core/mvcc/database/tests.rs	8404	// ─── End-to-end GC + dual cursor tests ───────────────────────────────────
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	19	//! ┌─────────────────────────────────────────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	23	//! ├─────────────────────────────────────────┤
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	25	//! ├─────────────────────────────────────────┤
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	27	//! ├─────────────────────────────────────────┤
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	29	//! └─────────────────────────────────────────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	35	//! ┌─────────────────────────────────────────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	39	//! ├─────────────────────────────────────────┤
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	49	//! ├─────────────────────────────────────────┤
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	52	//! └─────────────────────────────────────────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	150	//! ┌──────────────┬──────────────────────────────┬───────────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	153	//! └──────────────┴──────────────────────────────┴───────────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	156	//! ┌──────────────┬──────────┬──────────┬──────────┬───────────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	159	//! └──────────────┴──────────┴──────────┴──────────┴───────────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	162	//! ┌───────────────────────────┬───────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	164	//! └───────────────────────────┴───────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	169	//! ┌────────┬────────────────────┬──────────┬────────────┬─────────────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	171	//! └────────┴────────────────────┴──────────┴────────────┴─────────────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	181	//! ┌──────┬──────┬────────────┬──────────┬──────┬────────────┬──────┬──────┬──────┬───────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	183	//! └──────┴──────┴─────┼──────┴──────────┴──────┴──────┼─────┴──────┴──────┴──────┴───────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	190	//! ┌──────┬──────┬──────┐ ┌──────┬──────┬──────┬──────┐ ┌──────┬──────┬──────┬──────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	192	//! └──────┴──────┴──────┘ └──────┴──────┴──────┴──────┘ └──────┴──────┴──────┴──────┘
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	201	//! ┌───────────┬────┐ ┌───────────┬────┐ ┌───────────┬────┐
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	204	//! └───────────┴────┘ └───────────┴────┘ └───────────┴────┘
MEDIUM	core/functions/printf.rs	150	// ── Coercion helpers ────────────────────────────────────────────
MEDIUM	core/functions/printf.rs	199	// ── Formatting helpers ──────────────────────────────────────────
MEDIUM	core/functions/printf.rs	440	// ── Rounding (sqlite3.c:36968-36997) ──────────────────────────
MEDIUM	core/functions/printf.rs	505	// ── Integer part (sqlite3.c:32581-32588) ───────────────────────
MEDIUM	core/functions/printf.rs	525	// ── Fractional part (sqlite3.c:32591-32602) ────────────────────
MEDIUM	core/functions/printf.rs	663	// ── Per-specifier formatters ────────────────────────────────────
MEDIUM	core/functions/printf.rs	960	// ── Exponential notation ──────────────────────────────────
MEDIUM	core/functions/printf.rs	967	// ── Fixed-point notation ──────────────────────────────────
MEDIUM	core/functions/printf.rs	1247	// ── Main entry point ────────────────────────────────────────────
MEDIUM	core/functions/printf.rs	1682	// ── Bug fix regression tests ────────────────────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	69	// ── SELECT one field: flat column vs struct field ────────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	117	// ── SELECT two fields: flat columns vs struct fields ────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	163	// ── WHERE filter: flat column vs struct field ───────────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	212	// ── INSERT: flat row vs struct_pack row ─────────────────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	270	// ── Union extract vs flat column read ──────────────────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	309	// ── Union tag scan vs typeof() on flat column ──────────────────────────
MEDIUM	core/benches/struct_union_benchmark.rs	355	// ── criterion wiring ───────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	32	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	34	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	188	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	190	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	292	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	294	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	345	// ──────────────────────────────────────────────────────────
MEDIUM	tests/integration/stmt_journal.rs	347	// ──────────────────────────────────────────────────────────
43 more matches not shown…

Excessive Try-Catch Wrapping179 hits · 246 pts

Severity	File	Line	Snippet
LOW	testing/sqltests/docs/adding-backends.md	271	except Exception as e:
LOW	testing/sqltests/docs/adding-backends.md	276	except Exception as e:
LOW	testing/antithesis/bank-test/anytime_validate.py	8	except Exception as e:
MEDIUM	testing/antithesis/bank-test/anytime_validate.py	9	print(f"Error connecting to database: {e}")
LOW	testing/antithesis/bank-test/finally_validate.py	8	except Exception as e:
MEDIUM	testing/antithesis/bank-test/finally_validate.py	9	print(f"Error connecting to database: {e}")
LOW	testing/antithesis/bank-test/eventually_validate.py	8	except Exception as e:
MEDIUM	testing/antithesis/bank-test/eventually_validate.py	9	print(f"Error connecting to database: {e}")
LOW	testing/antithesis/bank-test/first_setup.py	8	except Exception as e:
MEDIUM	testing/antithesis/bank-test/first_setup.py	9	print(f"Error connecting to database: {e}")
LOW	…esis/bank-test/parallel_driver_generate_transaction.py	21	except Exception as e:
MEDIUM	…esis/bank-test/parallel_driver_generate_transaction.py	22	print(f"Error connecting to database: {e}")
LOW	…sis/stress-composer/parallel_driver_schema_rollback.py	12	except Exception as e:
MEDIUM	…sis/stress-composer/parallel_driver_schema_rollback.py	13	print(f"Error connecting to database: {e}")
LOW	…sis/stress-composer/parallel_driver_schema_rollback.py	33	except Exception as e:
LOW	…is/stress-composer/parallel_driver_nested_savepoint.py	13	except Exception as e:
MEDIUM	…is/stress-composer/parallel_driver_nested_savepoint.py	14	print(f"Error connecting to database: {e}")
LOW	…is/stress-composer/parallel_driver_nested_savepoint.py	35	except Exception as e:
LOW	…esis/stress-composer/parallel_driver_integritycheck.py	12	except Exception as e:
MEDIUM	…esis/stress-composer/parallel_driver_integritycheck.py	13	print(f"Error connecting to database: {e}")
LOW	…esis/stress-composer/parallel_driver_integritycheck.py	32	except Exception as e:
LOW	…tithesis/stress-composer/parallel_driver_drop_index.py	10	except Exception as e:
MEDIUM	…tithesis/stress-composer/parallel_driver_drop_index.py	11	print(f"Error connecting to database: {e}")
LOW	…tithesis/stress-composer/parallel_driver_drop_index.py	19	except Exception as e:
LOW	…tithesis/stress-composer/parallel_driver_drop_index.py	64	except Exception as e:
LOW	…thesis/stress-composer/parallel_driver_create_index.py	12	except Exception as e:
MEDIUM	…thesis/stress-composer/parallel_driver_create_index.py	13	print(f"Error connecting to database: {e}")
LOW	…thesis/stress-composer/parallel_driver_create_index.py	33	except Exception as e:
LOW	…ithesis/stress-composer/parallel_driver_alter_table.py	11	except Exception as e:
MEDIUM	…ithesis/stress-composer/parallel_driver_alter_table.py	12	print(f"Error connecting to database: {e}")
LOW	…ithesis/stress-composer/parallel_driver_alter_table.py	33	except Exception as e:
LOW	…ithesis/stress-composer/parallel_driver_alter_table.py	137	except Exception as e:
LOW	…g/antithesis/stress-composer/parallel_driver_delete.py	12	except Exception as e:
MEDIUM	…g/antithesis/stress-composer/parallel_driver_delete.py	13	print(f"Error connecting to database: {e}")
LOW	…g/antithesis/stress-composer/parallel_driver_delete.py	36	except Exception as e:
LOW	…g/antithesis/stress-composer/parallel_driver_update.py	12	except Exception as e:
MEDIUM	…g/antithesis/stress-composer/parallel_driver_update.py	13	print(f"Error connecting to database: {e}")
LOW	…g/antithesis/stress-composer/parallel_driver_update.py	36	except Exception as e:
LOW	…esis/stress-composer/parallel_driver_wal_checkpoint.py	9	except Exception as e:
LOW	…esis/stress-composer/parallel_driver_wal_checkpoint.py	37	except Exception as e:
LOW	…ntithesis/stress-composer/parallel_driver_savepoint.py	13	except Exception as e:
MEDIUM	…ntithesis/stress-composer/parallel_driver_savepoint.py	14	print(f"Error connecting to database: {e}")
LOW	…ntithesis/stress-composer/parallel_driver_savepoint.py	35	except Exception as e:
LOW	testing/antithesis/stress-composer/first_setup.py	29	except Exception as e:
MEDIUM	testing/antithesis/stress-composer/first_setup.py	30	print(f"Error connecting to database: {e}")
LOW	testing/antithesis/stress-composer/first_setup.py	39	except Exception as e:
MEDIUM	testing/antithesis/stress-composer/first_setup.py	40	print(f"Error connecting to database: {e}")
LOW	…thesis/stress-composer/parallel_driver_create_table.py	12	except Exception as e:
MEDIUM	…thesis/stress-composer/parallel_driver_create_table.py	13	print(f"Error connecting to database: {e}")
LOW	…thesis/stress-composer/parallel_driver_create_table.py	22	except Exception as e:
LOW	…thesis/stress-composer/parallel_driver_create_table.py	138	except Exception as e:
LOW	…antithesis/stress-composer/parallel_driver_rollback.py	12	except Exception as e:
MEDIUM	…antithesis/stress-composer/parallel_driver_rollback.py	13	print(f"Error connecting to database: {e}")
LOW	…antithesis/stress-composer/parallel_driver_rollback.py	32	except Exception as e:
LOW	…tithesis/stress-composer/parallel_driver_drop_table.py	10	except Exception as e:
MEDIUM	…tithesis/stress-composer/parallel_driver_drop_table.py	11	print(f"Error connecting to database: {e}")
LOW	…tithesis/stress-composer/parallel_driver_drop_table.py	28	except Exception as e:
LOW	…g/antithesis/stress-composer/parallel_driver_insert.py	12	except Exception as e:
MEDIUM	…g/antithesis/stress-composer/parallel_driver_insert.py	13	print(f"Error connecting to database: {e}")
LOW	…g/antithesis/stress-composer/parallel_driver_insert.py	32	except Exception as e:
119 more matches not shown…

Hyper-Verbose Identifiers151 hits · 112 pts

Severity	File	Line	Snippet
LOW	…is/stress-composer/parallel_driver_nested_savepoint.py	46	def random_values_with_large_blobs():
LOW	…ntithesis/stress-composer/parallel_driver_savepoint.py	46	def random_values_with_large_blobs():
LOW	testing/antithesis/stress-composer/helper_utils.py	6	def generate_random_identifier(type: str, num: int):
LOW	testing/sqlright/crash_reports/lib/database.py	228	def update_session_crash_count(self, session_id: int):
LOW	testing/sqlright/crash_reports/lib/executor.py	22	def test_crash_against_tursodb(self, sql_content: str) -> Dict[str, Any]:
LOW	testing/sqlright/crash_reports/lib/executor.py	84	def test_crash_against_sqlite(self, sql_content: str) -> Dict[str, Any]:
LOW	testing/cli_tests/constraint.py	348	def regression_test_update_single_key(limbo: TestTursoShell):
LOW	testing/cli_tests/memory.py	127	def test_multi_way_hash_joins(turso: TestTursoShell):
LOW	testing/cli_tests/memory.py	184	def test_hash_join_with_index_preference(turso: TestTursoShell):
LOW	testing/cli_tests/memory.py	208	def test_hash_join_star_pattern_fallback(turso: TestTursoShell):
LOW	testing/cli_tests/memory.py	228	def test_hash_join_outer_join_exclusion(turso: TestTursoShell):
LOW	testing/cli_tests/mvcc.py	15	def test_create_table_with_mvcc():
LOW	testing/cli_tests/cli_test_cases.py	97	def test_switch_back_to_in_memory():
LOW	testing/cli_tests/cli_test_cases.py	163	def test_multi_line_single_line_comments_succession():
LOW	testing/cli_tests/cli_test_cases.py	232	def test_import_csv_create_table_from_header():
LOW	testing/cli_tests/cli_test_cases.py	278	def test_update_with_limit_and_offset():
LOW	testing/cli_tests/cli_test_cases.py	294	def test_insert_default_values():
LOW	testing/cli_tests/cli_test_cases.py	336	def test_copy_memory_db_to_file():
LOW	testing/cli_tests/cli_test_cases.py	374	def test_tables_with_attached_db():
LOW	scripts/update-version.py	237	def create_git_commit_and_tag(version):
LOW	scripts/merge-pr.py	109	def strip_pr_template_from_body(body: str, template_path=".github/pull_request_template.md") -> str:
LOW	scripts/corruption_bisecter.py	21	def run_sql_and_do_integrity_check(
LOW	scripts/corruption-debug-tools/find_corrupt_frame.py	61	def binary_search_corrupt_frame(db_path: str, wal_path: str, verbose: bool = False) -> int:
LOW	bindings/react-native/src/Database.ts	41	function getReservedBytesForCipher(encryption: EncryptionOpts \| undefined): number {
LOW	bindings/python/tests/test_database_sync_aio.py	127	async def test_partial_sync_segment_size():
LOW	bindings/python/tests/test_database_sync_aio.py	157	async def test_partial_sync_prefetch():
LOW	bindings/python/tests/test_database.py	1338	def test_executemany_requires_dml(provider):
LOW	bindings/python/tests/test_database.py	1347	def test_execute_multiple_statements_prohibited(provider):
LOW	bindings/python/tests/test_database.py	1356	def test_description_none_after_insert(provider):
LOW	bindings/python/tests/test_database.py	1366	def test_rowcount_select_is_minus_one(provider):
LOW	bindings/python/tests/test_database.py	1606	def test_named_params_reused_placeholder(provider):
LOW	bindings/python/tests/test_database.py	1615	def test_named_params_extra_key_ignored(provider):
LOW	bindings/python/tests/test_database.py	1624	def test_executemany_named_params_dicts(provider):
LOW	bindings/python/tests/test_database.py	63	def test_fetchall_select_all_users(provider, setup_database):
LOW	bindings/python/tests/test_database.py	76	def test_fetchall_select_user_ids(provider):
LOW	bindings/python/tests/test_database.py	89	def test_in_memory_fetchone_select_all_users(provider):
LOW	bindings/python/tests/test_database.py	124	def test_fetchone_select_all_users(provider):
LOW	bindings/python/tests/test_database.py	141	def test_fetchone_select_max_user_id(provider):
LOW	bindings/python/tests/test_database.py	244	def test_cursor_rowcount_insert(provider):
LOW	bindings/python/tests/test_database.py	256	def test_cursor_rowcount_update(provider):
LOW	bindings/python/tests/test_database.py	269	def test_cursor_rowcount_delete(provider):
LOW	bindings/python/tests/test_database.py	344	def test_connection_executemany(provider):
LOW	bindings/python/tests/test_database.py	357	def test_connection_executescript(provider):
LOW	bindings/python/tests/test_database.py	425	def test_executemany_with_parameters(provider):
LOW	bindings/python/tests/test_database.py	471	def test_insert_returning_partial_fetch(provider):
LOW	bindings/python/tests/test_database.py	491	def test_conflict_clause_ignore(provider):
LOW	bindings/python/tests/test_database.py	506	def test_conflict_clause_replace(provider):
LOW	bindings/python/tests/test_database.py	521	def test_conflict_clause_rollback(provider):
LOW	bindings/python/tests/test_database.py	556	def test_alter_table_add_column(provider):
LOW	bindings/python/tests/test_database.py	856	def test_transaction_begin_commit(provider):
LOW	bindings/python/tests/test_database.py	873	def test_transaction_begin_rollback(provider):
LOW	bindings/python/tests/test_database.py	890	def test_multiple_cursors_same_connection(provider):
LOW	bindings/python/tests/test_database.py	908	def test_cursor_description_before_execute(provider):
LOW	bindings/python/tests/test_database.py	923	def test_cursor_arraysize_default(provider):
LOW	bindings/python/tests/test_database.py	1118	def test_is_not_null_operator(provider):
LOW	bindings/python/tests/test_database.py	1189	def test_upper_lower_functions(provider):
LOW	bindings/python/tests/test_database.py	1249	def test_create_table_if_not_exists(provider):
LOW	bindings/python/tests/test_database.py	1263	def test_drop_table_if_exists(provider):
LOW	bindings/python/tests/test_database.py	1377	def test_cursor_setinput_output_size_noop(provider):
LOW	bindings/python/tests/test_database.py	1387	def test_custom_row_factory_callable(provider):
91 more matches not shown…

Cross-Language Confusion24 hits · 86 pts

Severity	File	Line	Snippet
HIGH	testing/cli_tests/extensions.py	78	turso.run_test_fn(f".load {extension_path}", null)
HIGH	testing/cli_tests/extensions.py	90	turso.run_test_fn("SELECT regexp_substr('the year is unknow', '[0-9]+');", null)
HIGH	testing/cli_tests/extensions.py	113	null,
HIGH	testing/cli_tests/extensions.py	179	null,
HIGH	testing/cli_tests/extensions.py	444	null,
HIGH	testing/cli_tests/extensions.py	454	null,
HIGH	testing/cli_tests/extensions.py	457	turso.run_test_fn("insert into t values ('other', 'value');", null)
HIGH	testing/cli_tests/extensions.py	470	null,
HIGH	testing/cli_tests/extensions.py	480	null,
HIGH	testing/cli_tests/extensions.py	486	turso.run_test_fn("update t set value = 'updated' where key = 'key33';", null)
HIGH	testing/cli_tests/extensions.py	497	turso.run_test_fn("update t set value = 'updated2';", null)
HIGH	testing/cli_tests/extensions.py	506	turso.run_test_fn("delete from t limit 96;", null, "can delete 96 rows")
HIGH	testing/cli_tests/extensions.py	508	turso.run_test_fn("update t set key = '100' where 1;", null, "where clause evaluates properly")
HIGH	testing/cli_tests/extensions.py	790	null,
HIGH	testing/cli_tests/extensions.py	818	turso.run_test_fn("DROP TABLE csv;", null, "Drop CSV table")
HIGH	examples/python/sync_example.py	70	conn.push()
HIGH	bindings/python/tests/test_database_sync_aio.py	65	await conn.push()
HIGH	bindings/python/tests/test_database_sync_aio.py	92	await conn.push()
HIGH	bindings/python/tests/test_sqlalchemy.py	458	sync.push()
HIGH	bindings/python/tests/test_database_sync.py	65	conn.push()
HIGH	bindings/python/tests/test_database_sync.py	91	conn.push()
HIGH	bindings/python/turso/sqlalchemy/dialect.py	509	sync.push() # Push local changes
HIGH	bindings/python/turso/sqlalchemy/dialect.py	693	sync.push()
HIGH	bindings/python/turso/sqlalchemy/__init__.py	30	sync.push() # Push local changes

Unused Imports86 hits · 82 pts

Severity	File	Line
LOW	scripts/corruption-debug-tools/lib/__init__.py	7
LOW	scripts/corruption-debug-tools/lib/__init__.py	7
LOW	scripts/corruption-debug-tools/lib/__init__.py	7
LOW	scripts/corruption-debug-tools/lib/__init__.py	12
LOW	scripts/corruption-debug-tools/lib/__init__.py	12
LOW	scripts/corruption-debug-tools/lib/__init__.py	12
LOW	scripts/corruption-debug-tools/lib/__init__.py	12
LOW	scripts/corruption-debug-tools/lib/__init__.py	12
LOW	scripts/corruption-debug-tools/lib/__init__.py	12
LOW	scripts/corruption-debug-tools/lib/__init__.py	20
LOW	scripts/corruption-debug-tools/lib/__init__.py	20
LOW	scripts/corruption-debug-tools/lib/__init__.py	20
LOW	scripts/corruption-debug-tools/lib/__init__.py	20
LOW	scripts/corruption-debug-tools/lib/__init__.py	20
LOW	scripts/corruption-debug-tools/lib/__init__.py	20
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	scripts/corruption-debug-tools/lib/__init__.py	28
LOW	bindings/python/turso/lib_aio.py	1
LOW	bindings/python/turso/lib.py	1
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/__init__.py	5
LOW	bindings/python/turso/lib_sync.py	1
LOW	bindings/python/turso/lib_sync_aio.py	1
LOW	bindings/python/turso/aio/__init__.py	1
LOW	bindings/python/turso/aio/__init__.py	1
LOW	bindings/python/turso/aio/__init__.py	1
LOW	bindings/python/turso/aio/sync/__init__.py	1
LOW	bindings/python/turso/aio/sync/__init__.py	1
LOW	bindings/python/turso/aio/sync/__init__.py	1
LOW	bindings/python/turso/aio/sync/__init__.py	1
LOW	bindings/python/turso/aio/sync/__init__.py	7
LOW	bindings/python/turso/sqlalchemy/dialect.py	9
LOW	bindings/python/turso/sqlalchemy/__init__.py	33
LOW	bindings/python/turso/sqlalchemy/__init__.py	33
26 more matches not shown…

Verbosity Indicators49 hits · 76 pts

Severity	File	Line	Snippet
LOW	core/incremental/compiler.rs	2054	// We need to check if it's true (non-zero)
LOW	core/translate/trigger_exec.rs	709	// For UPDATE OF, we need to check if any of the specified columns
LOW	core/translate/trigger_exec.rs	752	// For UPDATE OF, we need to check if any of the specified columns
LOW	core/translate/alter.rs	2451	// We need to check if the column exists in the table being renamed
LOW	core/translate/expr/translator.rs	232	// If LHS is NULL, we need to check if ephemeral is empty first.
LOW	core/storage/btree.rs	5678	// Step 1: Move cursor to the largest key in the left subtree.
LOW	core/storage/btree.rs	5746	// Step 2: Replace the cell in the parent (interior) page.
LOW	core/storage/btree.rs	5765	// Step 3: Delete the predecessor cell from the leaf page.
LOW	core/storage/btree.rs	8219	// otherwise, we need to check if we have enough space
LOW	core/vdbe/execute.rs	12314	// Ephemeral tables have their own pager, so we need to check if this is an
LOW	core/mvcc/database/tests.rs	11174	// Step 1: Create many tables, insert data, checkpoint
LOW	core/mvcc/database/tests.rs	11187	// Step 2: Restart (simulates server redeploy)
LOW	core/mvcc/database/tests.rs	11190	// Step 3: Create more tables + insert into old tables, then checkpoint
LOW	core/mvcc/database/tests.rs	11207	// Step 4: Checkpoint - all tables get positive root pages, log truncated
LOW	core/mvcc/database/tests.rs	11210	// Step 5: More writes after checkpoint (un-checkpointed, in the log)
LOW	core/mvcc/database/tests.rs	11224	// Step 6: Restart again - log replay should not panic
LOW	core/mvcc/database/tests.rs	12756	// Step 1: open normally so PRAGMA journal_mode=mvcc creates the logical log.
LOW	core/mvcc/database/tests.rs	12778	// Step 3: re-open with the busy-on-log_tx storage wrapper.
LOW	core/mvcc/database/tests.rs	12808	// Step 3: open a CONCURRENT tx, do an INSERT, then arm log_tx Busy.
LOW	core/mvcc/database/tests.rs	12824	// Step 4: from another CONCURRENT tx, do an INSERT; the INSERT should go through.
LOW	tests/integration/storage/header_version.rs	304	// Step 1: Create a WAL mode database with rusqlite
LOW	tests/integration/storage/header_version.rs	307	// Step 2: Open with limbo WITHOUT MVCC to create WAL data, then close without checkpointing
LOW	tests/integration/storage/header_version.rs	341	// Step 3: Reopen with MVCC enabled and try to switch via PRAGMA
LOW	tests/integration/storage/header_version.rs	413	// Step 1: Create a WAL mode database and convert to MVCC
LOW	tests/integration/storage/header_version.rs	416	// Step 2: Open and switch to MVCC mode via PRAGMA, then add some data
LOW	tests/integration/storage/header_version.rs	449	// Step 3: Reopen and switch to WAL mode via PRAGMA
LOW	tests/integration/query_processing/encryption.rs	608	// Step 2: re-open with correct key (this uses the DATABASE_MANAGER cache)
LOW	tests/integration/query_processing/encryption.rs	644	// Step 3: Opening with wrong key succeeds, but reading data fails with decryption error
LOW	tests/integration/query_processing/encryption.rs	684	// Step 4: Opening without encryption options should fail immediately
LOW	tests/integration/query_processing/encryption.rs	706	// Step 5: verify correct key still works after wrong key attempt
LOW	tests/fuzz/journal_mode.rs	131	// Step 1: Insert a row in MVCC mode
LOW	tests/fuzz/journal_mode.rs	136	// Step 2: Switch to WAL (checkpoints the row to B-tree)
LOW	tests/fuzz/journal_mode.rs	148	// Step 3: Switch back to MVCC (creates new MvStore, row only in B-tree)
LOW	tests/fuzz/journal_mode.rs	161	// Step 4: UPDATE the row
LOW	tests/fuzz/journal_mode.rs	174	// Step 5: DELETE the row
LOW	tests/fuzz/journal_mode.rs	182	// Step 6: Switch to WAL - this triggers checkpoint
LOW	tests/fuzz/journal_mode.rs	232	// Step 1: Create a proper WAL database using SQLite first
LOW	tests/fuzz/journal_mode.rs	245	// Step 2: Open the database with Limbo
LOW	tests/fuzz/journal_mode.rs	264	// Step 3: Create SQLite in-memory database for comparison
LOW	…ting/differential-oracle/fuzzer/custom_types_fuzzer.rs	2217	// Step 1: INSERT
LOW	testing/sqlancer/sqlancer-runner/corruptionAnalysis.ts	47	// Step 1: Get WAL info
LOW	testing/sqlancer/sqlancer-runner/corruptionAnalysis.ts	54	// Step 2: Find corrupting frame
LOW	testing/sqlancer/sqlancer-runner/corruptionAnalysis.ts	57	// Step 3: Run integrity check
LOW	scripts/run-sqlancer.sh	116	# Step 1: Build Limbo JDBC driver if needed
LOW	scripts/run-sqlancer.sh	155	# Step 2: Clone/update SQLancer
LOW	scripts/run-sqlancer.sh	168	# Step 3: Add/update Limbo provider
LOW	scripts/run-sqlancer.sh	200	# Step 4: Patch pom.xml to use Limbo JAR if not already done
LOW	scripts/run-sqlancer.sh	223	# Step 5: Build SQLancer
LOW	scripts/run-sqlancer.sh	227	# Step 6: Run SQLancer

Self-Referential Comments17 hits · 47 pts

Severity	File	Line	Snippet
MEDIUM	docs/language-reference/book/print.html	9364	# Create an encrypted database
MEDIUM	testing/antithesis/stress-composer/first_setup.py	105	# Create a composite index if table has multiple columns
MEDIUM	…thesis/stress-composer/parallel_driver_create_table.py	99	# Create the table
MEDIUM	testing/system/gen-database.py	10	# Create the user table
MEDIUM	examples/python/encryption.py	30	# Create an encrypted database
MEDIUM	examples/python/encryption.py	41	# Create a table and insert sensitive data
MEDIUM	scripts/merge-pr.py	204	# Create a temporary file for the commit message
MEDIUM	.github/workflows/release.yml	266	# Create a GitHub Release while uploading all files to it
MEDIUM	bindings/python/tests/test_database.py	33	# Create a new database file
MEDIUM	bindings/python/tests/test_database_aio.py	26	# Create a new database file
MEDIUM	bindings/python/turso/lib_aio.py	39	# Create the blocking connection inside the worker thread once
MEDIUM	bindings/python/turso/lib_aio.py	339	# Create a connector that opens a blocking Connection using the existing driver.
MEDIUM	perf/connection/gen-database.py	22	# Create the specified number of tables
MEDIUM	perf/connection/rusqlite/gen-database.py	22	# Create the specified number of tables
MEDIUM	perf/connection/limbo/gen-database.py	22	# Create the specified number of tables
MEDIUM	perf/latency/rusqlite/gen-database.py	17	# Create the user table
MEDIUM	perf/latency/limbo/gen-database.py	17	# Create the user table

Cross-File Repetition6 hits · 30 pts

Severity	File	Snippet
HIGH	perf/connection/gen-database.py	generate sqlite databases with specified number of tables for benchmarking.
HIGH	perf/connection/rusqlite/gen-database.py	generate sqlite databases with specified number of tables for benchmarking.
HIGH	perf/connection/limbo/gen-database.py	generate sqlite databases with specified number of tables for benchmarking.
HIGH	perf/connection/gen-database.py	create table if not exists {table_name} ( id integer primary key, name text, value integer, created_at timestamp default
HIGH	perf/connection/rusqlite/gen-database.py	create table if not exists {table_name} ( id integer primary key, name text, value integer, created_at timestamp default
HIGH	perf/connection/limbo/gen-database.py	create table if not exists {table_name} ( id integer primary key, name text, value integer, created_at timestamp default

Deep Nesting25 hits · 25 pts

Severity	File	Line
LOW	testing/antithesis/stress-composer/helper_utils.py	10
LOW	testing/sqlright/crash_reports/query_crashes.py	289
LOW	testing/sqlright/crash_reports/lib/scanner.py	12
LOW	testing/sqlright/crash_reports/lib/scanner.py	175
LOW	testing/cli_tests/constraint.py	370
LOW	testing/cli_tests/write.py	143
LOW	testing/cli_tests/test_turso_cli.py	30
LOW	examples/python/concurrent_writes.py	24
LOW	scripts/update-version.py	105
LOW	scripts/release-status.py	39
LOW	scripts/release-status.py	120
LOW	scripts/corruption_bisecter.py	67
LOW	scripts/compare-divan-std-turso.py	139
LOW	scripts/corruption-debug-tools/page_info.py	28
LOW	scripts/corruption-debug-tools/page_diff.py	22
LOW	scripts/corruption-debug-tools/track_rowid.py	26
LOW	scripts/corruption-debug-tools/page_history.py	27
LOW	scripts/corruption-debug-tools/lib/record.py	82
LOW	scripts/corruption-debug-tools/lib/record.py	114
LOW	scripts/corruption-debug-tools/lib/record.py	186
LOW	scripts/corruption-debug-tools/lib/record.py	225
LOW	bindings/python/tests/utils.py	25
LOW	bindings/python/turso/lib_sync.py	107
LOW	bindings/python/turso/lib_sync.py	227
LOW	bindings/python/turso/lib_sync.py	278

AI Slop Vocabulary9 hits · 24 pts

Severity	File	Line	Snippet
MEDIUM	deny.toml	5	# Include all targets for comprehensive checking
MEDIUM	core/translate/display.rs	608	// Definitely not perfect yet
MEDIUM	core/translate/emitter/mod.rs	766	/// utilize the same limit register, but it is initialized only once.
MEDIUM	core/mvcc/database/tests.rs	1392	#[ignore = "Needs a dedicated bootstrap harness that can create header=MVCC + missing metadata + torn short log atomical
MEDIUM	core/mvcc/persistent_storage/logical_log.rs	3488	/// Why this matters: Edge-case frame shapes must remain parseable to keep format handling robust.
MEDIUM	tests/integration/storage/header_version.rs	518	/// This ensures mode switching is robust and doesn't corrupt data
MEDIUM	tests/fuzz/mod.rs	324	// because this is the only way to utilize an index efficiently for seeking. This is called the "left-prefix rul
MEDIUM	cli/app.rs	106	#[clap(long, help = "Start MVCC concurrent transaction harness")]
LOW	parser/src/lexer.rs	183	#[derive(Clone, PartialEq, Eq, Debug)] // do not derive Copy for Token, just use .clone() when needed

Fake / Example Data18 hits · 21 pts

Severity	File	Line	Snippet
LOW	core/benches/json_benchmark.rs	42	r#"[{"metadata":{"title":"Standard JSON Test File","description":"A complex JSON file for testing parsers an
LOW	core/benches/json_benchmark.rs	42	r#"[{"metadata":{"title":"Standard JSON Test File","description":"A complex JSON file for testing parsers an
LOW	core/benches/json_benchmark.rs	42	r#"[{"metadata":{"title":"Standard JSON Test File","description":"A complex JSON file for testing parsers an
LOW	core/benches/json_benchmark.rs	42	r#"[{"metadata":{"title":"Standard JSON Test File","description":"A complex JSON file for testing parsers an
LOW	core/benches/json_benchmark.rs	42	r#"[{"metadata":{"title":"Standard JSON Test File","description":"A complex JSON file for testing parsers an
LOW	core/benches/json_benchmark.rs	68	"street": "123 Main St",
LOW	core/benches/json_benchmark.rs	705	"name": "Jane Doe",
LOW	serverless/javascript/README.md	60	"INSERT INTO users (email) VALUES ('user@example.com')",
LOW	serverless/javascript/README.md	61	"INSERT INTO users (email) VALUES ('admin@example.com')",
LOW	serverless/javascript/README.md	92	"INSERT INTO users (email) VALUES ('user@example.com')",
LOW	serverless/javascript/README.md	93	"INSERT INTO users (email) VALUES ('admin@example.com')",
LOW	serverless/javascript/src/statement.ts	158	* const result = await stmt.run(['John Doe', 'john.doe@example.com']);
LOW	docs/manual.md	1134	UPDATE users SET name='John Doe' WHERE id=1;
LOW	docs/language-reference/book/print.html	4458	INSERT INTO customers VALUES (1, 'Alice', 'alice@example.com', '555-0100');
LOW	docs/language-reference/book/print.html	5552	INSERT INTO contacts VALUES ('Bob', '555-1234', NULL);
LOW	docs/language-reference/book/print.html	5602	INSERT INTO contacts VALUES ('Bob', '555-1234', NULL);
LOW	docs/language-reference/book/print.html	7785	INSERT INTO contacts VALUES (1, 'Alice', '["555-0100","555-0101"]');
LOW	docs/language-reference/book/print.html	7786	INSERT INTO contacts VALUES (2, 'Bob', '["555-0200"]');

Hallucination Indicators2 hits · 20 pts

Severity	File	Line	Snippet
CRITICAL	sql_generation/model/query/select.rs	344	where_clause: Some(self.body.select.where_clause.0.clone().into_boxed()),
CRITICAL	core/mvcc/database/checkpoint_state_machine.rs	682	version.0.row.id.row_id.clone(),

Redundant / Tautological Comments8 hits · 11 pts

Severity	File	Line	Snippet
LOW	…thesis/stress-composer/parallel_driver_create_index.py	79	# Check if this combination already has an index
LOW	testing/sqlright/crash_reports/lib/scanner.py	197	# Check if file still exists (may have been deleted)
LOW	testing/sqlright/crash_reports/lib/database.py	65	# Check if finding_type column exists on crashes table
LOW	scripts/install-sqlite3.sh	98	# Check if already installed
LOW	scripts/corruption-debug-tools/find_corrupt_frame.py	84	# Check if full WAL is actually corrupt
LOW	scripts/corruption-debug-tools/verify_stale.py	123	# Check if it's close
LOW	scripts/corruption-debug-tools/verify_stale.py	139	# Check if corrupt looks like stale + insertions
LOW	bindings/python/turso/lib.py	664	# Set description to None

Docstring Block Structure1 hit · 5 pts

Severity	File	Line	Snippet
HIGH	bindings/python/turso/sqlalchemy/dialect.py	670	Get the underlying turso.sync.ConnectionSync from a SQLAlchemy connection. This provides access to sync-specif

Example Usage Blocks3 hits · 4 pts

Severity	File	Line	Snippet
LOW	extensions/csv/src/lib.rs	9	//! ## Example usage:
LOW	scripts/clean_interactions.sh	20	# Usage:
LOW	scripts/diff.sh	4	# Usage:

Slop Phrases1 hit · 2 pts

Severity	File	Line	Snippet
LOW	core/storage/wal.rs	3211	// don't forget to release the write-lock if

Score History

Severity Breakdown

Pattern Findings