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 09:47:03.122
2025-04-12 09:47:03.122 act = <firebird.qa.plugin.Action object at [hex]>
2025-04-12 09:47:03.123 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-04-12 09:47:03.123
2025-04-12 09:47:03.123     @pytest.mark.version('>=4.0')
2025-04-12 09:47:03.123     def test_1(act: Action, capsys):
2025-04-12 09:47:03.123         with act.db.connect() as con:
2025-04-12 09:47:03.123
2025-04-12 09:47:03.123             cur = con.cursor()
2025-04-12 09:47:03.123             for idx, test_sql in query_map.items():
2025-04-12 09:47:03.123                 print(idx)
2025-04-12 09:47:03.123                 print(test_sql)
2025-04-12 09:47:03.123                 try:
2025-04-12 09:47:03.123                     cur.execute(test_sql)
2025-04-12 09:47:03.123                     for r in cur:
2025-04-12 09:47:03.123                         print(r[0])
2025-04-12 09:47:03.123                 except DatabaseError as e:
2025-04-12 09:47:03.123                     print(e.__str__())
2025-04-12 09:47:03.123                     for x in e.gds_codes:
2025-04-12 09:47:03.123                         print(x)
2025-04-12 09:47:03.123
2025-04-12 09:47:03.124         expected_out = f"""
2025-04-12 09:47:03.124             1000
2025-04-12 09:47:03.124             {query_map[1000]}
2025-04-12 09:47:03.124             Cannot find value in input string for "Y" pattern
2025-04-12 09:47:03.124             335545315
2025-04-12 09:47:03.124
2025-04-12 09:47:03.124             1010
2025-04-12 09:47:03.124             {query_map[1010]}
2025-04-12 09:47:03.124             Cannot find value in input string for "YY" pattern
2025-04-12 09:47:03.124             335545315
2025-04-12 09:47:03.124
2025-04-12 09:47:03.124             1020
2025-04-12 09:47:03.124             {query_map[1020]}
2025-04-12 09:47:03.124             Cannot find value in input string for "YYY" pattern
2025-04-12 09:47:03.124             335545315
2025-04-12 09:47:03.124
2025-04-12 09:47:03.124             1030
2025-04-12 09:47:03.124             {query_map[1030]}
2025-04-12 09:47:03.124             Cannot find value in input string for "YYYY" pattern
2025-04-12 09:47:03.124             335545315
2025-04-12 09:47:03.125
2025-04-12 09:47:03.125             1040
2025-04-12 09:47:03.125             {query_map[1040]}
2025-04-12 09:47:03.125             Cannot find value in input string for "YEAR" pattern
2025-04-12 09:47:03.125             335545315
2025-04-12 09:47:03.125
2025-04-12 09:47:03.125             1050
2025-04-12 09:47:03.125             {query_map[1050]}
2025-04-12 09:47:03.125             Cannot find value in input string for "RR" pattern
2025-04-12 09:47:03.125             335545315
2025-04-12 09:47:03.125
2025-04-12 09:47:03.125             1060
2025-04-12 09:47:03.125             {query_map[1060]}
2025-04-12 09:47:03.125             Cannot find value in input string for "RRRR" pattern
2025-04-12 09:47:03.125             335545315
2025-04-12 09:47:03.125
2025-04-12 09:47:03.125             1070
2025-04-12 09:47:03.125             {query_map[1070]}
2025-04-12 09:47:03.125             Cannot find value in input string for "MM" pattern
2025-04-12 09:47:03.125             335545315
2025-04-12 09:47:03.126
2025-04-12 09:47:03.126             1080
2025-04-12 09:47:03.126             {query_map[1080]}
2025-04-12 09:47:03.126             Cannot find value in input string for "DD" pattern
2025-04-12 09:47:03.126             335545315
2025-04-12 09:47:03.126
2025-04-12 09:47:03.126             1090
2025-04-12 09:47:03.126             {query_map[1090]}
2025-04-12 09:47:03.126             Cannot find value in input string for "J" pattern
2025-04-12 09:47:03.126             335545315
2025-04-12 09:47:03.126
2025-04-12 09:47:03.126             2000
2025-04-12 09:47:03.126             {query_map[2000]}
2025-04-12 09:47:03.126             Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 09:47:03.126             335545213
2025-04-12 09:47:03.126
2025-04-12 09:47:03.126             2010
2025-04-12 09:47:03.126             {query_map[2010]}
2025-04-12 09:47:03.126             Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.126             335545297
2025-04-12 09:47:03.127
2025-04-12 09:47:03.127             2020
2025-04-12 09:47:03.127             {query_map[2020]}
2025-04-12 09:47:03.127             Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 09:47:03.127             335545213
2025-04-12 09:47:03.127
2025-04-12 09:47:03.127             2030
2025-04-12 09:47:03.127             {query_map[2030]}
2025-04-12 09:47:03.127             Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.127             335545297
2025-04-12 09:47:03.127
2025-04-12 09:47:03.127             2040
2025-04-12 09:47:03.127             {query_map[2040]}
2025-04-12 09:47:03.127             Value for TZM pattern is out of range [0, 59]
2025-04-12 09:47:03.127             335545297
2025-04-12 09:47:03.127
2025-04-12 09:47:03.127             2050
2025-04-12 09:47:03.127             {query_map[2050]}
2025-04-12 09:47:03.127             Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.127             335545297
2025-04-12 09:47:03.128
2025-04-12 09:47:03.128             2060
2025-04-12 09:47:03.128             {query_map[2060]}
2025-04-12 09:47:03.128             Value for TZM pattern is out of range [0, 59]
2025-04-12 09:47:03.128             335545297
2025-04-12 09:47:03.128
2025-04-12 09:47:03.128             2070
2025-04-12 09:47:03.128             {query_map[2070]}
2025-04-12 09:47:03.128             Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.128             335545297
2025-04-12 09:47:03.128
2025-04-12 09:47:03.128             3000
2025-04-12 09:47:03.128             {query_map[3000]}
2025-04-12 09:47:03.128             Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.128             335545297
2025-04-12 09:47:03.128
2025-04-12 09:47:03.128             3010
2025-04-12 09:47:03.128             {query_map[3010]}
2025-04-12 09:47:03.128             Cannot use "TZH" format with current date type
2025-04-12 09:47:03.128             335545296
2025-04-12 09:47:03.128
2025-04-12 09:47:03.129             3020
2025-04-12 09:47:03.129             {query_map[3020]}
2025-04-12 09:47:03.129             Cannot use "TZR" format with current date type
2025-04-12 09:47:03.129             335545296
2025-04-12 09:47:03.129
2025-04-12 09:47:03.129             3030
2025-04-12 09:47:03.129             {query_map[3030]}
2025-04-12 09:47:03.129             Cannot use "TZH" format with current date type
2025-04-12 09:47:03.129             335545296
2025-04-12 09:47:03.129
2025-04-12 09:47:03.129             3040
2025-04-12 09:47:03.129             {query_map[3040]}
2025-04-12 09:47:03.129             Cannot use "TZR" format with current date type
2025-04-12 09:47:03.129             335545296
2025-04-12 09:47:03.129         """
2025-04-12 09:47:03.129         act.expected_stdout = expected_out
2025-04-12 09:47:03.129         act.stdout = capsys.readouterr().out
2025-04-12 09:47:03.129 >       assert act.clean_stdout == act.clean_expected_stdout
2025-04-12 09:47:03.129 E       assert
2025-04-12 09:47:03.129 E           1000
2025-04-12 09:47:03.130 E           select cast('Apr' as date format 'Y     MON') from rdb$database
2025-04-12 09:47:03.130 E         - Cannot find value in input string for "Y" pattern
2025-04-12 09:47:03.130 E         - 335545315
2025-04-12 09:47:03.130 E         + Dynamic SQL Error
2025-04-12 09:47:03.130 E         + -SQL error code = -104
2025-04-12 09:47:03.130 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.130 E         + -format
2025-04-12 09:47:03.130 E         + 335544569
2025-04-12 09:47:03.130 E         + 335544436
2025-04-12 09:47:03.130 E         + 335544634
2025-04-12 09:47:03.130 E         + 335544382
2025-04-12 09:47:03.130 E           1010
2025-04-12 09:47:03.130 E           select cast('Apr' as date format 'YY    MON') from rdb$database
2025-04-12 09:47:03.130 E         - Cannot find value in input string for "YY" pattern
2025-04-12 09:47:03.130 E         - 335545315
2025-04-12 09:47:03.130 E         + Dynamic SQL Error
2025-04-12 09:47:03.130 E         + -SQL error code = -104
2025-04-12 09:47:03.130 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.130 E         + -format
2025-04-12 09:47:03.130 E         + 335544569
2025-04-12 09:47:03.131 E         + 335544436
2025-04-12 09:47:03.131 E         + 335544634
2025-04-12 09:47:03.131 E         + 335544382
2025-04-12 09:47:03.131 E           1020
2025-04-12 09:47:03.131 E           select cast('Apr' as date format 'YYY   MON') from rdb$database
2025-04-12 09:47:03.131 E         - Cannot find value in input string for "YYY" pattern
2025-04-12 09:47:03.131 E         - 335545315
2025-04-12 09:47:03.131 E         + Dynamic SQL Error
2025-04-12 09:47:03.131 E         + -SQL error code = -104
2025-04-12 09:47:03.131 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.131 E         + -format
2025-04-12 09:47:03.131 E         + 335544569
2025-04-12 09:47:03.131 E         + 335544436
2025-04-12 09:47:03.131 E         + 335544634
2025-04-12 09:47:03.131 E         + 335544382
2025-04-12 09:47:03.131 E           1030
2025-04-12 09:47:03.131 E           select cast('Apr' as date format 'YYYY  MON') from rdb$database
2025-04-12 09:47:03.131 E         - Cannot find value in input string for "YYYY" pattern
2025-04-12 09:47:03.131 E         - 335545315
2025-04-12 09:47:03.131 E         + Dynamic SQL Error
2025-04-12 09:47:03.132 E         + -SQL error code = -104
2025-04-12 09:47:03.132 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.132 E         + -format
2025-04-12 09:47:03.132 E         + 335544569
2025-04-12 09:47:03.132 E         + 335544436
2025-04-12 09:47:03.132 E         + 335544634
2025-04-12 09:47:03.132 E         + 335544382
2025-04-12 09:47:03.132 E           1040
2025-04-12 09:47:03.132 E           select cast('Apr' as date format 'YEAR  MON') from rdb$database
2025-04-12 09:47:03.132 E         - Cannot find value in input string for "YEAR" pattern
2025-04-12 09:47:03.132 E         - 335545315
2025-04-12 09:47:03.132 E         + Dynamic SQL Error
2025-04-12 09:47:03.132 E         + -SQL error code = -104
2025-04-12 09:47:03.132 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.132 E         + -format
2025-04-12 09:47:03.132 E         + 335544569
2025-04-12 09:47:03.132 E         + 335544436
2025-04-12 09:47:03.132 E         + 335544634
2025-04-12 09:47:03.132 E         + 335544382
2025-04-12 09:47:03.132 E           1050
2025-04-12 09:47:03.132 E           select cast('Apr' as date format 'RR    MON') from rdb$database
2025-04-12 09:47:03.133 E         - Cannot find value in input string for "RR" pattern
2025-04-12 09:47:03.133 E         - 335545315
2025-04-12 09:47:03.133 E         + Dynamic SQL Error
2025-04-12 09:47:03.133 E         + -SQL error code = -104
2025-04-12 09:47:03.133 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.133 E         + -format
2025-04-12 09:47:03.133 E         + 335544569
2025-04-12 09:47:03.133 E         + 335544436
2025-04-12 09:47:03.133 E         + 335544634
2025-04-12 09:47:03.133 E         + 335544382
2025-04-12 09:47:03.133 E           1060
2025-04-12 09:47:03.133 E           select cast('Apr' as date format 'RRRR  MON') from rdb$database
2025-04-12 09:47:03.133 E         - Cannot find value in input string for "RRRR" pattern
2025-04-12 09:47:03.133 E         - 335545315
2025-04-12 09:47:03.133 E         + Dynamic SQL Error
2025-04-12 09:47:03.133 E         + -SQL error code = -104
2025-04-12 09:47:03.133 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.133 E         + -format
2025-04-12 09:47:03.133 E         + 335544569
2025-04-12 09:47:03.133 E         + 335544436
2025-04-12 09:47:03.134 E         + 335544634
2025-04-12 09:47:03.134 E         + 335544382
2025-04-12 09:47:03.134 E           1070
2025-04-12 09:47:03.134 E           select cast('Apr' as date format 'MM    MON') from rdb$database
2025-04-12 09:47:03.134 E         - Cannot find value in input string for "MM" pattern
2025-04-12 09:47:03.134 E         - 335545315
2025-04-12 09:47:03.134 E         + Dynamic SQL Error
2025-04-12 09:47:03.134 E         + -SQL error code = -104
2025-04-12 09:47:03.134 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.134 E         + -format
2025-04-12 09:47:03.134 E         + 335544569
2025-04-12 09:47:03.134 E         + 335544436
2025-04-12 09:47:03.134 E         + 335544634
2025-04-12 09:47:03.134 E         + 335544382
2025-04-12 09:47:03.134 E           1080
2025-04-12 09:47:03.134 E           select cast('Apr' as date format 'DD    MON') from rdb$database
2025-04-12 09:47:03.134 E         - Cannot find value in input string for "DD" pattern
2025-04-12 09:47:03.134 E         - 335545315
2025-04-12 09:47:03.134 E         + Dynamic SQL Error
2025-04-12 09:47:03.134 E         + -SQL error code = -104
2025-04-12 09:47:03.134 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.135 E         + -format
2025-04-12 09:47:03.135 E         + 335544569
2025-04-12 09:47:03.135 E         + 335544436
2025-04-12 09:47:03.135 E         + 335544634
2025-04-12 09:47:03.135 E         + 335544382
2025-04-12 09:47:03.135 E           1090
2025-04-12 09:47:03.135 E           select cast('Apr' as date format 'J     MON') from rdb$database
2025-04-12 09:47:03.135 E         - Cannot find value in input string for "J" pattern
2025-04-12 09:47:03.135 E         - 335545315
2025-04-12 09:47:03.135 E         + Dynamic SQL Error
2025-04-12 09:47:03.135 E         + -SQL error code = -104
2025-04-12 09:47:03.135 E         + -Token unknown - line 1, column 27
2025-04-12 09:47:03.135 E         + -format
2025-04-12 09:47:03.135 E         + 335544569
2025-04-12 09:47:03.135 E         + 335544436
2025-04-12 09:47:03.135 E         + 335544634
2025-04-12 09:47:03.135 E         + 335544382
2025-04-12 09:47:03.135 E           2000
2025-04-12 09:47:03.136 E           select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
2025-04-12 09:47:03.136 E         - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 09:47:03.136 E         - 335545213
2025-04-12 09:47:03.136 E         + Dynamic SQL Error
2025-04-12 09:47:03.136 E         + -SQL error code = -104
2025-04-12 09:47:03.136 E         + -Token unknown - line 1, column 79
2025-04-12 09:47:03.136 E         + -format
2025-04-12 09:47:03.136 E         + 335544569
2025-04-12 09:47:03.136 E         + 335544436
2025-04-12 09:47:03.136 E         + 335544634
2025-04-12 09:47:03.136 E         + 335544382
2025-04-12 09:47:03.136 E           2010
2025-04-12 09:47:03.136 E           select cast('9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
2025-04-12 09:47:03.136 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.136 E         + Dynamic SQL Error
2025-04-12 09:47:03.136 E         + -SQL error code = -104
2025-04-12 09:47:03.136 E         + -Token unknown - line 1, column 79
2025-04-12 09:47:03.136 E         + -format
2025-04-12 09:47:03.136 E         - 335545297
2025-04-12 09:47:03.137 E         + 335544569
2025-04-12 09:47:03.137 E         + 335544436
2025-04-12 09:47:03.137 E         + 335544634
2025-04-12 09:47:03.137 E         + 335544382
2025-04-12 09:47:03.137 E           2020
2025-04-12 09:47:03.137 E           select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZH:TZM') from rdb$database
2025-04-12 09:47:03.137 E         - Invalid time zone offset: 2147483647 - must use format +/-hours:minutes and be between -14:00 and +14:00
2025-04-12 09:47:03.137 E         - 335545213
2025-04-12 09:47:03.137 E         + Dynamic SQL Error
2025-04-12 09:47:03.137 E         + -SQL error code = -104
2025-04-12 09:47:03.137 E         + -Token unknown - line 1, column 80
2025-04-12 09:47:03.137 E         + -format
2025-04-12 09:47:03.137 E         + 335544569
2025-04-12 09:47:03.137 E         + 335544436
2025-04-12 09:47:03.137 E         + 335544634
2025-04-12 09:47:03.137 E         + 335544382
2025-04-12 09:47:03.137 E           2030
2025-04-12 09:47:03.138 E           select cast('-9999999999999999999999999999999999999:00' as time with time zone format 'TZR') from rdb$database
2025-04-12 09:47:03.138 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.138 E         + Dynamic SQL Error
2025-04-12 09:47:03.138 E         + -SQL error code = -104
2025-04-12 09:47:03.138 E         + -Token unknown - line 1, column 80
2025-04-12 09:47:03.138 E         + -format
2025-04-12 09:47:03.138 E         - 335545297
2025-04-12 09:47:03.138 E         + 335544569
2025-04-12 09:47:03.138 E         + 335544436
2025-04-12 09:47:03.138 E         + 335544634
2025-04-12 09:47:03.138 E         + 335544382
2025-04-12 09:47:03.138 E           2040
2025-04-12 09:47:03.138 E           select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database
2025-04-12 09:47:03.138 E         - Value for TZM pattern is out of range [0, 59]
2025-04-12 09:47:03.138 E         + Dynamic SQL Error
2025-04-12 09:47:03.138 E         + -SQL error code = -104
2025-04-12 09:47:03.139 E         + -Token unknown - line 1, column 79
2025-04-12 09:47:03.139 E         + -format
2025-04-12 09:47:03.139 E         - 335545297
2025-04-12 09:47:03.139 E         + 335544569
2025-04-12 09:47:03.139 E         + 335544436
2025-04-12 09:47:03.139 E         + 335544634
2025-04-12 09:47:03.139 E         + 335544382
2025-04-12 09:47:03.139 E           2050
2025-04-12 09:47:03.139 E           select cast('00:9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
2025-04-12 09:47:03.139 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.139 E         + Dynamic SQL Error
2025-04-12 09:47:03.139 E         + -SQL error code = -104
2025-04-12 09:47:03.139 E         + -Token unknown - line 1, column 79
2025-04-12 09:47:03.139 E         + -format
2025-04-12 09:47:03.139 E         - 335545297
2025-04-12 09:47:03.139 E         + 335544569
2025-04-12 09:47:03.140 E         + 335544436
2025-04-12 09:47:03.140 E         + 335544634
2025-04-12 09:47:03.140 E         + 335544382
2025-04-12 09:47:03.140 E           2060
2025-04-12 09:47:03.140 E           select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZH:TZM') from rdb$database;
2025-04-12 09:47:03.140 E         - Value for TZM pattern is out of range [0, 59]
2025-04-12 09:47:03.140 E         + Dynamic SQL Error
2025-04-12 09:47:03.140 E         + -SQL error code = -104
2025-04-12 09:47:03.140 E         + -Token unknown - line 1, column 80
2025-04-12 09:47:03.140 E         + -format
2025-04-12 09:47:03.140 E         - 335545297
2025-04-12 09:47:03.140 E         + 335544569
2025-04-12 09:47:03.140 E         + 335544436
2025-04-12 09:47:03.140 E         + 335544634
2025-04-12 09:47:03.140 E         + 335544382
2025-04-12 09:47:03.140 E           2070
2025-04-12 09:47:03.140 E           select cast('00:-9999999999999999999999999999999999999' as time with time zone format 'TZR') from rdb$database
2025-04-12 09:47:03.140 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.141 E         + Dynamic SQL Error
2025-04-12 09:47:03.141 E         + -SQL error code = -104
2025-04-12 09:47:03.141 E         + -Token unknown - line 1, column 80
2025-04-12 09:47:03.141 E         + -format
2025-04-12 09:47:03.141 E         - 335545297
2025-04-12 09:47:03.141 E         + 335544569
2025-04-12 09:47:03.141 E         + 335544436
2025-04-12 09:47:03.141 E         + 335544634
2025-04-12 09:47:03.141 E         + 335544382
2025-04-12 09:47:03.141 E           3000
2025-04-12 09:47:03.141 E           select cast('00:60' as time with time zone format 'TZR') from rdb$database
2025-04-12 09:47:03.141 E         - Value for TZR pattern is out of range [0, 59]
2025-04-12 09:47:03.141 E         + Dynamic SQL Error
2025-04-12 09:47:03.141 E         + -SQL error code = -104
2025-04-12 09:47:03.141 E         + -Token unknown - line 1, column 44
2025-04-12 09:47:03.141 E         + -format
2025-04-12 09:47:03.141 E         - 335545297
2025-04-12 09:47:03.142 E         + 335544569
2025-04-12 09:47:03.142 E         + 335544436
2025-04-12 09:47:03.142 E         + 335544634
2025-04-12 09:47:03.142 E         + 335544382
2025-04-12 09:47:03.142 E           3010
2025-04-12 09:47:03.142 E           select cast('15:00' as time format 'TZH:TZM') from rdb$database
2025-04-12 09:47:03.142 E         - Cannot use "TZH" format with current date type
2025-04-12 09:47:03.142 E         + Dynamic SQL Error
2025-04-12 09:47:03.142 E         + -SQL error code = -104
2025-04-12 09:47:03.142 E         + -Token unknown - line 1, column 29
2025-04-12 09:47:03.142 E         + -format
2025-04-12 09:47:03.142 E         - 335545296
2025-04-12 09:47:03.142 E         + 335544569
2025-04-12 09:47:03.142 E         + 335544436
2025-04-12 09:47:03.142 E         + 335544634
2025-04-12 09:47:03.142 E         + 335544382
2025-04-12 09:47:03.142 E           3020
2025-04-12 09:47:03.143 E           select cast('15:00' as time format 'TZR') from rdb$database
2025-04-12 09:47:03.143 E         - Cannot use "TZR" format with current date type
2025-04-12 09:47:03.143 E         + Dynamic SQL Error
2025-04-12 09:47:03.143 E         + -SQL error code = -104
2025-04-12 09:47:03.143 E         + -Token unknown - line 1, column 29
2025-04-12 09:47:03.143 E         + -format
2025-04-12 09:47:03.143 E         - 335545296
2025-04-12 09:47:03.143 E         + 335544569
2025-04-12 09:47:03.143 E         + 335544436
2025-04-12 09:47:03.143 E         + 335544634
2025-04-12 09:47:03.143 E         + 335544382
2025-04-12 09:47:03.143 E           3030
2025-04-12 09:47:03.143 E           select cast('-15:00' as time format 'TZH:TZM') from rdb$database
2025-04-12 09:47:03.143 E         - Cannot use "TZH" format with current date type
2025-04-12 09:47:03.143 E         + Dynamic SQL Error
2025-04-12 09:47:03.143 E         + -SQL error code = -104
2025-04-12 09:47:03.143 E         + -Token unknown - line 1, column 30
2025-04-12 09:47:03.143 E         + -format
2025-04-12 09:47:03.144 E         - 335545296
2025-04-12 09:47:03.144 E         + 335544569
2025-04-12 09:47:03.144 E         + 335544436
2025-04-12 09:47:03.144 E         + 335544634
2025-04-12 09:47:03.144 E         + 335544382
2025-04-12 09:47:03.144 E           3040
2025-04-12 09:47:03.144 E           select cast('-15:00' as time format 'TZR') from rdb$database
2025-04-12 09:47:03.144 E         - Cannot use "TZR" format with current date type
2025-04-12 09:47:03.144 E         + Dynamic SQL Error
2025-04-12 09:47:03.144 E         + -SQL error code = -104
2025-04-12 09:47:03.144 E         + -Token unknown - line 1, column 30
2025-04-12 09:47:03.144 E         + -format
2025-04-12 09:47:03.144 E         - 335545296
2025-04-12 09:47:03.144 E         + 335544569
2025-04-12 09:47:03.144 E         + 335544436
2025-04-12 09:47:03.144 E         + 335544634
2025-04-12 09:47:03.145 E         + 335544382
2025-04-12 09:47:03.145
2025-04-12 09:47:03.145 tests\bugs\gh_8501_test.py:218: AssertionError
2025-04-12 09:47:03.145 ---------------------------- Captured stdout setup ----------------------------
2025-04-12 09:47:03.145 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11601\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 4.0.6.3195 2025.03.28 b9faf F F 879 663 2025.04.12 06:29:59.364 2025.04.12 06:30:00.243 2025.04.12 05:29:59.004 2025.04.12 05:29:59.667

Elapsed time, ms. Chart for last 1 runs:

Last commits information (all timestamps in UTC):