Test Results Map ================ Tables describing the various `*.out` files and the versions of PostgreSQL or ClickHouse they cover. * Postgres coverage run using latest ClickHouse release. * ClickHouse coverage run from PostgreSQL 19. aggregates.sql -------------- Postgres | File ----------|----------------- 16-19 | aggregates.out 14-15 | aggregates_1.out ClickHouse | File ------------|----------------- 24.8+ | aggregates.out 24.3 | aggregates_3.out 23.8 | aggregates_4.out 23.3 | aggregates_5.out array_functions.sql ------------------- Postgres | File ----------|---------------------- 16-19 | array_functions.out 14-15 | array_functions_1.out ClickHouse | File ------------|---------------------- 24.3+ | array_functions.out 23 | array_functions_2.out binary.sql ---------- Postgres | File ----------|------------- 14-19 | binary.out ClickHouse | File ------------|-------------- 26+ | binary.out < 26 | binary_1.out binary_inserts.sql ------------------ Postgres | File ----------|---------------------- 18-19 | binary_inserts.out 14-17 | binary_inserts_1.out ClickHouse | File ------------|-------------------- 23+ | binary_inserts.out binary_nullable_json.sql ------------------------ Postgres | File ----------|-------------------------- 14-19 | binary_nullable_json.out ClickHouse | File ------------|---------------------------- 25.8+ | binary_nullable_json.out 25.3 | binary_nullable_json_1.out 23.3-25.2 | binary_nullable_json_2.out binary_queries.sql ------------------ Postgres | File ----------|---------------------- 19 | binary_queries.out 18 | binary_queries_1.out 17 | binary_queries_2.out 16 | binary_queries_3.out 14-15 | binary_queries_4.out ClickHouse | File ------------|---------------------- 26 | binary_queries.out 23.8-25 | binary_queries_5.out 23.3 | binary_queries_6.out deparse_checks.sql ------------------ Postgres | File ----------|---------------------- 18-19 | deparse_checks.out 14-17 | deparse_checks_1.out ClickHouse | File ------------|-------------------- 23+ | deparse_checks.out docs_offload_partition.sql -------------------------- Postgres | File ----------|------------------------------ 18-19 | docs_offload_partition.out 17 | docs_offload_partition_1.out 14-16 | docs_offload_partition_2.out ClickHouse | File ------------|------------------------------ 23+ | docs_offload_partition.out engines.sql ----------- Postgres | File ----------|--------------- 18-19 | engines.out 14-17 | engines_1.out ClickHouse | File ------------|------------- 23+ | engines.out functions.sql ------------- Postgres | File ----------|--------------- 19 | functions.out 18 | functions_1.out 15-17 | functions_2.out 14 | functions_3.out ClickHouse | File ------------|----------------- 26.3+ | functions.out 25.8 | functions_5.out 25.3 | functions_6.out 24.8 | functions_7.out 24.3 | functions_8.out 23.8 | functions_9.out 23.3 | functions_0.out hashing.sql ----------- Postgres | File ----------|--------------- 19 | hashing.out 14-18 | hashing_1.out http.sql -------- Postgres | File ----------|------------ 19 | http.out 18 | http_1.out 17 | http_2.out 16 | http_3.out 14-15 | http_4.out ClickHouse | File ------------|------------ 23.8+ | http.out 23.3 | http_5.out http_inserts.sql ---------------- Postgres | File ----------|-------------------- 18-19 | http_inserts.out 14-17 | http_inserts_1.out ClickHouse | File ------------|-------------------- 24+ | http_inserts.out 23 | http_inserts_2.out ilike_regex.sql --------------- Postgres | File ----------|----------------- 14-19 | ilike_regex.out ClickHouse | File ------------|------------------- 25+ | ilike_regex.out 23-24 | ilike_regex_1.out import_schema.sql ----------------- Postgres | File ----------|--------------------- 18-19 | import_schema.out 14-17 | import_schema_1.out ClickHouse | File ------------|--------------------- 26.7+ | import_schema.out 23.3-26.6 | import_schema_2.out interval.sql ------------ ClickHouse | File ------------|-------------------- 23.5+ | interval.out 23.3 | interval_1.out interval_int.sql ---------------- ClickHouse | File ------------|-------------------- 23.5+ | interval_int.out 23.3 | interval_int_1.out json.sql -------- Postgres | File ----------|------------ 14-19 | json.out ClickHouse | File ------------|------------ 25.8+ | json.out 25.3 | json_1.out 23.3-25.2 | json_2.out json_coldef.sql ---------------- Postgres | File ----------|----------------- 14-19 | json_coldef.out ClickHouse | File ------------|------------------- 25.3+ | json_coldef.out 23.3-25.2 | json_coldef_1.out nested.sql ----------- Postgres | File ----------|------------ 14-19 | nested.out ClickHouse | File ------------|-------------- 26.8+ | nested.out 25.1-26.3 | nested_1.out 23+ | nested_2.out param.sql --------- Postgres | File ----------|------------- 19 | param.out 17-18 | param_1.out 14-16 | param_2.out ClickHouse | File ------------|----------- 23+ | param.out regex.sql --------- Postgres | File ----------|----------- 14-19 | regex.out ClickHouse | File ------------|------------- 25+ | regex.out 23-24 | regex_1.out subplan_pushdown.sql -------------------- Postgres | File ----------|------------------------ 19 | subplan_pushdown.out 17-18 | subplan_pushdown_1.out 16 | subplan_pushdown_2.out 14-15 | subplan_pushdown_3.out ClickHouse | File ------------|-------------------------------------- 25.8+ | subplan_pushdown.out (per Postgres, above) < 25.8 | subplan_pushdown_4.out (test aborts) subquery_eq.sql ---------------- Postgres | File ----------|------------------- 16-19 | subquery_eq.out 14-15 | subquery_eq_1.out ClickHouse | File ------------|---------------------------------- 25.8+ | subquery_eq.out (per Postgres, above) < 25.8 | subquery_eq_2.out (test aborts) subquery_pushdown.sql --------------------- Postgres | File ----------|------------------------- 18-19 | subquery_pushdown.out 14-17 | subquery_pushdown_1.out ClickHouse | File ------------|----------------------- 23+ | subquery_pushdown.out timezone.sql ------------ Postgres | File ----------|-------------- 14-19 | timezone.out ClickHouse | File ------------|---------------- 25.8+ | timezone.out 23-25.7 | timezone_1.out where_sub.sql ------------- Postgres | File ----------|----------------- 18-19 | where_sub.out 14-17 | where_sub_1.out ClickHouse | File ------------|----------------- 23+ | where_sub.out window_functions.sql -------------------- Postgres | File ----------|------------------------ 14-19 | window_functions.out ClickHouse | File ------------|---------------------------- 26+ | window_functions.out 25.4-25.8 | window_functions_1.out 24.8-25.3 | window_functions_2.out 24.3 | window_functions_3.out 23.8 | window_functions_4.out 23.3 | window_functions_5.out re2_functions.sql ----------------- Postgres | pg_re2 | File ----------|-----------|--------------------- 14-19 | installed | re2_functions.out 14-19 | absent | re2_functions_1.out