Lines Matching full:where

198             WHERE aux.test_program_id = tmp_metadatas.test_program_id)
199     WHERE test_program_id IS NOT NULL AND property_name = 'timeout'
206         WHERE aux.test_case_id = tmp_metadatas.test_case_id)
207     WHERE test_case_id IS NOT NULL AND property_name = 'timeout'
216 UPDATE atf_test_cases SET description = '' WHERE description IS NULL;
217 UPDATE atf_test_cases SET required_user = '' WHERE required_user IS NULL;
222             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
223     WHERE test_case_id IS NOT NULL AND property_name = 'description'
228             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
229     WHERE test_case_id IS NOT NULL AND property_name = 'has_cleanup'
234             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
235     WHERE test_case_id IS NOT NULL AND property_name = 'timeout'
240             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
241     WHERE test_case_id IS NOT NULL AND property_name = 'required_memory'
246             WHERE aux.test_case_id = tmp_metadatas.test_case_id)
247     WHERE test_case_id IS NOT NULL AND property_name = 'required_user'
253             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
255     WHERE test_case_id IS NOT NULL AND property_name = 'allowed_architectures'
258                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
264             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
266     WHERE test_case_id IS NOT NULL AND property_name = 'allowed_platforms'
269                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
275             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
277     WHERE test_case_id IS NOT NULL AND property_name = 'required_configs'
280                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
286             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
288     WHERE test_case_id IS NOT NULL AND property_name = 'required_files'
291                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
297             WHERE aux.test_case_id = tmp_metadatas.test_case_id AND
299     WHERE test_case_id IS NOT NULL AND property_name = 'required_programs'
302                    WHERE aux.test_case_id = tmp_metadatas.test_case_id
310             WHERE tmp_metadatas.test_program_id = test_programs.test_program_id
315             WHERE tmp_metadatas.test_case_id = test_cases.test_case_id
323         WHERE s.test_program_id = tmp_metadatas.test_program_id
325     FROM tmp_metadatas WHERE test_program_id IS NOT NULL;
329         WHERE s.test_case_id = tmp_metadatas.test_case_id
331     FROM tmp_metadatas WHERE test_case_id IS NOT NULL;