Lines Matching full:tests

180 SELECT  tests.test_idx,
181         tests.job_idx,
182         tests.test,
183         tests.subdir,
184         tests.kernel_idx,
185         tests.status,
186         tests.reason,
187         tests.machine_idx,
188         tests.started_time AS test_started_time,
189         tests.finished_time AS test_finished_time,
203 FROM tests
204 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
206 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
207 INNER JOIN status ON status.status_idx = tests.status;
211 SELECT  tests.test_idx,
212         tests.job_idx,
213         tests.test,
214         tests.subdir,
215         tests.kernel_idx,
216         tests.status,
217         tests.reason,
218         tests.machine_idx,
219         tests.started_time AS test_started_time,
220         tests.finished_time AS test_finished_time,
237 FROM tests
238 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
240 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
241 INNER JOIN status ON status.status_idx = tests.status
242 INNER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;
246 SELECT  tests.test_idx,
247         tests.job_idx,
248         tests.test AS test_name,
249         tests.subdir,
250         tests.kernel_idx,
251         tests.status AS status_idx,
252         tests.reason,
253         tests.machine_idx,
254         tests.started_time AS test_started_time,
255         tests.finished_time AS test_finished_time,
269 FROM tests
270 LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
272 LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
273 LEFT OUTER JOIN status ON status.status_idx = tests.status;
277 SELECT  tests.test_idx,
278         tests.job_idx,
279         tests.test AS test_name,
280         tests.subdir,
281         tests.kernel_idx,
282         tests.status AS status_idx,
283         tests.reason,
284         tests.machine_idx,
285         tests.started_time AS test_started_time,
286         tests.finished_time AS test_finished_time,
301 FROM tests
302 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
304 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
305 INNER JOIN status ON status.status_idx = tests.status;
309 SELECT  tests.test_idx,
310         tests.job_idx,
311         tests.test AS test_name,
312         tests.subdir,
313         tests.kernel_idx,
314         tests.status AS status_idx,
315         tests.reason,
316         tests.machine_idx,
317         tests.started_time AS test_started_time,
318         tests.finished_time AS test_finished_time,
335 FROM tests
336 LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
338 LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
339 LEFT OUTER JOIN status ON status.status_idx = tests.status
340 LEFT OUTER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;
358         'tests',