MSEDGE binary issue
unknown
sql
2 years ago
5.4 kB
2
Indexable
DECLARE array_active_window ARRAY <STRING>; DECLARE array_active_window_bucket ARRAY <STRING>; DECLARE array_active_window_bucket_sotimeout ARRAY <STRING>; DECLARE array_active_window_bucket_2 ARRAY <STRING>; DECLARE array_active_window_bucket_sotimeout_2 ARRAY <STRING>; DECLARE array_active_window_bucket_3 ARRAY <STRING>; DECLARE array_active_window_bucket_sotimeout_3 ARRAY <STRING>; DECLARE array_secondary_diagnostic_reasons ARRAY <STRING>; DECLARE array_secondary_diagnostic_reasons_sotimeout ARRAY <STRING>; SET array_active_window = ['internet explorer', 'firefox', 'finder,', 'authorization required', 'authentication required', 'do you want to leave this site?', 'microsoft internet explorer', 'password required' ]; SET array_active_window_bucket = ['something_wrong', 'site_unreachable', 'not_responding', 'chrome_driver', 'firefox_stopped', 'ie_stopped', 'command_line_server' ]; SET array_active_window_bucket_sotimeout = ['SOTIMEOUT-browserstack-something_wrong', 'SOTIMEOUT-customer-site_unreachable', 'SOTIMEOUT-browserstack-not_responding', 'SOTIMEOUT-browserstack-chrome_driver', 'SOTIMEOUT-browserstack-firefox_stopped', 'SOTIMEOUT-browserstack-ie_stopped', 'SOTIMEOUT-browserstack-command_line_server']; SET array_active_window_bucket_2 = ['something_wrong', 'site_unreachable', 'chrome_data_page']; SET array_active_window_bucket_sotimeout_2 = ['SOTIMEOUT-browserstack-something_wrong', 'SOTIMEOUT-customer-site_unreachable', 'SOTIMEOUT-browserstack-chrome_data_page']; SET array_active_window_bucket_3 = ['not_responding', 'chrome_driver', 'firefox_stopped', 'ie_stopped', 'command_line_server']; SET array_active_window_bucket_sotimeout_3 = [ 'SOTIMEOUT-browserstack-not_responding', 'SOTIMEOUT-browserstack-chrome_driver', 'SOTIMEOUT-browserstack-firefox_stopped', 'SOTIMEOUT-browserstack-ie_stopped', 'SOTIMEOUT-browserstack-command_line_server']; SET array_secondary_diagnostic_reasons = ['something_wrong', 'site_unreachable', 'ssl_connect', 'basic-auth-required', 'ntlm-auth-required', 'basic-auth-failed', 'ntlm-auth-failed', 'local-disconnected', 'local-multiple-binary', 'local-user-disconnected']; SET array_secondary_diagnostic_reasons_sotimeout = ['SOTIMEOUT-browserstack-ssl_connect', 'SOTIMEOUT-customer-basic-auth-required', 'SOTIMEOUT-browserstack-basic-auth-required', 'SOTIMEOUT-customer-ntlm-auth-required', 'SOTIMEOUT-browserstack-ntlm-auth-required', 'SOTIMEOUT-browserstack-basic-auth-failed', 'SOTIMEOUT-browserstack-ntlm-auth-failed', 'SOTIMEOUT-browserstack-local-disconnected']; SELECT COUNT(*) as data, JSON_EXTRACT(capabilities, "$.os_version") FROM `automate.automate_test_sessions_partitioned` WHERE _PARTITIONTIME = "2022-12-27" AND (device IS NULL OR device = '') AND real_mobile = 0 AND terminal like '10.1%' AND (LOWER(status) = 'error' OR LOWER(reason) = 'forcibly_marked_as_done' OR (active_window_bucket NOT IN UNNEST(ARRAY_CONCAT(array_active_window_bucket,array_active_window_bucket_sotimeout)) AND EXISTS( SELECT * FROM UNNEST (secondary_diagnostic_reasons) AS reason WHERE LOWER(reason) NOT IN UNNEST(ARRAY_CONCAT(array_secondary_diagnostic_reasons,array_secondary_diagnostic_reasons_sotimeout)) ) AND active_window NOT IN UNNEST(array_active_window) AND implicit_timeout != 1 AND ( LOWER(active_window_bucket) IN UNNEST(ARRAY_CONCAT(array_active_window_bucket_2,array_active_window_bucket_sotimeout_2)) OR EXISTS ( SELECT * FROM UNNEST(secondary_diagnostic_reasons) AS reason WHERE LOWER(reason) IN UNNEST(ARRAY_CONCAT(array_active_window_bucket_2,array_active_window_bucket_sotimeout_2))) OR LOWER(pre_quit_bucket) = 'page load' OR LOWER(bs_bucket) = 'page load' ) AND (inside_bs_network_time > 0)) OR -- PAGE LOAD (LOWER(active_window_bucket) IN UNNEST(ARRAY_CONCAT(array_active_window_bucket_3,array_active_window_bucket_sotimeout_3)) OR EXISTS ( SELECT * FROM UNNEST(secondary_diagnostic_reasons) AS reason WHERE LOWER(reason) IN UNNEST(ARRAY_CONCAT(array_active_window_bucket_3,array_active_window_bucket_sotimeout_3)) ) OR LOWER(pre_quit_bucket) = 'crash' OR LOWER(active_window) IN ('internet explorer', 'firefox', 'ie'))) and active_window = "program manager" group by 2 order by 1 desc
Editor is loading...