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
|