timescale/timescaledb

Pattern Findings

324 matches across 12 categories. Click a row to expand file-level details.

Over-Commented Block286 hits · 286 pts

Severity	File	Line	Snippet
LOW	test/pg_regress.sh	1	#!/usr/bin/env bash
LOW	test/runner_isolation.sh	1	#!/usr/bin/env bash
LOW	test/pg_prove.sh	1	#!/usr/bin/env bash
LOW	test/t/001_replication_telemetry.pl	1	# This file and its contents are licensed under the Timescale License.
LOW	test/t/002_compressed_chunk_apache.pl	1	# This file and its contents are licensed under the Apache License 2.0.
LOW	test/src/test_with_clause_parser.c	1	/*
LOW	test/src/test_utils.c	1	/*
LOW	test/src/loader/init.c	1	/*
LOW	test/src/telemetry/test_telemetry.c	1	/*
LOW	test/src/bgw/log.c	1	/*
LOW	test/src/bgw/timer_mock.c	1	/*
LOW	test/src/bgw/test_job_refresh.c	1	/*
LOW	test/src/bgw/scheduler_mock.c	1	/*
LOW	test/src/bgw/scheduler_mock.c	21	#include <utils/guc.h>
LOW	test/src/bgw/params.c	1	/*
LOW	tsl/test/src/decompress_arithmetic_test_impl.c	1	/*
LOW	tsl/test/src/decompress_arithmetic_test_impl.c	241	#undef ALGO
LOW	tsl/test/src/compression_sql_test.c	61	#define IS_FINITE(X) isfinite((double) (X))
LOW	tsl/test/src/compression_unit_test.c	1	/*
LOW	tsl/test/src/compression_unit_test.c	21	#include <utils/typcache.h>
LOW	tsl/src/chunkwise_agg.c	1	/*
LOW	tsl/src/process_utility.c	1	/*
LOW	tsl/src/chunk_merge.c	1	/*
LOW	tsl/src/chunk_merge.c	21	#include <port.h>
LOW	tsl/src/init.c	1	/*
LOW	tsl/src/init.c	21	#include "compression/algorithms/deltadelta.h"
LOW	tsl/src/init.c	41	#include "nodes/columnar_index_scan/columnar_index_scan.h"
LOW	tsl/src/chunk.c	1	/*
LOW	tsl/src/chunk.c	21	#include <nodes/nodes.h>
LOW	tsl/src/chunk_split.c	1	/*
LOW	tsl/src/chunk_split.c	21	#include <utils/syscache.h>
LOW	tsl/src/reorder.c	21	#include <access/transam.h>
LOW	tsl/src/reorder.c	41	#include <optimizer/planner.h>
LOW	tsl/src/chunk_api.c	1	/*
LOW	tsl/src/chunk_api.c	21	#include <funcapi.h>
LOW	tsl/src/planner.c	1	/*
LOW	tsl/src/continuous_aggs/materialize.c	1	/*
LOW	tsl/src/continuous_aggs/invalidation.c	1	/*
LOW	tsl/src/continuous_aggs/invalidation.c	21	#include <storage/lockdefs.h>
LOW	tsl/src/continuous_aggs/rewrite_with_caggs.c	1	/*
LOW	tsl/src/continuous_aggs/create.c	21	#include <access/sysattr.h>
LOW	tsl/src/continuous_aggs/create.c	41	#include <optimizer/clauses.h>
LOW	tsl/src/continuous_aggs/create.c	61	#include <utils/ruleutils.h>
LOW	tsl/src/continuous_aggs/refresh.c	1	/*
LOW	tsl/src/continuous_aggs/refresh.c	21	#include <utils/tuplestore.h>
LOW	tsl/src/continuous_aggs/utils.c	1	/*
LOW	tsl/src/continuous_aggs/common.h	1	/*
LOW	tsl/src/continuous_aggs/common.h	21	#include <nodes/pg_list.h>
LOW	tsl/src/continuous_aggs/finalize.h	1	/*
LOW	tsl/src/continuous_aggs/invalidation_threshold.c	1	/*
LOW	tsl/src/continuous_aggs/options.c	1	/*
LOW	tsl/src/nodes/columnar_scan/qual_pushdown.c	1	/* * This file and its contents are licensed under the Timescale License.
LOW	tsl/src/nodes/columnar_scan/exec.c	1	/*
LOW	tsl/src/nodes/columnar_scan/exec.c	21	#include <utils/typcache.h>
LOW	tsl/src/nodes/columnar_scan/compressed_batch.c	1	/*
LOW	…nodes/columnar_scan/pred_vector_const_arithmetic_all.c	21	/* int84 functions. */
LOW	…nodes/columnar_scan/pred_vector_const_arithmetic_all.c	41	#define PG_PREDICATE(X) F_INT48##X
LOW	…nodes/columnar_scan/pred_vector_const_arithmetic_all.c	61	/* int28 functions. */
LOW	…nodes/columnar_scan/pred_vector_const_arithmetic_all.c	81
LOW	…nodes/columnar_scan/pred_vector_const_arithmetic_all.c	101	#define VECTOR_CTYPE float4
226 more matches not shown…

Self-Referential Comments7 hits · 21 pts

Severity	File	Line	Snippet
MEDIUM	scripts/label-released.py	61	# Create the label if needed
MEDIUM	scripts/upload_ci_stats.sh	74	# Create the job record.
MEDIUM	scripts/test_update_smoke.sh	136	# Create a 1.7.5 version Upgrade
MEDIUM	scripts/backport.py	529	# Create the backport PR.
MEDIUM	.github/workflows/libfuzzer.yaml	223	# Create the fuzzing functions
MEDIUM	.github/workflows/sanitizer-build-and-test.yaml	101	# Create a directory for sanitizer logs. This directory is referenced by
MEDIUM	.github/workflows/llm-fuzzer.yaml	99	# Create a directory for sanitizer logs. This directory is referenced by

Cross-File Repetition3 hits · 15 pts

Severity	File	Snippet
HIGH	scripts/label-released.py	a simple function to use requests.post to make the graphql api call.
HIGH	scripts/backport.py	a simple function to use requests.post to make the graphql api call.
HIGH	scripts/check_changelog_format.py	a simple function to use requests.post to make the graphql api call.

Decorative Section Separators4 hits · 12 pts

Severity	File	Line	Snippet
MEDIUM	.github/workflows/release_feature_freeze_ceremony.yaml	109	# -------------------------------------------------------
MEDIUM	.github/workflows/release_feature_freeze_ceremony.yaml	113	# -------------------------------------------------------
MEDIUM	.github/workflows/release_feature_freeze_ceremony.yaml	160	# -------------------------------------------------------
MEDIUM	.github/workflows/release_feature_freeze_ceremony.yaml	164	# -------------------------------------------------------

Redundant / Tautological Comments7 hits · 8 pts

Severity	File	Line	Snippet
LOW	tsl/test/t/002_logrepl_decomp_marker.pl	17	# Set max_process_workers to 0 before starting the node
LOW	scripts/delete_released_change_logs.sh	3	# Check if both old_version and new_version have been provided
LOW	scripts/check_changelog_format.py	66	# Check if a line matches any of the specified patterns
LOW	scripts/check_changelog_format.py	97	# Check if the file exists
LOW	scripts/check_changelog_format.py	105	# Read the file and check non-empty lines
LOW	.github/gh_matrix_builder.py	367	# Check if we need to check for the flaky tests. Determine which test files
LOW	.github/workflows/changelog-check.yaml	8	# Check if the PR creates a separate file with changelog entry in the

Synthetic Comment Markers1 hit · 8 pts

Severity	File	Line	Snippet
HIGH	scripts/check_license.sh	9	# - test/sql/dump which contains auto-generated code

Slop Phrases3 hits · 6 pts

Severity	File	Line	Snippet
MEDIUM	test/pg_prove.sh	10	# Note that you can also use regular expressions to run multiple
LOW	scripts/upload_ci_stats.sh	17	# don't forget to append the needed migration code below.
LOW	scripts/upload_ci_stats.sh	17	# don't forget to append the needed migration code below.

Deep Nesting5 hits · 5 pts

Severity	File	Line
LOW	scripts/test_memory_spikes.py	60
LOW	scripts/check_updates.py	39
LOW	scripts/check_updates.py	76
LOW	scripts/check_changelog_format.py	81
LOW	scripts/githooks/commit_msg.py	23

Verbosity Indicators3 hits · 4 pts

Severity	File	Line	Snippet
LOW	tsl/src/continuous_aggs/refresh.c	1115	* In order to don't produce unnecessary batches we need to check if the start and end of the
LOW	tsl/src/compression/recompress.c	683	* compressed. But we need to check if there are any uncompressed tuples in the
LOW	src/process_utility.c	1924	* If it is a "GRANT/REVOKE ON ALL TABLES IN SCHEMA" operation then we need to check if

Hyper-Verbose Identifiers3 hits · 3 pts

Severity	File	Line	Snippet
LOW	scripts/backport.py	217	def should_backport_by_labels(number, title, labels):
LOW	scripts/githooks/commit_msg.py	59	def check_subject_body_separtor(self):
LOW	scripts/githooks/commit_msg.py	70	def check_subject_capitalized(self):

AI Slop Vocabulary1 hit · 3 pts

Severity	File	Line	Snippet
MEDIUM	.github/workflows/pgspot.yaml	1	# Test our extension sql scripts are following security best practices

Example Usage Blocks1 hit · 2 pts

Severity	File	Line	Snippet
LOW	scripts/test_update_smoke.sh	8	# Usage:

Score History

Severity Breakdown

Pattern Findings