Tracking: Using sqlsmith to support sql fuzzy testing

[b41sh]

SQLSmith is a random SQL query generator, we use it to do random tests to find potential bugs

Query

• Generate a simple select query
• Generate Filter selection
• Generate With clause (CTE)
• Generate Group By clause @TCeason
• Generate Order By clause @TCeason
• Generate Having clause
• Generate Limit clause @TCeason
• Generate Type casting
• Generate Scalar functions @b41sh
• Generate Aggregate functions @TCeason
• Generate Window functions @TCeason
• Generate Lambda functions
• Generate Table functions @TCeason
• Generate Exprs
• Generate SetOperator(UNION/EXCEPT/INTERSECT)
• Generate Values clause
• Generate SubQuery
• Generate Join @b41sh
• Generate Nested data types(Array, Map, Tuple, JSON) @b41sh
• Generate Select from the stage
• Generate Hint Set var
• Generate Complex SubQuery
• Generate pivot and unpivot

DDL

• Generate Create/Drop table
• Generate Alter table #13050
• Generate Create/Alter/Drop view #12842 @TCeason
• Generate Create Table like another table
• Generate Create/Alter UDF
• Generate Create/Alter Agg index
• Generate Create/Alter Virtual column
• Generate computed columns
• Generate default value expression
• Support native format

DML

• Generate Insert values
• Generate Update values
• Generate Delete
• Generate Copy
• Generate Merge into
• Generate Insert values with query
• Generate Insert values with streaming
• Generate Replace into

Reducer

• Reducer to simplify SQL @TCeason
• Reducer nested expression to simple expression