Lines Matching full:where
57 # sqlite> select * from samples_view where id < 10;
59 # sqlite> select * from samples_view where id < 10;
102 printerr("where: columns 'all' or 'branches'");
348 '(SELECT host_or_guest FROM machines_view WHERE id = machine_id) AS host_or_guest,'
358 '(SELECT short_name FROM dsos WHERE id=dso_id) AS dso,'
369 '(SELECT host_or_guest FROM machines_view WHERE id = machine_id) AS host_or_guest,'
378 '(SELECT comm FROM comms WHERE id = comm_id) AS command,'
380 '(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
381 '(SELECT tid FROM threads WHERE id = thread_id) AS tid'
390 '(SELECT name FROM symbols WHERE id = c.symbol_id) AS symbol,'
391 '(SELECT dso_id FROM symbols WHERE id = c.symbol_id) AS dso_id,'
392 '(SELECT dso FROM symbols_view WHERE id = c.symbol_id) AS dso_short_name,'
396 '(SELECT name FROM symbols WHERE id = p.symbol_id) AS parent_symbol,'
397 '(SELECT dso_id FROM symbols WHERE id = p.symbol_id) AS parent_dso_id,'
398 '(SELECT dso FROM symbols_view WHERE id = p.symbol_id) AS parent_dso_short_name'
405 '(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
406 '(SELECT tid FROM threads WHERE id = thread_id) AS tid,'
407 '(SELECT comm FROM comms WHERE id = comm_id) AS command,'
411 '(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,'
431 '(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
432 '(SELECT tid FROM threads WHERE id = thread_id) AS tid,'
433 '(SELECT comm FROM comms WHERE id = comm_id) AS command,'
434 '(SELECT name FROM selected_events WHERE id = evsel_id) AS event,'
436 '(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,'
438 '(SELECT short_name FROM dsos WHERE id = dso_id) AS dso_short_name,'
440 '(SELECT name FROM symbols WHERE id = to_symbol_id) AS to_symbol,'
442 '(SELECT short_name FROM dsos WHERE id = to_dso_id) AS to_dso_short_name,'
443 '(SELECT name FROM branch_types WHERE id = branch_type) AS branch_type_name,'
524 …'CASE WHEN selected_events.name=\'cbr\' THEN (SELECT cbr FROM cbr WHERE cbr.id = samples.id) ELSE …
525 …'CASE WHEN selected_events.name=\'cbr\' THEN (SELECT mhz FROM cbr WHERE cbr.id = samples.id) ELSE …
526 …'CASE WHEN selected_events.name=\'cbr\' THEN (SELECT percent FROM cbr WHERE cbr.id = samples.id) E…
527 …vents.name=\'mwait\' THEN (SELECT ' + emit_to_hex('hints') + ' FROM mwait WHERE mwait.id = samples…
528 ….name=\'mwait\' THEN (SELECT ' + emit_to_hex('extensions') + ' FROM mwait WHERE mwait.id = samples…
529 …'CASE WHEN selected_events.name=\'pwre\' THEN (SELECT cstate FROM pwre WHERE pwre.id = samples.id)…
530 …'CASE WHEN selected_events.name=\'pwre\' THEN (SELECT subcstate FROM pwre WHERE pwre.id = samples.…
531 …'CASE WHEN selected_events.name=\'pwre\' THEN (SELECT hw FROM pwre WHERE pwre.id = samples.id) ELS…
532 …'CASE WHEN selected_events.name=\'exstop\' THEN (SELECT exact_ip FROM exstop WHERE exstop.id = sam…
533 …'CASE WHEN selected_events.name=\'pwrx\' THEN (SELECT deepest_cstate FROM pwrx WHERE pwrx.id = sam…
534 …'CASE WHEN selected_events.name=\'pwrx\' THEN (SELECT last_cstate FROM pwrx WHERE pwrx.id = sample…
542 ' FROM pwrx WHERE pwrx.id = samples.id) ELSE "" END AS wake_reason'
545 ' WHERE selected_events.name IN (\'cbr\',\'mwait\',\'exstop\',\'pwre\',\'pwrx\')')
649 …do_query(query, 'UPDATE comms SET has_calls = 1 WHERE comms.id IN (SELECT DISTINCT comm_id FROM ca…