pg_duckdb icon indicating copy to clipboard operation
pg_duckdb copied to clipboard

Add sqlsmith fuzzy test

Open 0xgouda opened this issue 6 months ago • 2 comments

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

0xgouda avatar May 31 '25 10:05 0xgouda

@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'

0xgouda avatar Aug 26 '25 09:08 0xgouda

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.

JelteF avatar Aug 27 '25 09:08 JelteF