1CREATE TEMP TABLE FUNCTION TEST_COVERAGE_VIEW () AS
2  SELECT
3    -- Target,
4    -- BuildNum,
5    CoverageMethods.Method AS MethodName,
6    CoverageMethods.Package AS Package,
7    CoverageMethods.Class AS ClassName,
8
9    -- count % coverage
10    1 - (SUM(IFNULL(
11      CoverageResults.CoverageData.instructions_missed, 0
12    )) / SUM(CoverageResults.CoverageData.instructions_total)) AS Coverage
13    -- 1-(missed/total)
14
15  FROM `/span/global/blackbox-eng-jobs:database`.TestSuiteResults.TestSuiteResultsByBranchTarget
16      JOIN `/span/global/blackbox-eng-jobs:database`.CoverageResults USING (TestSuiteResultsId)
17          HASH JOIN `/span/global/blackbox-eng-jobs:database`.CoverageMethods USING (CoverageResultsId)
18  WHERE HasCoverage
19      AND BuildNum = build_num
20      AND Branch = "git_udc-car-dev"
21      AND Target = "cf_x86_64_auto-userdebug_coverage"
22      AND TestSuite = "coverage/complete_car_coverage"
23  GROUP BY MethodName, Package, ClassName, TestSuite
24;
25
26SELECT MethodName FROM TEST_COVERAGE_VIEW WHERE Coverage = 0 AND Package LIKE "android.car%" ORDER BY MethodName;
27