pg_duckdb
pg_duckdb copied to clipboard
Add sqlsmith fuzzy test
This adds a test that runs sqlsmith on a sqlsmith_test database that has pg_duckdb extension enabled and any caused crashes will get detected by the logs in the teardown of pg fixture
...
assert (
"was terminated by signal 6" not in logs
), "Postgres crashed! Check the logs above."
assert (
"was terminated by signal 11" not in logs
), "Postgres crashed! Check the logs above."
closes: #222
@JelteF It's been about 3 months since I opened this. Can I have a review when convenient?
Actually, the failing test after i rebased is because SQLSmith detected a crash:
_________________ ERROR at teardown of test_fuzzy_pg_crashing __________________
...
E AssertionError: Postgres crashed! Check the logs above.
E assert 'was terminated by signal 6' not in '2025-08-26 ...\tlimit 78\n'
Sorry for not responding. I've been trying to focus on getting 1.0 out (which has been going less well than intended). I'll get back to this after I've actually done that.