--
-- Copyright 2020 The Android Open Source Project
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     https://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

select ts, dur, process.pid as pid, display_frame_token, surface_frame_token, layer_name
from expected_frame_timeline_slice
join process_track on process_track.upid = expected_frame_timeline_slice.upid
join process on process_track.upid = process.upid
where process_track.name = 'Expected Timeline'
order by ts

--
-- Copyright 2020 The Android Open Source Project
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     https://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

select ts, dur, process.pid as pid, display_frame_token, surface_frame_token, layer_name
from
  (select t.*, process_track.name as track_name from
    process_track left join expected_frame_timeline_slice t
    on process_track.id = t.track_id) s
join process using(upid)
where s.track_name = 'Expected Timeline'
order by ts

Make expected timeline test case use the same sql joins as actual
Make expected timeline test case use the same sql joins as actual

To be in sync, make the test cases similar so that any errors in one
test will be most likely to occur in the other as well.

Test: diff_test_trace_processor
Change-Id: Idd55b645fb6894e0d834dba310075820459cb25a
