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
|