MSEDGE binary issue

mail@pastecode.io avatar
unknown
sql
a year ago
5.4 kB
2
Indexable
Never
      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