Check firebird.log [no messages found for interval when this test was running]
Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
assert   
    1000
    select cast('Apr' as date format 'Y     MON') from rdb$database
  - Cannot find value in input string for "Y" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1010
    select cast('Apr' as date format 'YY    MON') from rdb$database
  - Cannot find value in input string for "YY" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1020
    select cast('Apr' as date format 'YYY   MON') from rdb$database
  - Cannot find value in input string for "YYY" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1030
    select cast('Apr' as date format 'YYYY  MON') from rdb$database
  - Cannot find value in input string for "YYYY" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1040
    select cast('Apr' as date format 'YEAR  MON') from rdb$database
  - Cannot find value in input string for "YEAR" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1050
    select cast('Apr' as date format 'RR    MON') from rdb$database
  - Cannot find value in input string for "RR" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1060
    select cast('Apr' as date format 'RRRR  MON') from rdb$database
  - Cannot find value in input string for "RRRR" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1070
    select cast('Apr' as date format 'MM    MON') from rdb$database
  - Cannot find value in input string for "MM" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1080
    select cast('Apr' as date format 'DD    MON') from rdb$database
  - Cannot find value in input string for "DD" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    1090
    select cast('Apr' as date format 'J     MON') from rdb$database
  - Cannot find value in input string for "J" pattern
  - 335545315
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 27
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2000
    select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
  - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
  - 335545213
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 79
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2010
    select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
  - Value for TZR pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 79
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2020
    select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
  - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
  - 335545213
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 80
  + -format
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2030
    select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
  - Value for TZR pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 80
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2040
    select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database
  - Value for TZM pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 79
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2050
    select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
  - Value for TZR pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 79
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2060
    select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database;
  - Value for TZM pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 80
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    2070
    select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
  - Value for TZR pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 80
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    3000
    select cast('00:60' as time with time zone format 'TZR') from rdb$database
  - Value for TZR pattern is out of range [0, 59]
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 44
  + -format
  - 335545297
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    3010
    select cast('15:00' as time format 'TZH:TZM') from rdb$database
  - Cannot use "TZH" format with current date type
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 29
  + -format
  - 335545296
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    3020
    select cast('15:00' as time format 'TZR') from rdb$database
  - Cannot use "TZR" format with current date type
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 29
  + -format
  - 335545296
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    3030
    select cast('-15:00' as time format 'TZH:TZM') from rdb$database
  - Cannot use "TZH" format with current date type
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 30
  + -format
  - 335545296
  + 335544569
  + 335544436
  + 335544634
  + 335544382
    3040
    select cast('-15:00' as time format 'TZR') from rdb$database
  - Cannot use "TZR" format with current date type
  + Dynamic SQL Error
  + -SQL error code = -104
  + -Token unknown - line 1, column 30
  + -format
  - 335545296
  + 335544569
  + 335544436
  + 335544634
  + 335544382

LOG DETAILS:

2025-04-12 07:42:11.294
2025-04-12 07:42:11.294 act = <firebird.qa.plugin.Action object at [hex]>
2025-04-12 07:42:11.294 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-04-12 07:42:11.294
2025-04-12 07:42:11.294     @pytest.mark.version('>=4.0')
2025-04-12 07:42:11.294     def test_1(act: Action, capsys):
2025-04-12 07:42:11.294         with act.db.connect() as con:
2025-04-12 07:42:11.294
2025-04-12 07:42:11.294             cur = con.cursor()
2025-04-12 07:42:11.294             for idx, test_sql in query_map.items():
2025-04-12 07:42:11.294                 print(idx)
2025-04-12 07:42:11.294                 print(test_sql)
2025-04-12 07:42:11.295                 try:
2025-04-12 07:42:11.295                     cur.execute(test_sql)
2025-04-12 07:42:11.295                     for r in cur:
2025-04-12 07:42:11.295                         print(r[0])
2025-04-12 07:42:11.295                 except DatabaseError as e:
2025-04-12 07:42:11.295                     print(e.__str__())
2025-04-12 07:42:11.295                     for x in e.gds_codes:
2025-04-12 07:42:11.295                         print(x)
2025-04-12 07:42:11.295
2025-04-12 07:42:11.295         expected_out = f"""
2025-04-12 07:42:11.295             1000
2025-04-12 07:42:11.295             {query_map[1000]}
2025-04-12 07:42:11.295             Cannot find value in input string for "Y" pattern
2025-04-12 07:42:11.295             335545315
2025-04-12 07:42:11.295
2025-04-12 07:42:11.295             1010
2025-04-12 07:42:11.295             {query_map[1010]}
2025-04-12 07:42:11.295             Cannot find value in input string for "YY" pattern
2025-04-12 07:42:11.295             335545315
2025-04-12 07:42:11.296
2025-04-12 07:42:11.296             1020
2025-04-12 07:42:11.296             {query_map[1020]}
2025-04-12 07:42:11.296             Cannot find value in input string for "YYY" pattern
2025-04-12 07:42:11.296             335545315
2025-04-12 07:42:11.296
2025-04-12 07:42:11.296             1030
2025-04-12 07:42:11.296             {query_map[1030]}
2025-04-12 07:42:11.296             Cannot find value in input string for "YYYY" pattern
2025-04-12 07:42:11.296             335545315
2025-04-12 07:42:11.296
2025-04-12 07:42:11.296             1040
2025-04-12 07:42:11.296             {query_map[1040]}
2025-04-12 07:42:11.296             Cannot find value in input string for "YEAR" pattern
2025-04-12 07:42:11.296             335545315
2025-04-12 07:42:11.296
2025-04-12 07:42:11.296             1050
2025-04-12 07:42:11.296             {query_map[1050]}
2025-04-12 07:42:11.296             Cannot find value in input string for "RR" pattern
2025-04-12 07:42:11.297             335545315
2025-04-12 07:42:11.297
2025-04-12 07:42:11.297             1060
2025-04-12 07:42:11.297             {query_map[1060]}
2025-04-12 07:42:11.297             Cannot find value in input string for "RRRR" pattern
2025-04-12 07:42:11.297             335545315
2025-04-12 07:42:11.297
2025-04-12 07:42:11.297             1070
2025-04-12 07:42:11.297             {query_map[1070]}
2025-04-12 07:42:11.297             Cannot find value in input string for "MM" pattern
2025-04-12 07:42:11.297             335545315
2025-04-12 07:42:11.297
2025-04-12 07:42:11.297             1080
2025-04-12 07:42:11.297             {query_map[1080]}
2025-04-12 07:42:11.297             Cannot find value in input string for "DD" pattern
2025-04-12 07:42:11.297             335545315
2025-04-12 07:42:11.297
2025-04-12 07:42:11.297             1090
2025-04-12 07:42:11.297             {query_map[1090]}
2025-04-12 07:42:11.298             Cannot find value in input string for "J" pattern
2025-04-12 07:42:11.298             335545315
2025-04-12 07:42:11.298
2025-04-12 07:42:11.298             2000
2025-04-12 07:42:11.298             {query_map[2000]}
2025-04-12 07:42:11.298             Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 07:42:11.298             335545213
2025-04-12 07:42:11.298
2025-04-12 07:42:11.298             2010
2025-04-12 07:42:11.298             {query_map[2010]}
2025-04-12 07:42:11.298             Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.298             335545297
2025-04-12 07:42:11.298
2025-04-12 07:42:11.298             2020
2025-04-12 07:42:11.298             {query_map[2020]}
2025-04-12 07:42:11.298             Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 07:42:11.298             335545213
2025-04-12 07:42:11.298
2025-04-12 07:42:11.298             2030
2025-04-12 07:42:11.299             {query_map[2030]}
2025-04-12 07:42:11.299             Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.299             335545297
2025-04-12 07:42:11.299
2025-04-12 07:42:11.299             2040
2025-04-12 07:42:11.299             {query_map[2040]}
2025-04-12 07:42:11.299             Value for TZM pattern is out of range [0, 59]
2025-04-12 07:42:11.299             335545297
2025-04-12 07:42:11.299
2025-04-12 07:42:11.299             2050
2025-04-12 07:42:11.299             {query_map[2050]}
2025-04-12 07:42:11.299             Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.299             335545297
2025-04-12 07:42:11.299
2025-04-12 07:42:11.299             2060
2025-04-12 07:42:11.299             {query_map[2060]}
2025-04-12 07:42:11.299             Value for TZM pattern is out of range [0, 59]
2025-04-12 07:42:11.299             335545297
2025-04-12 07:42:11.299
2025-04-12 07:42:11.299             2070
2025-04-12 07:42:11.300             {query_map[2070]}
2025-04-12 07:42:11.300             Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.300             335545297
2025-04-12 07:42:11.300
2025-04-12 07:42:11.300             3000
2025-04-12 07:42:11.300             {query_map[3000]}
2025-04-12 07:42:11.300             Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.300             335545297
2025-04-12 07:42:11.300
2025-04-12 07:42:11.300             3010
2025-04-12 07:42:11.300             {query_map[3010]}
2025-04-12 07:42:11.300             Cannot use "TZH" format with current date type
2025-04-12 07:42:11.300             335545296
2025-04-12 07:42:11.300
2025-04-12 07:42:11.300             3020
2025-04-12 07:42:11.300             {query_map[3020]}
2025-04-12 07:42:11.300             Cannot use "TZR" format with current date type
2025-04-12 07:42:11.300             335545296
2025-04-12 07:42:11.300
2025-04-12 07:42:11.300             3030
2025-04-12 07:42:11.301             {query_map[3030]}
2025-04-12 07:42:11.301             Cannot use "TZH" format with current date type
2025-04-12 07:42:11.301             335545296
2025-04-12 07:42:11.301
2025-04-12 07:42:11.301             3040
2025-04-12 07:42:11.301             {query_map[3040]}
2025-04-12 07:42:11.301             Cannot use "TZR" format with current date type
2025-04-12 07:42:11.301             335545296
2025-04-12 07:42:11.301         """
2025-04-12 07:42:11.301         act.expected_stdout = expected_out
2025-04-12 07:42:11.301         act.stdout = capsys.readouterr().out
2025-04-12 07:42:11.301 >       assert act.clean_stdout == act.clean_expected_stdout
2025-04-12 07:42:11.301 E       assert
2025-04-12 07:42:11.301 E           1000
2025-04-12 07:42:11.301 E           select cast('Apr' as date format 'Y     MON') from rdb$database
2025-04-12 07:42:11.301 E         - Cannot find value in input string for "Y" pattern
2025-04-12 07:42:11.301 E         - 335545315
2025-04-12 07:42:11.301 E         + Dynamic SQL Error
2025-04-12 07:42:11.301 E         + -SQL error code = -104
2025-04-12 07:42:11.302 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.302 E         + -format
2025-04-12 07:42:11.302 E         + 335544569
2025-04-12 07:42:11.302 E         + 335544436
2025-04-12 07:42:11.302 E         + 335544634
2025-04-12 07:42:11.302 E         + 335544382
2025-04-12 07:42:11.302 E           1010
2025-04-12 07:42:11.302 E           select cast('Apr' as date format 'YY    MON') from rdb$database
2025-04-12 07:42:11.302 E         - Cannot find value in input string for "YY" pattern
2025-04-12 07:42:11.302 E         - 335545315
2025-04-12 07:42:11.302 E         + Dynamic SQL Error
2025-04-12 07:42:11.302 E         + -SQL error code = -104
2025-04-12 07:42:11.302 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.302 E         + -format
2025-04-12 07:42:11.302 E         + 335544569
2025-04-12 07:42:11.302 E         + 335544436
2025-04-12 07:42:11.302 E         + 335544634
2025-04-12 07:42:11.302 E         + 335544382
2025-04-12 07:42:11.302 E           1020
2025-04-12 07:42:11.303 E           select cast('Apr' as date format 'YYY   MON') from rdb$database
2025-04-12 07:42:11.303 E         - Cannot find value in input string for "YYY" pattern
2025-04-12 07:42:11.303 E         - 335545315
2025-04-12 07:42:11.303 E         + Dynamic SQL Error
2025-04-12 07:42:11.303 E         + -SQL error code = -104
2025-04-12 07:42:11.303 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.303 E         + -format
2025-04-12 07:42:11.303 E         + 335544569
2025-04-12 07:42:11.303 E         + 335544436
2025-04-12 07:42:11.303 E         + 335544634
2025-04-12 07:42:11.303 E         + 335544382
2025-04-12 07:42:11.303 E           1030
2025-04-12 07:42:11.303 E           select cast('Apr' as date format 'YYYY  MON') from rdb$database
2025-04-12 07:42:11.303 E         - Cannot find value in input string for "YYYY" pattern
2025-04-12 07:42:11.303 E         - 335545315
2025-04-12 07:42:11.303 E         + Dynamic SQL Error
2025-04-12 07:42:11.303 E         + -SQL error code = -104
2025-04-12 07:42:11.303 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.303 E         + -format
2025-04-12 07:42:11.303 E         + 335544569
2025-04-12 07:42:11.304 E         + 335544436
2025-04-12 07:42:11.304 E         + 335544634
2025-04-12 07:42:11.304 E         + 335544382
2025-04-12 07:42:11.304 E           1040
2025-04-12 07:42:11.304 E           select cast('Apr' as date format 'YEAR  MON') from rdb$database
2025-04-12 07:42:11.304 E         - Cannot find value in input string for "YEAR" pattern
2025-04-12 07:42:11.304 E         - 335545315
2025-04-12 07:42:11.304 E         + Dynamic SQL Error
2025-04-12 07:42:11.304 E         + -SQL error code = -104
2025-04-12 07:42:11.304 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.304 E         + -format
2025-04-12 07:42:11.304 E         + 335544569
2025-04-12 07:42:11.304 E         + 335544436
2025-04-12 07:42:11.304 E         + 335544634
2025-04-12 07:42:11.304 E         + 335544382
2025-04-12 07:42:11.304 E           1050
2025-04-12 07:42:11.304 E           select cast('Apr' as date format 'RR    MON') from rdb$database
2025-04-12 07:42:11.304 E         - Cannot find value in input string for "RR" pattern
2025-04-12 07:42:11.304 E         - 335545315
2025-04-12 07:42:11.304 E         + Dynamic SQL Error
2025-04-12 07:42:11.305 E         + -SQL error code = -104
2025-04-12 07:42:11.305 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.305 E         + -format
2025-04-12 07:42:11.305 E         + 335544569
2025-04-12 07:42:11.305 E         + 335544436
2025-04-12 07:42:11.305 E         + 335544634
2025-04-12 07:42:11.305 E         + 335544382
2025-04-12 07:42:11.305 E           1060
2025-04-12 07:42:11.305 E           select cast('Apr' as date format 'RRRR  MON') from rdb$database
2025-04-12 07:42:11.305 E         - Cannot find value in input string for "RRRR" pattern
2025-04-12 07:42:11.305 E         - 335545315
2025-04-12 07:42:11.305 E         + Dynamic SQL Error
2025-04-12 07:42:11.305 E         + -SQL error code = -104
2025-04-12 07:42:11.305 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.305 E         + -format
2025-04-12 07:42:11.305 E         + 335544569
2025-04-12 07:42:11.305 E         + 335544436
2025-04-12 07:42:11.305 E         + 335544634
2025-04-12 07:42:11.305 E         + 335544382
2025-04-12 07:42:11.305 E           1070
2025-04-12 07:42:11.306 E           select cast('Apr' as date format 'MM    MON') from rdb$database
2025-04-12 07:42:11.306 E         - Cannot find value in input string for "MM" pattern
2025-04-12 07:42:11.306 E         - 335545315
2025-04-12 07:42:11.306 E         + Dynamic SQL Error
2025-04-12 07:42:11.306 E         + -SQL error code = -104
2025-04-12 07:42:11.306 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.306 E         + -format
2025-04-12 07:42:11.306 E         + 335544569
2025-04-12 07:42:11.306 E         + 335544436
2025-04-12 07:42:11.306 E         + 335544634
2025-04-12 07:42:11.306 E         + 335544382
2025-04-12 07:42:11.306 E           1080
2025-04-12 07:42:11.306 E           select cast('Apr' as date format 'DD    MON') from rdb$database
2025-04-12 07:42:11.306 E         - Cannot find value in input string for "DD" pattern
2025-04-12 07:42:11.306 E         - 335545315
2025-04-12 07:42:11.306 E         + Dynamic SQL Error
2025-04-12 07:42:11.306 E         + -SQL error code = -104
2025-04-12 07:42:11.306 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.306 E         + -format
2025-04-12 07:42:11.306 E         + 335544569
2025-04-12 07:42:11.307 E         + 335544436
2025-04-12 07:42:11.307 E         + 335544634
2025-04-12 07:42:11.307 E         + 335544382
2025-04-12 07:42:11.307 E           1090
2025-04-12 07:42:11.307 E           select cast('Apr' as date format 'J     MON') from rdb$database
2025-04-12 07:42:11.307 E         - Cannot find value in input string for "J" pattern
2025-04-12 07:42:11.307 E         - 335545315
2025-04-12 07:42:11.307 E         + Dynamic SQL Error
2025-04-12 07:42:11.307 E         + -SQL error code = -104
2025-04-12 07:42:11.307 E         + -Token unknown - line 1, column 27
2025-04-12 07:42:11.307 E         + -format
2025-04-12 07:42:11.307 E         + 335544569
2025-04-12 07:42:11.307 E         + 335544436
2025-04-12 07:42:11.307 E         + 335544634
2025-04-12 07:42:11.307 E         + 335544382
2025-04-12 07:42:11.307 E           2000
2025-04-12 07:42:11.307 E           select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
2025-04-12 07:42:11.307 E         - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 07:42:11.308 E         - 335545213
2025-04-12 07:42:11.308 E         + Dynamic SQL Error
2025-04-12 07:42:11.308 E         + -SQL error code = -104
2025-04-12 07:42:11.308 E         + -Token unknown - line 1, column 79
2025-04-12 07:42:11.308 E         + -format
2025-04-12 07:42:11.308 E         + 335544569
2025-04-12 07:42:11.308 E         + 335544436
2025-04-12 07:42:11.308 E         + 335544634
2025-04-12 07:42:11.308 E         + 335544382
2025-04-12 07:42:11.308 E           2010
2025-04-12 07:42:11.308 E           select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
2025-04-12 07:42:11.308 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.308 E         + Dynamic SQL Error
2025-04-12 07:42:11.308 E         + -SQL error code = -104
2025-04-12 07:42:11.308 E         + -Token unknown - line 1, column 79
2025-04-12 07:42:11.308 E         + -format
2025-04-12 07:42:11.308 E         - 335545297
2025-04-12 07:42:11.308 E         + 335544569
2025-04-12 07:42:11.309 E         + 335544436
2025-04-12 07:42:11.309 E         + 335544634
2025-04-12 07:42:11.309 E         + 335544382
2025-04-12 07:42:11.309 E           2020
2025-04-12 07:42:11.309 E           select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
2025-04-12 07:42:11.309 E         - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 07:42:11.309 E         - 335545213
2025-04-12 07:42:11.309 E         + Dynamic SQL Error
2025-04-12 07:42:11.309 E         + -SQL error code = -104
2025-04-12 07:42:11.309 E         + -Token unknown - line 1, column 80
2025-04-12 07:42:11.309 E         + -format
2025-04-12 07:42:11.309 E         + 335544569
2025-04-12 07:42:11.309 E         + 335544436
2025-04-12 07:42:11.309 E         + 335544634
2025-04-12 07:42:11.309 E         + 335544382
2025-04-12 07:42:11.309 E           2030
2025-04-12 07:42:11.309 E           select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
2025-04-12 07:42:11.309 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.309 E         + Dynamic SQL Error
2025-04-12 07:42:11.309 E         + -SQL error code = -104
2025-04-12 07:42:11.310 E         + -Token unknown - line 1, column 80
2025-04-12 07:42:11.310 E         + -format
2025-04-12 07:42:11.310 E         - 335545297
2025-04-12 07:42:11.310 E         + 335544569
2025-04-12 07:42:11.310 E         + 335544436
2025-04-12 07:42:11.310 E         + 335544634
2025-04-12 07:42:11.310 E         + 335544382
2025-04-12 07:42:11.310 E           2040
2025-04-12 07:42:11.310 E           select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database
2025-04-12 07:42:11.310 E         - Value for TZM pattern is out of range [0, 59]
2025-04-12 07:42:11.310 E         + Dynamic SQL Error
2025-04-12 07:42:11.310 E         + -SQL error code = -104
2025-04-12 07:42:11.310 E         + -Token unknown - line 1, column 79
2025-04-12 07:42:11.310 E         + -format
2025-04-12 07:42:11.310 E         - 335545297
2025-04-12 07:42:11.310 E         + 335544569
2025-04-12 07:42:11.311 E         + 335544436
2025-04-12 07:42:11.311 E         + 335544634
2025-04-12 07:42:11.311 E         + 335544382
2025-04-12 07:42:11.311 E           2050
2025-04-12 07:42:11.311 E           select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
2025-04-12 07:42:11.311 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.311 E         + Dynamic SQL Error
2025-04-12 07:42:11.311 E         + -SQL error code = -104
2025-04-12 07:42:11.311 E         + -Token unknown - line 1, column 79
2025-04-12 07:42:11.311 E         + -format
2025-04-12 07:42:11.311 E         - 335545297
2025-04-12 07:42:11.311 E         + 335544569
2025-04-12 07:42:11.311 E         + 335544436
2025-04-12 07:42:11.311 E         + 335544634
2025-04-12 07:42:11.311 E         + 335544382
2025-04-12 07:42:11.311 E           2060
2025-04-12 07:42:11.311 E           select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database;
2025-04-12 07:42:11.311 E         - Value for TZM pattern is out of range [0, 59]
2025-04-12 07:42:11.312 E         + Dynamic SQL Error
2025-04-12 07:42:11.312 E         + -SQL error code = -104
2025-04-12 07:42:11.312 E         + -Token unknown - line 1, column 80
2025-04-12 07:42:11.312 E         + -format
2025-04-12 07:42:11.312 E         - 335545297
2025-04-12 07:42:11.312 E         + 335544569
2025-04-12 07:42:11.312 E         + 335544436
2025-04-12 07:42:11.312 E         + 335544634
2025-04-12 07:42:11.312 E         + 335544382
2025-04-12 07:42:11.312 E           2070
2025-04-12 07:42:11.312 E           select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
2025-04-12 07:42:11.312 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.312 E         + Dynamic SQL Error
2025-04-12 07:42:11.312 E         + -SQL error code = -104
2025-04-12 07:42:11.312 E         + -Token unknown - line 1, column 80
2025-04-12 07:42:11.312 E         + -format
2025-04-12 07:42:11.312 E         - 335545297
2025-04-12 07:42:11.313 E         + 335544569
2025-04-12 07:42:11.313 E         + 335544436
2025-04-12 07:42:11.313 E         + 335544634
2025-04-12 07:42:11.313 E         + 335544382
2025-04-12 07:42:11.313 E           3000
2025-04-12 07:42:11.313 E           select cast('00:60' as time with time zone format 'TZR') from rdb$database
2025-04-12 07:42:11.313 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 07:42:11.313 E         + Dynamic SQL Error
2025-04-12 07:42:11.313 E         + -SQL error code = -104
2025-04-12 07:42:11.313 E         + -Token unknown - line 1, column 44
2025-04-12 07:42:11.313 E         + -format
2025-04-12 07:42:11.313 E         - 335545297
2025-04-12 07:42:11.313 E         + 335544569
2025-04-12 07:42:11.313 E         + 335544436
2025-04-12 07:42:11.313 E         + 335544634
2025-04-12 07:42:11.314 E         + 335544382
2025-04-12 07:42:11.314 E           3010
2025-04-12 07:42:11.314 E           select cast('15:00' as time format 'TZH:TZM') from rdb$database
2025-04-12 07:42:11.314 E         - Cannot use "TZH" format with current date type
2025-04-12 07:42:11.314 E         + Dynamic SQL Error
2025-04-12 07:42:11.314 E         + -SQL error code = -104
2025-04-12 07:42:11.314 E         + -Token unknown - line 1, column 29
2025-04-12 07:42:11.314 E         + -format
2025-04-12 07:42:11.314 E         - 335545296
2025-04-12 07:42:11.314 E         + 335544569
2025-04-12 07:42:11.314 E         + 335544436
2025-04-12 07:42:11.314 E         + 335544634
2025-04-12 07:42:11.314 E         + 335544382
2025-04-12 07:42:11.314 E           3020
2025-04-12 07:42:11.314 E           select cast('15:00' as time format 'TZR') from rdb$database
2025-04-12 07:42:11.314 E         - Cannot use "TZR" format with current date type
2025-04-12 07:42:11.314 E         + Dynamic SQL Error
2025-04-12 07:42:11.314 E         + -SQL error code = -104
2025-04-12 07:42:11.315 E         + -Token unknown - line 1, column 29
2025-04-12 07:42:11.315 E         + -format
2025-04-12 07:42:11.315 E         - 335545296
2025-04-12 07:42:11.315 E         + 335544569
2025-04-12 07:42:11.315 E         + 335544436
2025-04-12 07:42:11.315 E         + 335544634
2025-04-12 07:42:11.315 E         + 335544382
2025-04-12 07:42:11.315 E           3030
2025-04-12 07:42:11.315 E           select cast('-15:00' as time format 'TZH:TZM') from rdb$database
2025-04-12 07:42:11.315 E         - Cannot use "TZH" format with current date type
2025-04-12 07:42:11.315 E         + Dynamic SQL Error
2025-04-12 07:42:11.315 E         + -SQL error code = -104
2025-04-12 07:42:11.315 E         + -Token unknown - line 1, column 30
2025-04-12 07:42:11.315 E         + -format
2025-04-12 07:42:11.315 E         - 335545296
2025-04-12 07:42:11.315 E         + 335544569
2025-04-12 07:42:11.316 E         + 335544436
2025-04-12 07:42:11.316 E         + 335544634
2025-04-12 07:42:11.316 E         + 335544382
2025-04-12 07:42:11.316 E           3040
2025-04-12 07:42:11.316 E           select cast('-15:00' as time format 'TZR') from rdb$database
2025-04-12 07:42:11.316 E         - Cannot use "TZR" format with current date type
2025-04-12 07:42:11.316 E         + Dynamic SQL Error
2025-04-12 07:42:11.316 E         + -SQL error code = -104
2025-04-12 07:42:11.316 E         + -Token unknown - line 1, column 30
2025-04-12 07:42:11.316 E         + -format
2025-04-12 07:42:11.316 E         - 335545296
2025-04-12 07:42:11.316 E         + 335544569
2025-04-12 07:42:11.316 E         + 335544436
2025-04-12 07:42:11.316 E         + 335544634
2025-04-12 07:42:11.316 E         + 335544382
2025-04-12 07:42:11.316
2025-04-12 07:42:11.316 tests\bugs\gh_8501_test.py:218: AssertionError
2025-04-12 07:42:11.316 ---------------------------- Captured stdout setup ----------------------------
2025-04-12 07:42:11.317 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11718\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):
        with act.db.connect() as con:
    
            cur = con.cursor()
            for idx, test_sql in query_map.items():
                print(idx)
                print(test_sql)
                try:
                    cur.execute(test_sql)
                    for r in cur:
                        print(r[0])
                except DatabaseError as e:
                    print(e.__str__())
                    for x in e.gds_codes:
                        print(x)
    
        expected_out = f"""
            1000
            {query_map[1000]}
            Cannot find value in input string for "Y" pattern
            335545315
    
            1010
            {query_map[1010]}
            Cannot find value in input string for "YY" pattern
            335545315
    
            1020
            {query_map[1020]}
            Cannot find value in input string for "YYY" pattern
            335545315
    
            1030
            {query_map[1030]}
            Cannot find value in input string for "YYYY" pattern
            335545315
    
            1040
            {query_map[1040]}
            Cannot find value in input string for "YEAR" pattern
            335545315
    
            1050
            {query_map[1050]}
            Cannot find value in input string for "RR" pattern
            335545315
    
            1060
            {query_map[1060]}
            Cannot find value in input string for "RRRR" pattern
            335545315
    
            1070
            {query_map[1070]}
            Cannot find value in input string for "MM" pattern
            335545315
    
            1080
            {query_map[1080]}
            Cannot find value in input string for "DD" pattern
            335545315
    
            1090
            {query_map[1090]}
            Cannot find value in input string for "J" pattern
            335545315
    
            2000
            {query_map[2000]}
            Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
            335545213
    
            2010
            {query_map[2010]}
            Value for TZR pattern is out of range [0, 59]
            335545297
    
            2020
            {query_map[2020]}
            Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
            335545213
    
            2030
            {query_map[2030]}
            Value for TZR pattern is out of range [0, 59]
            335545297
    
            2040
            {query_map[2040]}
            Value for TZM pattern is out of range [0, 59]
            335545297
    
            2050
            {query_map[2050]}
            Value for TZR pattern is out of range [0, 59]
            335545297
    
            2060
            {query_map[2060]}
            Value for TZM pattern is out of range [0, 59]
            335545297
    
            2070
            {query_map[2070]}
            Value for TZR pattern is out of range [0, 59]
            335545297
    
            3000
            {query_map[3000]}
            Value for TZR pattern is out of range [0, 59]
            335545297
    
            3010
            {query_map[3010]}
            Cannot use "TZH" format with current date type
            335545296
    
            3020
            {query_map[3020]}
            Cannot use "TZR" format with current date type
            335545296
    
            3030
            {query_map[3030]}
            Cannot use "TZH" format with current date type
            335545296
    
            3040
            {query_map[3040]}
            Cannot use "TZR" format with current date type
            335545296
        """
        act.expected_stdout = expected_out
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           1000
E           select cast('Apr' as date format 'Y     MON') from rdb$database
E         - Cannot find value in input string for "Y" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1010
E           select cast('Apr' as date format 'YY    MON') from rdb$database
E         - Cannot find value in input string for "YY" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1020
E           select cast('Apr' as date format 'YYY   MON') from rdb$database
E         - Cannot find value in input string for "YYY" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1030
E           select cast('Apr' as date format 'YYYY  MON') from rdb$database
E         - Cannot find value in input string for "YYYY" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1040
E           select cast('Apr' as date format 'YEAR  MON') from rdb$database
E         - Cannot find value in input string for "YEAR" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1050
E           select cast('Apr' as date format 'RR    MON') from rdb$database
E         - Cannot find value in input string for "RR" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1060
E           select cast('Apr' as date format 'RRRR  MON') from rdb$database
E         - Cannot find value in input string for "RRRR" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1070
E           select cast('Apr' as date format 'MM    MON') from rdb$database
E         - Cannot find value in input string for "MM" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1080
E           select cast('Apr' as date format 'DD    MON') from rdb$database
E         - Cannot find value in input string for "DD" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           1090
E           select cast('Apr' as date format 'J     MON') from rdb$database
E         - Cannot find value in input string for "J" pattern
E         - 335545315
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 27
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2000
E           select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
E         - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
E         - 335545213
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 79
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2010
E           select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
E         - Value for TZR pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 79
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2020
E           select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
E         - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
E         - 335545213
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 80
E         + -format
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2030
E           select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
E         - Value for TZR pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 80
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2040
E           select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database
E         - Value for TZM pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 79
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2050
E           select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
E         - Value for TZR pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 79
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2060
E           select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database;
E         - Value for TZM pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 80
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           2070
E           select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
E         - Value for TZR pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 80
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           3000
E           select cast('00:60' as time with time zone format 'TZR') from rdb$database
E         - Value for TZR pattern is out of range [0, 59]
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 44
E         + -format
E         - 335545297
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           3010
E           select cast('15:00' as time format 'TZH:TZM') from rdb$database
E         - Cannot use "TZH" format with current date type
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 29
E         + -format
E         - 335545296
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           3020
E           select cast('15:00' as time format 'TZR') from rdb$database
E         - Cannot use "TZR" format with current date type
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 29
E         + -format
E         - 335545296
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           3030
E           select cast('-15:00' as time format 'TZH:TZM') from rdb$database
E         - Cannot use "TZH" format with current date type
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 30
E         + -format
E         - 335545296
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382
E           3040
E           select cast('-15:00' as time format 'TZR') from rdb$database
E         - Cannot use "TZR" format with current date type
E         + Dynamic SQL Error
E         + -SQL error code = -104
E         + -Token unknown - line 1, column 30
E         + -format
E         - 335545296
E         + 335544569
E         + 335544436
E         + 335544634
E         + 335544382

tests\bugs\gh_8501_test.py:218: 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 5.0.3.1643 2025.04.11 a5179 F F 862 644 2025.04.12 04:23:43.793 2025.04.12 04:23:44.655 2025.04.12 03:20:39.862 2025.04.12 03:20:40.506

Elapsed time, ms. Chart for last 1 runs:

Last commits information (all timestamps in UTC):