test_case_bug_count

Column Type
test_case_id BLOB
test_bug_count

SQL DDL

CREATE VIEW test_case_bug_count AS
select 
tc.test_case_id,
case when bug_count is null then 0
else bug_count
end as test_bug_count
FROM  test_cases tc
LEFT JOIN
test_case_bug_list tbg on tc.test_case_id=tbg.test_case_id
;