2 ms·
I admit it's not the best but I do almost like you. Graphs are definitely helpful. I also have a few 'test' queries that insert there results into a 'test_resu
by toto444 4y ago
I admit it's not the best but I do almost like you. Graphs are definitely helpful.
I also have a few 'test' queries that insert there results into a 'test_results' table. Most of the queries check the cardinality of the table since to me wrong cardinality is where the biggest errors come from. I do something like :
insert into test_table
select
case when count(*) = count(distinct users) then 'pass'
else 'fail'
end as result,
'test_cardinality_temporary_table_a' as test_name
from temporary_table_a