Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
AssertionError: assert   
    CLIENT_OS_USER_CHECK:            OK.
  - CLIENT_VERSION_CHECK:            OK.
  + CLIENT_VERSION_CHECK:            Unexpected: rdb$get_context('SYSTEM', 'CLIENT_VERSION')=LI-V4.0.5.3091 Firebird 4.0 HQbird, chk_fb_vers=LI-V4.0.5.3091 Firebird 4.0 HQbird
  + LI-V4.0.5.3091 Firebird 4.0 HQbird/tcp (deb10build1)/P17:C
  + LI-V4.0.5.3091 Firebird 4.0 HQbird/tcp (deb10build1)/P17:C

LOG DETAILS:

2024-05-09 00:16:57.299
2024-05-09 00:16:57.304 act = <firebird.qa.plugin.Action object at [hex]>
2024-05-09 00:16:57.308 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-05-09 00:16:57.313
2024-05-09 00:16:57.317 @pytest.mark.version('>=4.0')
2024-05-09 00:16:57.322 def test_1(act: Action, capsys):
2024-05-09 00:16:57.328 os_user = getpass.getuser()
2024-05-09 00:16:57.333 with act.db.connect() as con:
2024-05-09 00:16:57.337 fb_vers = con.info.firebird_version
2024-05-09 00:16:57.342 cur = con.cursor()
2024-05-09 00:16:57.346
2024-05-09 00:16:57.351 test_sql = f"""
2024-05-09 00:16:57.355 select
2024-05-09 00:16:57.360 iif( lower(system_context_client_os_user) = lower(chk_os_user)
2024-05-09 00:16:57.364 ,'OK.'
2024-05-09 00:16:57.369 ,q'#Unexpected: rdb$get_context('SYSTEM', 'CLIENT_OS_USER')=#'
2024-05-09 00:16:57.374 || coalesce(system_context_client_os_user, '[null]')
2024-05-09 00:16:57.378 || ', chk_os_user='
2024-05-09 00:16:57.383 || coalesce(chk_os_user, '[null]')
2024-05-09 00:16:57.387 ) as client_os_user_check
2024-05-09 00:16:57.392 ,
2024-05-09 00:16:57.396 iif( system_context_client_version = chk_fb_vers
2024-05-09 00:16:57.401 ,'OK.'
2024-05-09 00:16:57.405 ,q'#Unexpected: rdb$get_context('SYSTEM', 'CLIENT_VERSION')=#'
2024-05-09 00:16:57.410 || coalesce(system_context_client_version, '[null]')
2024-05-09 00:16:57.416 || ', chk_fb_vers='
2024-05-09 00:16:57.421 || coalesce(chk_fb_vers, '[null]')
2024-05-09 00:16:57.426 ) as client_version_check
2024-05-09 00:16:57.431 from (
2024-05-09 00:16:57.435 select
2024-05-09 00:16:57.442 rdb$get_context('SYSTEM', 'CLIENT_OS_USER') as system_context_client_os_user
2024-05-09 00:16:57.447 ,rdb$get_context('SYSTEM', 'CLIENT_VERSION') as system_context_client_version
2024-05-09 00:16:57.451 ,q'*{os_user}*' as chk_os_user
2024-05-09 00:16:57.456 ,q'*{fb_vers}*' as chk_fb_vers
2024-05-09 00:16:57.460 from rdb$database
2024-05-09 00:16:57.465 );
2024-05-09 00:16:57.469 """
2024-05-09 00:16:57.474
2024-05-09 00:16:57.479 for r in cur.execute(test_sql):
2024-05-09 00:16:57.484 for i,col in enumerate(cur.description):
2024-05-09 00:16:57.489 print((col[0] +':').ljust(32), r[i])
2024-05-09 00:16:57.493
2024-05-09 00:16:57.498 expected_stdout = """
2024-05-09 00:16:57.502 CLIENT_OS_USER_CHECK:            OK.
2024-05-09 00:16:57.509 CLIENT_VERSION_CHECK:            OK.
2024-05-09 00:16:57.513 """
2024-05-09 00:16:57.518
2024-05-09 00:16:57.522 act.expected_stdout = expected_stdout
2024-05-09 00:16:57.527 act.stdout = capsys.readouterr().out
2024-05-09 00:16:57.532 >       assert act.clean_stdout == act.clean_expected_stdout
2024-05-09 00:16:57.537 E       AssertionError: assert
2024-05-09 00:16:57.542 E           CLIENT_OS_USER_CHECK:            OK.
2024-05-09 00:16:57.546 E         - CLIENT_VERSION_CHECK:            OK.
2024-05-09 00:16:57.551 E         + CLIENT_VERSION_CHECK:            Unexpected: rdb$get_context('SYSTEM', 'CLIENT_VERSION')=LI-V4.0.5.3091 Firebird 4.0 HQbird, chk_fb_vers=LI-V4.0.5.3091 Firebird 4.0 HQbird
2024-05-09 00:16:57.556 E         + LI-V4.0.5.3091 Firebird 4.0 HQbird/tcp (deb10build1)/P17:C
2024-05-09 00:16:57.560 E         + LI-V4.0.5.3091 Firebird 4.0 HQbird/tcp (deb10build1)/P17:C
2024-05-09 00:16:57.565
2024-05-09 00:16:57.570 tests/bugs/gh_7818_test.py:69: AssertionError
2024-05-09 00:16:57.574 ---------------------------- Captured stdout setup -----------------------------
2024-05-09 00:16:57.580 Cached db: db-13.0-None-None-NONE.fdb [page_size=None, sql_dialect=None, charset='NONE'
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>

    @pytest.mark.version('>=4.0')
    def test_1(act: Action, capsys):
        os_user = getpass.getuser()
        with act.db.connect() as con:
            fb_vers = con.info.firebird_version
            cur = con.cursor()
    
            test_sql = f"""
                select
                    iif( lower(system_context_client_os_user) = lower(chk_os_user)
                         ,'OK.'
                         ,q'#Unexpected: rdb$get_context('SYSTEM', 'CLIENT_OS_USER')=#'
                          || coalesce(system_context_client_os_user, '[null]')
                          || ', chk_os_user='
                          || coalesce(chk_os_user, '[null]')
                       ) as client_os_user_check
                    ,
                    iif( system_context_client_version = chk_fb_vers
                         ,'OK.'
                         ,q'#Unexpected: rdb$get_context('SYSTEM', 'CLIENT_VERSION')=#'
                          || coalesce(system_context_client_version, '[null]')
                          || ', chk_fb_vers='
                          || coalesce(chk_fb_vers, '[null]')
                       ) as client_version_check
                from (
                    select
                         rdb$get_context('SYSTEM', 'CLIENT_OS_USER') as system_context_client_os_user
                        ,rdb$get_context('SYSTEM', 'CLIENT_VERSION') as system_context_client_version
                        ,q'*{os_user}*' as chk_os_user
                        ,q'*{fb_vers}*' as chk_fb_vers
                    from rdb$database
                );
            """
    
            for r in cur.execute(test_sql):
                for i,col in enumerate(cur.description):
                    print((col[0] +':').ljust(32), r[i])
    
        expected_stdout = """
            CLIENT_OS_USER_CHECK:            OK.
            CLIENT_VERSION_CHECK:            OK.
        """
    
        act.expected_stdout = expected_stdout
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       AssertionError: assert   
E           CLIENT_OS_USER_CHECK:            OK.
E         - CLIENT_VERSION_CHECK:            OK.
E         + CLIENT_VERSION_CHECK:            Unexpected: rdb$get_context('SYSTEM', 'CLIENT_VERSION')=LI-V4.0.5.3091 Firebird 4.0 HQbird, chk_fb_vers=LI-V4.0.5.3091 Firebird 4.0 HQbird
E         + LI-V4.0.5.3091 Firebird 4.0 HQbird/tcp (deb10build1)/P17:C
E         + LI-V4.0.5.3091 Firebird 4.0 HQbird/tcp (deb10build1)/P17:C

tests/bugs/gh_7818_test.py:69: AssertionError
Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 4.0.6.3189 2025.02.25 1a1a5 P P 486 361 2025.06.29 15:53:42.966 2025.06.29 15:53:43.452 2025.06.29 14:39:32.583 2025.06.29 14:39:32.944
2 4.0.6.3184 2025.02.24 9388c P P 638 430 2025.02.25 13:48:51.791 2025.02.25 13:48:52.429 2025.02.25 12:29:35.060 2025.02.25 12:29:35.490
3 4.0.6.3183 2025.02.16 cf6ca P P 688 493 2025.02.17 07:43:04.318 2025.02.17 07:43:05.006 2025.02.17 06:23:08.845 2025.02.17 06:23:09.338
4 4.0.6.3169 2024.12.13 42cc1 P P 641 423 2025.02.16 04:40:11.817 2025.02.16 04:40:12.458 2025.02.16 03:22:26.884 2025.02.16 03:22:27.307
5 4.0.6.3169 2024.12.08 50eb6 P P 480 344 2024.12.12 18:57:09.848 2024.12.12 18:57:10.328 2024.12.12 17:54:55.820 2024.12.12 17:54:56.164
6 4.0.6.3168 2024.11.28 48149 P P 491 346 2024.12.06 03:18:02.859 2024.12.06 03:18:03.350 2024.12.06 02:17:30.703 2024.12.06 02:17:31.049
7 4.0.6.3163 2024.10.16 2bb10 P P 518 371 2024.11.27 13:42:42.828 2024.11.27 13:42:43.346 2024.11.27 10:41:12.238 2024.11.27 10:41:12.609
8 4.0.6.3163 2024.10.15 f387e P P 494 343 2024.10.16 04:48:02.686 2024.10.16 04:48:03.180 2024.10.16 03:50:29.444 2024.10.16 03:50:29.787
9 4.0.6.3147 2024.08.31 4655b P P 614 375 2024.09.30 12:04:16.358 2024.09.30 12:04:16.972 2024.09.30 10:59:56.557 2024.09.30 10:59:56.932
10 4.0.6.3140 2024.08.16 1dd8b P P 1389 1260 2024.08.31 18:36:13.954 2024.08.31 18:36:15.343 2024.08.31 16:40:32.655 2024.08.31 16:40:33.915
11 4.0.6.3140 2024.08.09 34747 P P 667 487 2024.08.16 11:09:07.411 2024.08.16 11:09:08.078 2024.08.16 09:59:09.224 2024.08.16 09:59:09.711
12 4.0.5.3110 2024.07.30 c6527 P P 930 474 2024.08.09 10:59:37.286 2024.08.09 10:59:38.216 2024.08.09 09:49:50.837 2024.08.09 09:49:51.311
13 4.0.5.3109 2024.06.11 6addf P P 499 303 2024.07.30 09:18:06.901 2024.07.30 09:18:07.400 2024.07.30 08:17:02.484 2024.07.30 08:17:02.787
14 4.0.5.3097 2024.05.09 27fa6 P P 643 418 2024.05.14 10:02:41.895 2024.05.14 10:02:42.538 2024.05.14 09:00:22.471 2024.05.14 09:00:22.889
15 4.0.5.3091 2024.04.29 bd0aa F F 373 278 2024.05.08 21:04:11.249 2024.05.08 21:04:11.622 2024.05.08 20:10:55.535 2024.05.08 20:10:55.813
16 4.0.5.3089 2024.04.25 4b9c7 P P 393 265 2024.04.27 15:48:44.339 2024.04.27 15:48:44.732 2024.04.27 14:54:44.068 2024.04.27 14:54:44.333

Elapsed time, ms. Chart for last 16 runs:

Last commits information (all timestamps in UTC):