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

Annotation type Annotation details
2 @message
AssertionError: assert   
  - tzfile('Indian/Cocos')
  - tzfile('Indian/Cocos')
  + tzfile('/usr/share/zoneinfo/Indian/Cocos')
  + tzfile('/usr/share/zoneinfo/Indian/Cocos')

LOG DETAILS:

2024-08-31 22:04:37.906
2024-08-31 22:04:37.921 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-31 22:04:37.935 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-08-31 22:04:37.947
2024-08-31 22:04:37.958 @pytest.mark.version('>=4.0')
2024-08-31 22:04:37.969 def test_1(act: Action, capsys):
2024-08-31 22:04:37.979
2024-08-31 22:04:37.989 srv_cfg = driver_config.register_server(name = 'srv_cfg_6282', config = '')
2024-08-31 22:04:38.005
2024-08-31 22:04:38.017 db_cfg_name = f'db_cfg_6282'
2024-08-31 22:04:38.027
2024-08-31 22:04:38.037 # DatabaseConfig; see PYTHON_HOME/Lib/site-packages/firebird\driver\config.py:
2024-08-31 22:04:38.046 db_cfg_object = driver_config.register_database(name = db_cfg_name)
2024-08-31 22:04:38.054
2024-08-31 22:04:38.065 db_cfg_object.server.value = srv_cfg.name
2024-08-31 22:04:38.074 db_cfg_object.protocol.value = NetProtocol.INET
2024-08-31 22:04:38.083 db_cfg_object.database.value = str(act.db.db_path)
2024-08-31 22:04:38.092
2024-08-31 22:04:38.102 ######################################################
2024-08-31 22:04:38.117 ###  c h e c k    s e s s i o n   t i m e z o n e  ###
2024-08-31 22:04:38.128 ######################################################
2024-08-31 22:04:38.138 #
2024-08-31 22:04:38.149 SELECTED_TIMEZONE = 'Indian/Cocos'
2024-08-31 22:04:38.160 db_cfg_object.session_time_zone.value = SELECTED_TIMEZONE
2024-08-31 22:04:38.170 with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
2024-08-31 22:04:38.181 cur = con.cursor()
2024-08-31 22:04:38.191 cur.execute('select current_timestamp from rdb$database')
2024-08-31 22:04:38.201 for r in cur:
2024-08-31 22:04:38.211 print(r[0].tzinfo)
2024-08-31 22:04:38.221 cur.close()
2024-08-31 22:04:38.231
2024-08-31 22:04:38.241 # The value set through the DPB should survive an `alter session reset`
2024-08-31 22:04:38.251 con.execute_immediate('alter session reset')
2024-08-31 22:04:38.261 con.commit()
2024-08-31 22:04:38.270
2024-08-31 22:04:38.279 cur = con.cursor()
2024-08-31 22:04:38.288 cur.execute('select current_timestamp from rdb$database')
2024-08-31 22:04:38.296 for r in cur:
2024-08-31 22:04:38.304 print(r[0].tzinfo)
2024-08-31 22:04:38.312
2024-08-31 22:04:38.319 act.expected_stdout = f"""
2024-08-31 22:04:38.327 tzfile('{SELECTED_TIMEZONE}')
2024-08-31 22:04:38.343 tzfile('{SELECTED_TIMEZONE}')
2024-08-31 22:04:38.355 """
2024-08-31 22:04:38.367 act.stdout = capsys.readouterr().out
2024-08-31 22:04:38.378 >       assert act.clean_stdout == act.clean_expected_stdout
2024-08-31 22:04:38.394 E       AssertionError: assert
2024-08-31 22:04:38.408 E         - tzfile('Indian/Cocos')
2024-08-31 22:04:38.421 E         - tzfile('Indian/Cocos')
2024-08-31 22:04:38.432 E         + tzfile('/usr/share/zoneinfo/Indian/Cocos')
2024-08-31 22:04:38.441 E         + tzfile('/usr/share/zoneinfo/Indian/Cocos')
2024-08-31 22:04:38.450
2024-08-31 22:04:38.460 tests/bugs/gh_6282_test.py:124: AssertionError
2024-08-31 22:04:38.475 ---------------------------- Captured stdout setup -----------------------------
2024-08-31 22:04:38.490 Creating db: localhost:/var/tmp/qa_2024/test_11400/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
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):
    
        srv_cfg = driver_config.register_server(name = 'srv_cfg_6282', config = '')
    
        db_cfg_name = f'db_cfg_6282'
    
        # DatabaseConfig; see PYTHON_HOME/Lib/site-packages/firebird\driver\config.py:
        db_cfg_object = driver_config.register_database(name = db_cfg_name)
    
        db_cfg_object.server.value = srv_cfg.name
        db_cfg_object.protocol.value = NetProtocol.INET
        db_cfg_object.database.value = str(act.db.db_path)
    
        ######################################################
        ###  c h e c k    s e s s i o n   t i m e z o n e  ###
        ######################################################
        #
        SELECTED_TIMEZONE = 'Indian/Cocos'
        db_cfg_object.session_time_zone.value = SELECTED_TIMEZONE
        with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
            cur = con.cursor()
            cur.execute('select current_timestamp from rdb$database')
            for r in cur:
                print(r[0].tzinfo)
            cur.close()
    
            # The value set through the DPB should survive an `alter session reset`
            con.execute_immediate('alter session reset')
            con.commit()
    
            cur = con.cursor()
            cur.execute('select current_timestamp from rdb$database')
            for r in cur:
                print(r[0].tzinfo)
    
        act.expected_stdout = f"""
            tzfile('{SELECTED_TIMEZONE}')
            tzfile('{SELECTED_TIMEZONE}')
        """
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       AssertionError: assert   
E         - tzfile('Indian/Cocos')
E         - tzfile('Indian/Cocos')
E         + tzfile('/usr/share/zoneinfo/Indian/Cocos')
E         + tzfile('/usr/share/zoneinfo/Indian/Cocos')

tests/bugs/gh_6282_test.py:124: 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 2223 1313 2025.06.29 15:44:52.155 2025.06.29 15:44:54.378 2025.06.29 14:30:42.652 2025.06.29 14:30:43.965
2 4.0.6.3184 2025.02.24 9388c P P 779 730 2025.02.25 13:38:22.814 2025.02.25 13:38:23.593 2025.02.25 12:19:52.371 2025.02.25 12:19:53.101
3 4.0.6.3183 2025.02.16 cf6ca P P 940 702 2025.02.17 07:32:19.321 2025.02.17 07:32:20.261 2025.02.17 06:13:18.481 2025.02.17 06:13:19.183
4 4.0.6.3169 2024.12.13 42cc1 P P 917 722 2025.02.16 04:29:53.916 2025.02.16 04:29:54.833 2025.02.16 03:12:50.795 2025.02.16 03:12:51.517
5 4.0.6.3169 2024.12.08 50eb6 P P 777 536 2024.12.12 18:49:06.789 2024.12.12 18:49:07.566 2024.12.12 17:47:33.973 2024.12.12 17:47:34.509
6 4.0.6.3168 2024.11.28 48149 P P 730 523 2024.12.06 03:10:27.731 2024.12.06 03:10:28.461 2024.12.06 02:10:26.440 2024.12.06 02:10:26.963
7 4.0.6.3163 2024.10.16 2bb10 P P 789 562 2024.11.27 13:34:45.454 2024.11.27 13:34:46.243 2024.11.27 10:33:48.839 2024.11.27 10:33:49.401
8 4.0.6.3163 2024.10.15 f387e P P 696 537 2024.10.16 04:40:36.606 2024.10.16 04:40:37.302 2024.10.16 03:43:28.700 2024.10.16 03:43:29.237
9 4.0.6.3147 2024.08.31 4655b P P 743 573 2024.09.30 11:55:47.309 2024.09.30 11:55:48.052 2024.09.30 10:52:03.587 2024.09.30 10:52:04.160
10 4.0.6.3140 2024.08.16 1dd8b F F 1956 1319 2024.08.31 18:20:32.410 2024.08.31 18:20:34.366 2024.08.31 16:26:04.604 2024.08.31 16:26:05.923
11 4.0.6.3140 2024.08.09 34747 F F 16271 15678 2024.08.16 11:00:57.597 2024.08.16 11:01:13.868 2024.08.16 09:51:39.748 2024.08.16 09:51:55.426
12 4.0.5.3110 2024.07.30 c6527 F F 17889 38910 2024.08.09 10:52:22.844 2024.08.09 10:52:40.733 2024.08.09 09:43:12.777 2024.08.09 09:43:51.687
13 4.0.5.3109 2024.06.11 6addf F F 37494 41672 2024.07.30 09:11:16.916 2024.07.30 09:11:54.410 2024.07.30 08:10:45.312 2024.07.30 08:11:26.984

Elapsed time, ms. Chart for last 13 runs:

Last commits information (all timestamps in UTC):