Lines Matching full:tests

12 ALTER TABLE tests ADD COLUMN started_time datetime NULL;
16 ALTER TABLE tests DROP started_time;
21 SELECT  tests.test_idx,
22         tests.job_idx,
23         tests.test,
24         tests.subdir,
25         tests.kernel_idx,
26         tests.status,
27         tests.reason,
28         tests.machine_idx,
29         tests.started_time AS test_started_time,
30         tests.finished_time AS test_finished_time,
44 FROM tests
45 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
47 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
48 INNER JOIN status ON status.status_idx = tests.status;
52 SELECT  tests.test_idx,
53         tests.job_idx,
54         tests.test,
55         tests.subdir,
56         tests.kernel_idx,
57         tests.status,
58         tests.reason,
59         tests.machine_idx,
60         tests.started_time AS test_started_time,
61         tests.finished_time AS test_finished_time,
78 FROM tests
79 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
81 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
82 INNER JOIN status ON status.status_idx = tests.status
83 INNER JOIN iteration_result ON iteration_result.test_idx = tests.kernel_idx;
88 SELECT  tests.test_idx,
89         tests.job_idx,
90         tests.test,
91         tests.subdir,
92         tests.kernel_idx,
93         tests.status,
94         tests.reason,
95         tests.machine_idx,
96         tests.finished_time AS test_finished_time,
110 FROM tests
111 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
113 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
114 INNER JOIN status ON status.status_idx = tests.status;
118 SELECT  tests.test_idx,
119         tests.job_idx,
120         tests.test,
121         tests.subdir,
122         tests.kernel_idx,
123         tests.status,
124         tests.reason,
125         tests.machine_idx,
126         tests.finished_time AS test_finished_time,
143 FROM tests
144 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
146 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
147 INNER JOIN status ON status.status_idx = tests.status
148 INNER JOIN iteration_result ON iteration_result.test_idx = tests.kernel_idx;