Skip to content

Conversation

Mytherin
Copy link
Collaborator

This PR adds a new fuzzer - the FuzzyDuck fuzzer - to the sqlsmith extension. This fuzzer uses our own internal statement to string conversion code to generate random SELECT statements (to be expanded in the future to different statement types). The generation is completely random with no specific targeting or learning, similar to SQLSmith. The advantage of this over SQLSmith is that by using our own statement infrastructure we can support many more types of statements and expressions, including things like window functions, different join types, lambda functions, etc.

Usage of the fuzzer is similar to SQLSmith:

CALL fuzzyduck(max_queries=1000, verbose_output=true, log='queries.out', complete_log='queries.complete.out');

@Mytherin Mytherin merged commit b5b6ef2 into duckdb:master May 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

1 participant