"""Differential test of ClickHouse date/time functions (toStartOfDay/Month/Hour/Week, toHour, toISOWeek, ...) against Python zoneinfo in zones with DST. Found toStartOfHour giving :30 buckets in Australia/Lord_Howe.
Usage: CLICKHOUSE_BIN=/path/to/clickhouse python3 dt_probe.py SEED
Uses `clickhouse local`; compares many configurations of the same query and prints MISMATCH lines.
"""
"""Differential test of ClickHouse JOIN algorithms (hash, parallel_hash, grace_hash, full_sorting_merge, partial_merge, direct, auto) on NULL / NaN / Tuple / Array / Map / LowCardinality / Decimal keys. Any two algorithms disagreeing prints MISMATCH.
Usage: CLICKHOUSE_BIN=/path/to/clickhouse python3 join_probe.py SEED
Uses `clickhouse local`; compares many configurations of the same query and prints MISMATCH lines.
"""
"""Metamorphic test of ClickHouse MergeTree index analysis: primary key, minmax / bloom_filter / set skip indexes, PREWHERE, the old analyzer and the query condition cache against a full scan, over 14 key types.
Usage: CLICKHOUSE_BIN=/path/to/clickhouse python3 pk_probe.py SEED
Uses `clickhouse local`; compares many configurations of the same query and prints MISMATCH lines.
"""
MCP server (spec 2025-11-25, Streamable HTTP) that turns Alexa+ into a coach for competitive programmers, using live Codeforces and LeetCode data
TypeScript
Office material entry, services details, payment & purchase records management app including website, backend, android/ios application.
TypeScript