Re:Ask HN: How do you test SQL?
by RobinL on Wednesday February 01, 2023 @06:14AM
(#34609045)
The tests are being run against small test datasets of 10s of rows rather than the real data that test whether the behaviour of transforms/joins etc. is as expected. You're right, this approach wouldn't be sensible if the tests have to use large production tables
[ Parent
| on HN ]
Re:Ask HN: How do you test SQL?
by mritchie712 on Wednesday February 01, 2023 @06:51AM
(#34609293)
How do you get the small datasets? Selecting a random sample from the source?