OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)
This report presents the forensic synthetic code analysis of orioledb/orioledb, a C project with 4,152 GitHub stars. SynthScan v2.0 examined 190,269 lines of code across 355 source files, recording 920 pattern matches distributed across 16 syntactic categories. The overall adjusted score of 6.4 places this repository in the Low AI signal band.
The scanner applied 160+ deterministic lexical heuristics, multi-line block detectors, abstract syntax tree depth profilers, and a cross-file Jaccard similarity matrix to construct a statistically normalised synthetic code estimate. All matches are individually weighted by severity coefficient and contextual multiplier before summation, and the resulting headline score is temporally discounted to account for the repository's development history relative to the commercial emergence of large language model coding tooling (November 2022 onward).
Longitudinal tracking requires multiple scan runs. Once this repository is re-scanned after new commits land, this chart will visualise how the synthetic code signal evolves over time — enabling you to detect whether AI authorship is growing, stabilising, or being actively corrected by human engineers.
Classifies detected patterns by their diagnostic confidence and structural impact. CRITICAL patterns (coefficient 10) represent definitive synthetic signatures — hallucinated imports, explicit LLM attribution metadata — virtually never produced by human authors. HIGH (5) indicates strong structural tells such as cross-file repetition or cross-linguistic idioms. MEDIUM (2) covers recognisable conversational padding and AI-specific vocabulary. LOW (1) captures subtle indicators like tautological comments and generic boilerplate that require density to carry independent signal.
This horizontal bar chart decomposes the repository's raw synthetic code score by top-level directory, allowing you to pinpoint precisely which modules or components carry the highest AI authorship density. Directories with disproportionately high scores relative to their size warrant targeted manual review: concentrated AI signatures often trace back to mass-generated configuration layers, auto-ported test suites, LLM-scaffolded boilerplate classes, or entire subsystems authored under heavy copilot assistance. Use this view to prioritise your human code-review effort.
The scanner identified 920 distinct pattern matches across 16 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a statistically significant AI authorship indicator. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.
Reading the findings table: The Severity column indicates the diagnostic confidence level (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — comment-context matches receive a ×1.5 weight because LLMs systematically over-annotate. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier as dense clusters constitute far stronger evidence of synthetic authorship than isolated hits.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 201 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 203 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 209 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 211 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 219 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 221 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 228 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 230 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 265 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 267 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 274 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 276 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 293 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 295 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 302 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 304 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 421 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 423 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 429 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 431 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 441 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 444 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 463 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 465 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 474 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 476 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 546 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/pgbackrest_test.py | 548 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 27 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 29 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 69 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 71 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 350 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 352 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 384 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 386 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 490 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/pgbackrest_test.py | 492 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 310 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 312 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 322 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 324 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 434 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 436 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 442 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 444 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 520 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM⚡ | test/integration/walg_test.py | 522 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 23 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 25 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 54 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 56 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 242 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 244 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 259 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 261 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 278 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 280 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 357 | # ------------------------------------------------------------------ | COMMENT |
| MEDIUM | test/integration/walg_test.py | 359 | # ------------------------------------------------------------------ | COMMENT |
| 42 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | orioledb_s3_loader.py | 336 | def download_files_in_directory(self, | STRING |
| LOW | orioledb_s3_loader.py | 406 | def download_unchanged_small_files(self, bucket_name: str, | STRING |
| LOW | orioledb_s3_loader.py | 494 | def get_unchanged_file_checksums(self, file_checksums_name: str, | STRING |
| LOW | orioledb_s3_loader.py | 541 | def get_orioledb_control_data(data_dir: str): | STRING |
| LOW | typedefs_gen.py | 41 | def extract_typedefs_dwarfdump(): | CODE |
| LOW⚡ | test/integration/pgbackrest_test.py | 553 | def test_incr_backup_block_diffs_orioledb_file(self): | CODE |
| LOW | test/integration/pgbackrest_test.py | 170 | def _wait_for_history_archive(self, standby, timeout=30): | CODE |
| LOW⚡ | test/integration/walg_test.py | 526 | def test_delta_backup_ships_whole_orioledb_file(self): | CODE |
| LOW | test/integration/walg_test.py | 164 | def _wait_for_history_archive(self, standby, timeout=30): | CODE |
| LOW | test/integration/walg_test.py | 219 | def _restore_primary_in_place(self, recovery_lines): | CODE |
| LOW | test/t/base_test.py | 419 | def crash_with_os_buffer_loss(self, mark_name: str = 'crash_point'): | CODE |
| LOW | test/t/base_test.py | 723 | def wait_checkpointer_stopevent(node): | CODE |
| LOW | test/t/base_test.py | 761 | def release_parked_flush_on_lock(node, | CODE |
| LOW | test/t/parallel_test.py | 9 | def test_parallel_empty_select(self): | CODE |
| LOW | test/t/parallel_test.py | 33 | def test_not_using_gather_during_recovery_for_sql_opclass_function(self): | STRING |
| LOW | test/t/eviction_bgwriter_test.py | 16 | def test_eviction_multiple_bgwriters(self): | CODE |
| LOW | test/t/eviction_bgwriter_test.py | 42 | def test_eviction_bgwriter_invalidation(self): | CODE |
| LOW | test/t/eviction_bgwriter_test.py | 70 | def test_bgwriter_keeps_number_across_crash(self): | CODE |
| LOW | test/t/checkpoint_update_base_test.py | 13 | def concurrent_update_eviction_base(self, | CODE |
| LOW | test/t/incomplete_split_test.py | 44 | def test_incomplete_leaf_insert_fix(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 72 | def test_incomplete_leaf_insert_checkpoint_fix_middle(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 106 | def test_incomplete_leaf_insert_checkpoint_fix_end(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 140 | def test_incomplete_leaf_checkpoint_fix(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 180 | def test_incomplete_node_insert_fix(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 206 | def test_incomplete_node_checkpoint_fix(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 253 | def test_incomplete_split_sequence(self): | STRING |
| LOW | test/t/incomplete_split_test.py | 443 | def test_tbl_check_sees_pending_tmpbuf_freelist(self): | STRING |
| LOW | test/t/indices_build_test.py | 16 | def test_index_build_checkpoint(self): | CODE |
| LOW | test/t/indices_build_test.py | 59 | def test_index_build_recovery(self): | STRING |
| LOW | test/t/indices_build_test.py | 109 | def test_drop_primary_recovery(self): | CODE |
| LOW | test/t/indices_build_test.py | 163 | def test_create_primary_recovery(self): | STRING |
| LOW | test/t/indices_build_test.py | 291 | def test_index_build_replication(self): | STRING |
| LOW | test/t/indices_build_test.py | 418 | def test_multiple_indices_build_replication(self): | STRING |
| LOW | test/t/indices_build_test.py | 586 | def test_indices_build_concurrent_checkpoint(self): | STRING |
| LOW | test/t/merge_test.py | 34 | def test_non_concurrent_merge_and_checkpoint(self): | CODE |
| LOW | test/t/merge_test.py | 60 | def _open_merge_diff_snapshot(self, table): | CODE |
| LOW | test/t/merge_test.py | 92 | def test_merge_diff_old_snapshot_read(self): | CODE |
| LOW | test/t/merge_test.py | 128 | def test_merge_diff_old_snapshot_index_read(self): | CODE |
| LOW | test/t/merge_test.py | 166 | def test_merge_diff_old_snapshot_point_read(self): | CODE |
| LOW | test/t/merge_test.py | 205 | def test_split_diff_old_snapshot_read(self): | CODE |
| LOW | test/t/merge_test.py | 293 | def test_split_diff_update_grow(self): | CODE |
| LOW | test/t/merge_test.py | 319 | def test_non_concurrent_merge(self): | CODE |
| LOW | test/t/merge_test.py | 341 | def test_merge_free_extent_concurrent_checkpoint(self): | CODE |
| LOW⚡ | test/t/merge_test.py | 404 | def test_concurrent_checkpoint_begin(self): | CODE |
| LOW⚡ | test/t/merge_test.py | 407 | def test_concurrent_checkpoint_middle(self): | CODE |
| LOW⚡ | test/t/merge_test.py | 410 | def test_concurrent_checkpoint_end(self): | CODE |
| LOW⚡ | test/t/merge_test.py | 413 | def concurrent_checkpoint_base(self, delete_offset, bp_value, | CODE |
| LOW | test/t/rewind_time_test.py | 29 | def test_rewind_oriole_shutdown(self): | CODE |
| LOW | test/t/rewind_time_test.py | 70 | def test_rewind_oriole_restart(self): | CODE |
| LOW | test/t/move_database_test.py | 48 | def create_and_clear_directory(base_path, dir_name): | CODE |
| LOW | test/t/move_database_test.py | 241 | def test_move_from_user_ts_full_database(self): | CODE |
| LOW | test/t/move_database_test.py | 259 | def test_move_from_default_ts_full_database(self): | CODE |
| LOW | test/t/move_database_test.py | 278 | def test_move_from_default_ts_only_indexes(self): | CODE |
| LOW | test/t/move_database_test.py | 302 | def test_move_from_default_ts_only_tables(self): | CODE |
| LOW | test/t/move_database_test.py | 326 | def test_move_from_default_ts_some_relations(self): | CODE |
| LOW | test/t/move_database_test.py | 372 | def test_replication_database_move(self): | CODE |
| LOW | test/t/move_database_test.py | 519 | def test_replication_of_moving_database_after_restart(self): | CODE |
| LOW | test/t/move_database_test.py | 665 | def test_replication_of_moving_database_evicted_relation(self): | CODE |
| LOW | test/t/recovery_opclass_test.py | 14 | def test_simple_sql_cmp_function(self): | CODE |
| LOW | test/t/recovery_opclass_test.py | 64 | def test_deep_sql_cmp_function(self): | STRING |
| 336 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| HIGH | test/t/transaction_test.py | 89 | and tripsthe Assert(lo >= 0 && lo <= commandIndex) in | CODE |
| HIGH | test/t/s3_inherits_test.py | 74 | alter table o_test_3 alter a set not null; | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 105 | alter table o_test_2 add column a2 int constraint nn not null; | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 106 | alter table o_test_3 alter column a set not null; | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 107 | alter table o_test_1 alter column a drop not null; | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 108 | alter table o_test_1 alter column a set not null; | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 109 | alter table o_test_3 alter column a2 set not null; | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 110 | alter table o_test_2 alter column a2 drop not null; | CODE |
| HIGH | test/t/s3_inherits_test.py | 140 | create table o_test_2 (check (a = 1 or a = null)) inherits(o_test_1)USING orioledb; | CODE |
| HIGH | test/t/s3_inherits_test.py | 143 | insert into o_test_2 values(null); | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 347 | alter table o_test_1 add constraint c1 check (a is not null); | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 352 | alter table o_test_1 add check (a is not null); | CODE |
| HIGH⚡ | test/t/s3_inherits_test.py | 354 | alter table o_test_1 add constraint c1 check (a is not null); | CODE |
| HIGH | test/t/replication_test.py | 932 | COLLATE "POSIX" USING f1::text || f2; | CODE |
| HIGH | test/t/replication_test.py | 955 | COLLATE "POSIX" USING f1::text || f2; | CODE |
| HIGH | test/t/s3_unlogged_test.py | 120 | CREATE INDEX ind_1 ON o_test_1 ((a || b)); | CODE |
| HIGH | test/t/s3_unlogged_test.py | 130 | CREATE INDEX ind_2 on o_test_3 ((a || b)); | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 40 | SELECT i, '*' || i || repeat('*', mod(i, 5)) FROM generate_series(1, 10) AS i; | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 55 | key | integer | (null) | false | false | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 57 | hash | integer | (null) | true | false | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 98 | SELECT i, '*' || i || repeat('*', mod(i, 5)) FROM generate_series(1, 10) AS i; | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 113 | key | integer | (null) | false | false | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 115 | hash | integer | (null) | true | false | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 143 | SELECT i, '*' || i || repeat('*', mod(i, 5)) FROM generate_series(1, 10) AS i; | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 158 | key | integer | (null) | false | false | CODE |
| HIGH | test/t/pg_dump_restore_test.py | 160 | hash | integer | (null) | true | false | CODE |
| HIGH⚡ | ci/pgbench.py | 205 | " value1 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 206 | " value2 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 207 | " value3 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 208 | " value4 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 220 | " value1 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 221 | " value2 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 222 | " value3 float8 not null,\n" + | CODE |
| HIGH⚡ | ci/pgbench.py | 223 | " value4 float8 not null,\n" + | CODE |
| HIGH | ci/pgbench.py | 358 | '{{"reason": 0, "eventID": null}}', NULL, :emitter, :root_player_id, 'game'); | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/integration/walg_test.py | 521 | # Cleanup | COMMENT |
| LOW | test/t/base_test.py | 741 | "SELECT pid FROM pg_stat_activity WHERE backend_type = 'orioledb background writer';" | COMMENT |
| LOW | test/t/incomplete_split_test.py | 481 | COMMENT | |
| LOW | test/t/rewind_time_test.py | 181 | ## Tests disabled for not to strain CI as they are much similar to neighbouring | COMMENT |
| LOW | test/t/rewind_time_test.py | 201 | # node.safe_psql( | COMMENT |
| LOW | test/t/rewind_time_test.py | 221 | # "INSERT INTO o_test_heap VALUES (%d, %d || 'val'); SAVEPOINT sp3;\n" | COMMENT |
| LOW | test/t/rewind_time_test.py | 241 | # node.append_conf( | COMMENT |
| LOW | test/t/rewind_time_test.py | 261 | # ") USING heap;\n") | COMMENT |
| LOW | test/t/rewind_time_test.py | 281 | # 'postgres', "INSERT INTO o_test_heap\n" | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1081 | # node = self.node | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1101 | # " val text,\n" | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1121 | # for i in range(2500, 2506): | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1141 | # (i, i)) | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1161 | # len = int(a) | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1181 | # node.execute( | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1201 | # node.start() | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1221 | # 'postgres', "INSERT INTO o_test_heap\n" | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1241 | # 'postgres', "INSERT INTO o_test\n" | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1261 | # node.safe_psql('postgres', | COMMENT |
| LOW | test/t/rewind_xid_evict_large_test.py | 1281 | # xidc = int(a) | COMMENT |
| LOW | test/t/replication_test.py | 1101 | def test_recreate_o_table_version_replication(self): | COMMENT |
| LOW | test/t/replication_test.py | 2021 | # oProcData[].vxids[] and writes X.oxid to the | COMMENT |
| LOW | test/t/replication_test.py | 2441 | t_stop.execute("ROLLBACK;") | COMMENT |
| LOW | test/t/replication_test.py | 2841 | # (6) Roll back the txn. wal_rollback writes+flushes the | COMMENT |
| LOW | test/t/functions_test.py | 101 | node.stop() | COMMENT |
| LOW | test/t/amcheck_test.py | 321 | f.write(struct.pack('<Q', 0xDEADBEEF)) | COMMENT |
| LOW | ci/check_output.sh | 101 | if [[ $corefile == *_3.core ]]; then | COMMENT |
| LOW | ci/filter_regression_diff.py | 1 | #!/usr/bin/env python3 | COMMENT |
| LOW | ci/filter_regression_diff.py | 81 | # insert specific error | COMMENT |
| LOW | ci/filter_regression_diff.py | 121 | # generated_stored and generated_virtual run in the same parallel | COMMENT |
| LOW | ci/filter_regression_diff.py | 141 | # SET ROLE / GRANT ("does not exist"), or DROP USER ("cannot be | COMMENT |
| LOW | ci/filter_regression_diff.py | 1001 | # tests RETURNING-flavoured EXPLAIN; the actual returned | COMMENT |
| LOW | ci/pg_upgrade.sh | 1 | #!/bin/bash | COMMENT |
| LOW | ci/pg_upgrade.sh | 201 | -j "$(nproc)" || \ | COMMENT |
| LOW | ci/pg_upgrade.sh | 261 | # 2c. Strip references to test-only loadable libraries from the | COMMENT |
| LOW | ci/pg_upgrade.sh | 321 | # | COMMENT |
| LOW | ci/pg_upgrade.sh | 341 | fi | COMMENT |
| LOW | ci/pg_upgrade.sh | 381 | # orioledb_data/ tree (plus undo logs in orioledb_undo/), which | COMMENT |
| LOW | ci/pg_upgrade.sh | 521 | # 2. INSERT into the expression-index table, then crash (-m immediate) | COMMENT |
| LOW | ci/pg_upgrade.sh | 561 | # Probe the SQL-function index rebuilt by recovery via the proc cache. | COMMENT |
| LOW | include/orioledb.h | 21 | #include "common/int.h" | COMMENT |
| LOW | include/orioledb.h | 321 | #define vacuum_is_relation_owner vacuum_is_permitted_for_relation | COMMENT |
| LOW | include/orioledb.h | 421 | COMMENT | |
| LOW | include/tuple/format.h | 61 | COMMENT | |
| LOW | include/catalog/o_sys_cache.h | 21 | * IDENTIFICATION | COMMENT |
| LOW | include/catalog/sys_trees.h | 21 | COMMENT | |
| LOW | include/utils/antithesis.h | 41 | #pragma GCC diagnostic ignored "-Wdeclaration-after-statement" | COMMENT |
| LOW | include/utils/page_pool.h | 21 | * ucm may not work correctly with lesser page pool size | COMMENT |
| LOW | include/btree/page_state.h | 21 | #define PAGE_STATE_LOCKED_FLAG UINT64CONST(0x0000000000040000) | COMMENT |
| LOW | include/btree/find.h | 101 | bool parentImgDeferred; | COMMENT |
| LOW | include/btree/page_contents.h | 281 | deleted:2, | COMMENT |
| LOW | include/btree/page_contents.h | 301 | #define MAKE_ON_DISK_DOWNLINK(extent) (((uint64)((extent).len) << 48) | (uint64)((extent).off) | DOWNLINK_DISK_BIT) | COMMENT |
| LOW | include/tableam/key_range.h | 21 | #define O_VALUE_BOUND_INCLUSIVE 0x01 | COMMENT |
| LOW | include/lib/o_radixtree.h | 181 | #else | COMMENT |
| LOW | include/lib/o_radixtree.h | 201 | #define RT_FIND RT_MAKE_NAME(find) | COMMENT |
| LOW | include/lib/o_radixtree.h | 221 | /* internal helper functions (no externally visible prototypes) */ | COMMENT |
| LOW | include/lib/o_radixtree.h | 241 | #define RT_COPY_ARRAYS_AND_DELETE RT_MAKE_NAME(copy_arrays_and_delete) | COMMENT |
| LOW | include/lib/o_radixtree.h | 261 | #define RT_REMOVE_CHILD_256 RT_MAKE_NAME(remove_child_256) | COMMENT |
| LOW | include/lib/o_radixtree.h | 661 | * classes increment by 8 (as of PG17 up to 64 bytes), so we just hard | COMMENT |
| LOW | include/lib/o_radixtree.h | 3041 | /* undefine external parameters, so next radix tree can be defined */ | COMMENT |
| 81 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/t/incomplete_split_test.py | 4 | CODE | |
| LOW | test/t/incomplete_split_test.py | 5 | CODE | |
| LOW | test/t/incomplete_split_test.py | 13 | CODE | |
| LOW | test/t/incomplete_split_test.py | 14 | CODE | |
| LOW | test/t/merge_test.py | 4 | CODE | |
| LOW | test/t/merge_test.py | 5 | CODE | |
| LOW | test/t/merge_test.py | 6 | CODE | |
| LOW | test/t/merge_test.py | 8 | CODE | |
| LOW | test/t/merge_test.py | 9 | CODE | |
| LOW | test/t/rewind_time_test.py | 4 | CODE | |
| LOW | test/t/rewind_time_test.py | 5 | CODE | |
| LOW | test/t/rewind_time_test.py | 7 | CODE | |
| LOW | test/t/rewind_time_test.py | 8 | CODE | |
| LOW | test/t/rewind_time_test.py | 11 | CODE | |
| LOW | test/t/rewind_time_test.py | 12 | CODE | |
| LOW | test/t/rewind_time_test.py | 14 | CODE | |
| LOW | test/t/rewind_time_test.py | 15 | CODE | |
| LOW | test/t/move_database_test.py | 5 | CODE | |
| LOW | test/t/move_database_test.py | 11 | CODE | |
| LOW | test/t/recovery_opclass_test.py | 4 | CODE | |
| LOW | test/t/schema_test.py | 1 | CODE | |
| LOW | test/t/checkpoint_eviction_test.py | 10 | CODE | |
| LOW | test/t/checkpoint_eviction_test.py | 11 | CODE | |
| LOW | test/t/page_fit_items_test.py | 4 | CODE | |
| LOW | test/t/page_fit_items_test.py | 5 | CODE | |
| LOW | test/t/page_fit_items_test.py | 18 | CODE | |
| LOW | test/t/temp_local_pool_test.py | 4 | CODE | |
| LOW | test/t/eviction_test.py | 4 | CODE | |
| LOW | test/t/o_tables_test.py | 4 | CODE | |
| LOW | test/t/o_tables_test.py | 5 | CODE | |
| LOW | test/t/o_tables_test.py | 8 | CODE | |
| LOW | test/t/o_tables_test.py | 10 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 4 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 5 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 7 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 8 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 12 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 13 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 14 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 16 | CODE | |
| LOW | test/t/rewind_xid_evict_large_test.py | 17 | CODE | |
| LOW | test/t/logical_test.py | 11 | CODE | |
| LOW | test/t/types_test.py | 4 | CODE | |
| LOW | test/t/transaction_test.py | 5 | CODE | |
| LOW | test/t/checkpointer_test.py | 4 | CODE | |
| LOW | test/t/checkpointer_test.py | 5 | CODE | |
| LOW | test/t/checkpointer_test.py | 6 | CODE | |
| LOW | test/t/checkpointer_test.py | 13 | CODE | |
| LOW | test/t/checkpointer_test.py | 15 | CODE | |
| LOW | test/t/checkpointer_test.py | 16 | CODE | |
| LOW | test/t/checkpoint_concurrent_test.py | 10 | CODE | |
| LOW | test/t/recovery_test.py | 16 | CODE | |
| LOW | test/t/logical_xid_subxacts_test.py | 4 | CODE | |
| LOW | test/t/logical_xid_subxacts_test.py | 7 | CODE | |
| LOW | test/t/vacuum_test.py | 1 | CODE | |
| LOW | test/t/reindex_test.py | 2 | CODE | |
| LOW | test/t/reindex_test.py | 3 | CODE | |
| LOW | test/t/functions_test.py | 6 | CODE | |
| LOW | test/t/functions_test.py | 9 | CODE | |
| LOW | test/t/s3_unlogged_test.py | 2 | CODE | |
| 24 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | orioledb_s3_loader.py | 299 | print(f"An error occurred: {e}") | STRING |
| MEDIUM | orioledb_s3_loader.py | 363 | print("An error occurred. Stopping all downloads.") | STRING |
| MEDIUM | test/integration/pgbackrest_test.py | 505 | def _run_backup(): | CODE |
| LOW | test/integration/pgbackrest_test.py | 508 | except Exception as e: | CODE |
| MEDIUM | test/integration/walg_test.py | 484 | def _run_backup(): | CODE |
| LOW | test/integration/walg_test.py | 487 | except Exception as e: | CODE |
| LOW | test/t/base_test.py | 409 | except Exception: | CODE |
| LOW | test/t/base_test.py | 690 | except Exception as e: | CODE |
| LOW | test/t/base_test.py | 795 | except Exception as e: | CODE |
| MEDIUM | test/t/base_test.py | 673 | def run(self): | CODE |
| LOW | test/t/eviction_bgwriter_test.py | 84 | except Exception: | CODE |
| MEDIUM | test/t/eviction_bgwriter_test.py | 79 | def get_bgwriters(): | CODE |
| LOW | test/t/incomplete_split_test.py | 440 | except Exception: | STRING |
| MEDIUM | test/t/incomplete_split_test.py | 434 | def failedInsertToSplitTable(self, con, insert_from, insert_to, step): | CODE |
| LOW | test/t/merge_test.py | 389 | except Exception as e: | CODE |
| LOW | test/t/move_database_test.py | 31 | except Exception as e: | CODE |
| LOW | test/t/file_operations_test.py | 36 | except Exception as e: | CODE |
| LOW | test/t/file_operations_test.py | 51 | except Exception: | CODE |
| LOW | test/t/file_operations_test.py | 105 | except Exception: | STRING |
| MEDIUM | test/t/page_fit_items_test.py | 103 | def recreate_node(self): | CODE |
| LOW | test/t/page_fit_items_test.py | 107 | except Exception: | CODE |
| LOW | test/t/temp_local_pool_test.py | 412 | except Exception: | STRING |
| LOW | test/t/temp_local_pool_test.py | 466 | except Exception: | STRING |
| LOW | test/t/transaction_test.py | 72 | except Exception: | STRING |
| LOW | test/t/transaction_test.py | 163 | except Exception: | STRING |
| LOW⚡ | test/t/transaction_test.py | 236 | except Exception: | STRING |
| LOW⚡ | test/t/transaction_test.py | 240 | except Exception: | STRING |
| LOW⚡ | test/t/transaction_test.py | 341 | except Exception: | STRING |
| LOW⚡ | test/t/transaction_test.py | 345 | except Exception: | STRING |
| LOW | test/t/recovery_test.py | 2432 | except Exception: | STRING |
| LOW | test/t/recovery_test.py | 2435 | except Exception: | STRING |
| LOW | test/t/recovery_test.py | 2448 | except Exception: | STRING |
| LOW | test/t/recovery_test.py | 2454 | except Exception: | STRING |
| LOW | test/t/fuzzy_checkpoint_test.py | 79 | except Exception as e: # noqa: BLE001 | CODE |
| LOW | test/t/fuzzy_checkpoint_test.py | 163 | except Exception as e: # noqa: BLE001 | CODE |
| LOW | test/t/fuzzy_checkpoint_test.py | 297 | except Exception as e: # noqa: BLE001 | CODE |
| LOW | test/t/fuzzy_checkpoint_test.py | 422 | except Exception as e: # noqa: BLE001 | CODE |
| MEDIUM | test/t/fuzzy_checkpoint_test.py | 76 | def _do_drop(): | CODE |
| MEDIUM | test/t/fuzzy_checkpoint_test.py | 160 | def _do_ckpt(): | CODE |
| MEDIUM | test/t/fuzzy_checkpoint_test.py | 294 | def _do_ckpt(): | CODE |
| MEDIUM | test/t/fuzzy_checkpoint_test.py | 419 | def _do_ckpt(): | CODE |
| LOW | test/t/replication_test.py | 1185 | except Exception as e: | CODE |
| LOW⚡ | test/t/replication_test.py | 2501 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2505 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2509 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2948 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2953 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2959 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2974 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2976 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2980 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2985 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2990 | except Exception: | STRING |
| LOW⚡ | test/t/replication_test.py | 2994 | except Exception: | STRING |
| LOW | test/t/replication_test.py | 1239 | except Exception: | STRING |
| LOW | test/t/replication_test.py | 1712 | except Exception: | STRING |
| LOW | test/t/replication_test.py | 1750 | except Exception: | STRING |
| LOW | test/t/replication_test.py | 1863 | except Exception: | STRING |
| LOW | test/t/replication_test.py | 1931 | except Exception: | STRING |
| LOW | test/t/replication_test.py | 2089 | except Exception: | STRING |
| 23 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | orioledb_s3_loader.py | 163 | CODE | |
| LOW | orioledb_s3_loader.py | 257 | CODE | |
| LOW | orioledb_s3_loader.py | 406 | CODE | |
| LOW | typedefs_gen.py | 41 | CODE | |
| LOW | test/t/indices_build_test.py | 418 | CODE | |
| LOW | test/t/indices_build_test.py | 657 | CODE | |
| LOW | test/t/page_fit_items_test.py | 119 | CODE | |
| LOW | test/t/s3_base_test.py | 92 | CODE | |
| LOW | test/t/logical_test.py | 622 | CODE | |
| LOW | test/t/logical_test.py | 709 | CODE | |
| LOW | test/t/logical_test.py | 1750 | CODE | |
| LOW | test/t/logical_test.py | 1856 | CODE | |
| LOW | test/t/logical_test.py | 2063 | CODE | |
| LOW | test/t/logical_test.py | 2147 | CODE | |
| LOW | test/t/logical_test.py | 2421 | CODE | |
| LOW | test/t/logical_test.py | 2565 | CODE | |
| LOW | test/t/checkpointer_test.py | 102 | CODE | |
| LOW | test/t/checkpoint_concurrent_test.py | 719 | CODE | |
| LOW | test/t/recovery_test.py | 2361 | CODE | |
| LOW | test/t/recovery_test.py | 2404 | CODE | |
| LOW | test/t/replication_test.py | 364 | CODE | |
| LOW | test/t/replication_test.py | 450 | CODE | |
| LOW | test/t/replication_test.py | 822 | CODE | |
| LOW | test/t/replication_test.py | 865 | CODE | |
| LOW | test/t/replication_test.py | 1566 | CODE | |
| LOW | test/t/replication_test.py | 1762 | CODE | |
| LOW | test/t/replication_test.py | 2512 | CODE | |
| LOW | test/t/replication_test.py | 2712 | CODE | |
| LOW | test/t/files_test.py | 163 | CODE | |
| LOW | test/t/files_test.py | 760 | CODE | |
| LOW | test/t/checkpoint_split_base_test.py | 11 | CODE | |
| LOW | test/t/s3_test.py | 97 | CODE | |
| LOW | test/t/amcheck_test.py | 231 | CODE | |
| LOW | test/t/unlogged_test.py | 64 | CODE | |
| LOW | ci/filter_isolation_diff.py | 64 | CODE | |
| LOW | ci/filter_regression_diff.py | 173 | CODE | |
| LOW | ci/filter_regression_diff.py | 187 | CODE | |
| LOW | ci/filter_regression_diff.py | 362 | CODE | |
| LOW | ci/filter_regression_diff.py | 724 | CODE | |
| LOW | ci/filter_regression_diff.py | 741 | CODE | |
| LOW | ci/dump_stuck_pages.py | 128 | CODE | |
| LOW | ci/pgbench.py | 466 | CODE | |
| LOW | ci/pgbench.py | 562 | CODE | |
| LOW | ci/pgbench.py | 803 | CODE | |
| LOW | perf/undo_page_modes_perf.py | 243 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| HIGH | test/t/checkpoint_eviction_test.py | 0 | create extension if not exists orioledb; create table if not exists o_test ( key serial not null, val int not null, prim | STRING |
| HIGH | test/t/eviction_test.py | 0 | create extension if not exists orioledb; create table if not exists o_test ( key serial not null, val int not null, prim | STRING |
| HIGH | test/t/files_test.py | 0 | create extension if not exists orioledb; create table if not exists o_test ( key serial not null, val int not null, prim | STRING |
| HIGH | test/t/s3_inherits_test.py | 0 | orioledb.s3_mode = true orioledb.s3_host = '{self.host}:{self.port}/{self.bucket_name}' orioledb.s3_region = '{self.regi | STRING |
| HIGH | test/t/s3_unlogged_test.py | 0 | orioledb.s3_mode = true orioledb.s3_host = '{self.host}:{self.port}/{self.bucket_name}' orioledb.s3_region = '{self.regi | STRING |
| HIGH | test/t/s3_test.py | 0 | orioledb.s3_mode = true orioledb.s3_host = '{self.host}:{self.port}/{self.bucket_name}' orioledb.s3_region = '{self.regi | STRING |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | check_patchset_version.py | 31 | # Check if provided version is numeric (not a hash) | COMMENT |
| LOW | check_patchset_version.py | 34 | # Check if provided version is part of `git describe --tags` | COMMENT |
| LOW | test/t/eviction_test.py | 715 | # Check if "not loaded" appears anywhere in the output | STRING |
| LOW | ci/docker_matrix.sh | 234 | # Check if the script is run from the correct directory | COMMENT |
| LOW | ci/docker_matrix.sh | 237 | # Check if Docker is installed | COMMENT |
| LOW | ci/filter_regression_diff.py | 340 | # Check if two condition strings are equal up to commutativity of operands | COMMENT |
| LOW | ci/local_docker_matrix.sh | 41 | # Check if the directory exists and contains a git repository | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | test/t/base_test.py | 445 | # Flush just the test-harness-written config files to the block | COMMENT |
| MEDIUM | test/t/fuzzy_checkpoint_test.py | 412 | # the DDL we are holding parked -- a test-harness artifact, not | COMMENT |
| MEDIUM | ci/check_output.sh | 22 | # fresh residuals to print even if the test harness only kept the | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | docker/init/docker-entrypoint.sh | 47 | # Create the transaction log directory before initdb is run so the directory is owned by the correct user | COMMENT |
| MEDIUM | test/t/base_test.py | 115 | # Create the log-writes DM target. | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM⚡ | ci/pg_upgrade.sh | 269 | # --check aborts. They are pure PG-core test scaffolding, unrelated | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/t/rewrite_test.py | 5 | # TODO: Add test with ALTER/ADD COLUMN that rewrites during recovery or replication | COMMENT |
| LOW | test/t/rewrite_test.py | 6 | # TODO: Add test with ALTER/ADD COLUMN that rewrites toast tree | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | test/t/replication_test.py | 1385 | # Step 2: insert batch 2 after checkpoint | STRING |
| LOW⚡ | test/t/replication_test.py | 1392 | # Step 3: rebuild primary key | STRING |
| LOW⚡ | test/t/replication_test.py | 1429 | # Step 5: crash replica without checkpoint | STRING |
| LOW⚡ | test/t/replication_test.py | 1434 | # Step 6: verify all data after recovery | STRING |
| LOW | test/t/replication_test.py | 1358 | # Step 1: checkpoint on both sides | STRING |
| LOW | test/t/replication_test.py | 1403 | # Step 4: replica catches up, then crash | STRING |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | test/t/replication_test.py | 1385 | # Step 2: insert batch 2 after checkpoint | STRING |
| LOW⚡ | test/t/replication_test.py | 1392 | # Step 3: rebuild primary key | STRING |
| LOW⚡ | test/t/replication_test.py | 1429 | # Step 5: crash replica without checkpoint | STRING |
| LOW⚡ | test/t/replication_test.py | 1434 | # Step 6: verify all data after recovery | STRING |
| LOW | test/t/replication_test.py | 1358 | # Step 1: checkpoint on both sides | STRING |
| LOW | test/t/replication_test.py | 1403 | # Step 4: replica catches up, then crash | STRING |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | orioledb_s3_loader.py | 334 | CODE |