SQL Testing

Apr 6, 2023

• SQL Fiddle

• Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel

• Try to construct data that could check for the following potential errors:

• Incorrect output schema

• Output may be missing rows from the correct answer (false negatives)

• Output may contain incorrect rows (false positives)

• Output may have the wrong number of duplicates.

• Output may not be ordered properly.