test_case_bug_list

Column Type
test_case_id BLOB
bug_list_array
bug_count

SQL DDL

CREATE VIEW test_case_bug_list AS
WITH bug_data AS (
    SELECT test_case_id, json_group_array(json_each.value) AS bug_list_array
    FROM test_cases, json_each(test_cases.bug_list)
    GROUP BY test_case_id
)
SELECT test_case_id, 
       bug_list_array, 
       json_array_length(json(bug_list_array)) AS bug_count
FROM bug_data
;