2 @message |
assert
UNLIST_BIGINT_01 -9223372036854775808
UNLIST_BIGINT_01 9223372036854775807
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
UNLIST_BOOLEAN_01 <true>
UNLIST_BOOLEAN_01 <false>
Statement failed, SQLSTATE = 22018
conversion error from string "right"
UNLIST_BINARY_01 3131313100000000
UNLIST_BINARY_01 3132333435363738
UNLIST_BINARY_02 7465787400000000
UNLIST_BINARY_02 7465787474657874
UNLIST_CHAR_01 text
UNLIST_CHAR_01 texttext
UNLIST_CHAR_01 1243
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 1, actual 4
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -842
-Positive value expected
-At line 2, column 48
UNLIST_DATE_01 0001-01-01
UNLIST_DATE_01 9999-12-31
UNLIST_DATE_01 2315-08-06
UNLIST_DATE_01 1245-12-01
UNLIST_DATE_01 5555-12-28
Statement failed, SQLSTATE = 22008
value exceeds the range for valid dates
Statement failed, SQLSTATE = 22018
conversion error from string "1.01.10000"
EXTRACT 1
UNLIST_DECIMAL_01 4.00
UNLIST_DECIMAL_01 2.00
UNLIST_DECIMAL_01 5.83
UNLIST_DECIMAL_01 23.01
UNLIST_DECIMAL_02 55555555555555555555555555555555555555
Statement failed, SQLSTATE = HY104
Dynamic SQL Error
-SQL error code = -842
-Precision must be from 1 to 38
-At line 2, column 97
UNLIST_DECFLOAT16_01 4
UNLIST_DECFLOAT16_01 2.00
UNLIST_DECFLOAT16_01 5.83
UNLIST_DECFLOAT16_01 23.00000000000001
UNLIST_DECFLOAT16_01 24.00000000000001
UNLIST_DECFLOAT34_01 4
UNLIST_DECFLOAT34_01 2.00
UNLIST_DECFLOAT34_01 5.83
UNLIST_DECFLOAT34_01 23.00000000000001000000000000000001
UNLIST_DECFLOAT34_01 24.00000000000001000000000000000001
UNLIST_DOUBLE_01 0.000000000000000
UNLIST_DOUBLE_01 -0.000000000000000
UNLIST_DOUBLE_01 9.900000000000000e-307
UNLIST_DOUBLE_01 1.797693134862316e+308
UNLIST_DOUBLE_01 4.000000000000000
UNLIST_DOUBLE_01 2.000000000000000
UNLIST_DOUBLE_01 5.830000000000000
UNLIST_DOUBLE_01 23.00000000000001
UNLIST_DOUBLE_01 24.00000000000001
UNLIST_FLOAT_01 4
UNLIST_FLOAT_01 2
UNLIST_FLOAT_01 5.8299999
UNLIST_FLOAT_01 23.000002
UNLIST_FLOAT_01 24.000002
UNLIST_INT_01 -2147483648
UNLIST_INT_01 2147483647
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
UNLIST_INT128_01 -170141183460469231731687303715884105728
UNLIST_INT128_01 170141183460469231731687303715884105727
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
UNLIST_NCHAR_01 qwer
UNLIST_NCHAR_01 asdf
UNLIST_NCHAR_01 zxcv
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 1, actual 4
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -842
-Positive value expected
-At line 2, column 49
UNLIST_VARCHAR_01 text
UNLIST_VARCHAR_01 texttext
UNLIST_VARCHAR_01 1243
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 8, actual 12
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 2, column 50
-)
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -842
-Positive value expected
-At line 2, column 51
UNLIST_NVARCHAR_01 text
UNLIST_NVARCHAR_01 texttext
UNLIST_NVARCHAR_01 1243
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 8, actual 12
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 2, column 56
-)
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -842
-Positive value expected
-At line 2, column 57
UNLIST_SMALLINT_01 -32768
UNLIST_SMALLINT_01 32767
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
- UNLIST_TIME_01 00:00:00.0000
+ UNLIST_TIME_01 00:00:0
- UNLIST_TIME_01 23:59:59.9999
+ UNLIST_TIME_01 23:59:5
Statement failed, SQLSTATE = 22018
conversion error from string "00:00:00.10000"
Statement failed, SQLSTATE = 22018
conversion error from string "00"
Statement failed, SQLSTATE = 22018
conversion error from string "10000"
- UNLIST_TIME_05 23:59:59.0000
+ UNLIST_TIME_05 23:59:5
UNLIST_TMTZ_01 00:00:00.0000 Indian/Cocos
UNLIST_TMTZ_01 23:59:59.9999 Indian/Cocos
Statement failed, SQLSTATE = 22018
conversion error from string "00:00:00.10000"
Statement failed, SQLSTATE = 22018
conversion error from string "00"
Statement failed, SQLSTATE = 22018
conversion error from string "10000"
UNLIST_TMTZ_05 23:59:59.0000 Indian/Cocos
UNLIST_TMTZ_06 23:59:59.9999 Europe/Moscow
UNLIST_TMTZ_06 23:59:59.9999 -03:00
UNLIST_TMTZ_06 23:59:59.9999 GMT
UNLIST_TMTZ_06 23:59:59.9999 AET
UNLIST_TMTZ_06 23:59:59.9999 ART
UNLIST_TMTZ_06 23:59:59.9999 Etc/GMT+5
UNLIST_TMTZ_06 23:59:59.9999 America/Kentucky/Monticello
UNLIST_TIMESTAMP_01 2315-08-06 00:00:00.0000
UNLIST_TIMESTAMP_01 1245-12-01 23:59:59.9999
Statement failed, SQLSTATE = 22018
conversion error from string "00:00:00.0000,1245-12-01"
Statement failed, SQLSTATE = 22018
conversion error from string "8/06/2315 00"
Statement failed, SQLSTATE = 22018
conversion error from string "00:00:00.0000"
UNLIST_TSTZ_01 2315-08-06 00:00:00.0000 Indian/Cocos
UNLIST_TSTZ_01 1245-12-01 23:59:59.9999 Indian/Cocos
Statement failed, SQLSTATE = 22018
conversion error from string "00:00:00.0000,1245-12-01"
Statement failed, SQLSTATE = 22018
conversion error from string "8/06/2315 00"
Statement failed, SQLSTATE = 22018
conversion error from string "00:00:00.0000"
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 Europe/Moscow
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 -03:00
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 GMT
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 AET
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 ART
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 Etc/GMT+5
UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 America/Kentucky/Monticello
UNLIST_VARBIN_01 31313131
UNLIST_VARBIN_01 3132333435363738
UNLIST_VARBIN_02 74657874
UNLIST_VARBIN_02 7465787474657874
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 8, actual 12
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 2, column 52
-)
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -842
-Positive value expected
-At line 2, column 53
UNLIST_BLOB_01 0:1
1111
UNLIST_BLOB_01 0:2
12345678
UNLIST_BLOB_01 0:3
abcdefghijklmnopqrstuvwxyz
UNLIST_BLOB_02 0:7
19
UNLIST_BLOB_02 0:8
20
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 2, column 39
-)
UNLIST_DOMAIN_01 text
UNLIST_DOMAIN_01 texttext
UNLIST_DOMAIN_01 1243
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 8, actual 12
LOG DETAILS:
2025-07-01 05:56:22.135
2025-07-01 05:56:22.149 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-01 05:56:22.159
2025-07-01 05:56:22.166 @pytest.mark.version('>=6.0')
2025-07-01 05:56:22.178 def test_1(act: Action):
2025-07-01 05:56:22.189 act.expected_stdout = expected_stdout
2025-07-01 05:56:22.202 act.execute(combine_output = True)
2025-07-01 05:56:22.213 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-01 05:56:22.224 E assert
2025-07-01 05:56:22.236 E UNLIST_BIGINT_01 -9223372036854775808
2025-07-01 05:56:22.247 E UNLIST_BIGINT_01 9223372036854775807
2025-07-01 05:56:22.258 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:22.270 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.282 E -numeric value is out of range
2025-07-01 05:56:22.291 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:22.303 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.311 E -numeric value is out of range
2025-07-01 05:56:22.318 E UNLIST_BOOLEAN_01 <true>
2025-07-01 05:56:22.324 E UNLIST_BOOLEAN_01 <false>
2025-07-01 05:56:22.331 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:22.337 E conversion error from string "right"
2025-07-01 05:56:22.344 E UNLIST_BINARY_01 3131313100000000
2025-07-01 05:56:22.351 E UNLIST_BINARY_01 3132333435363738
2025-07-01 05:56:22.358 E UNLIST_BINARY_02 7465787400000000
2025-07-01 05:56:22.369 E UNLIST_BINARY_02 7465787474657874
2025-07-01 05:56:22.379 E UNLIST_CHAR_01 text
2025-07-01 05:56:22.388 E UNLIST_CHAR_01 texttext
2025-07-01 05:56:22.396 E UNLIST_CHAR_01 1243
2025-07-01 05:56:22.409 E Statement failed, SQLSTATE = 22001
2025-07-01 05:56:22.420 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.428 E -string right truncation
2025-07-01 05:56:22.435 E -expected length 1, actual 4
2025-07-01 05:56:22.441 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:22.446 E Dynamic SQL Error
2025-07-01 05:56:22.451 E -SQL error code = -842
2025-07-01 05:56:22.456 E -Positive value expected
2025-07-01 05:56:22.461 E -At line 2, column 48
2025-07-01 05:56:22.466 E UNLIST_DATE_01 0001-01-01
2025-07-01 05:56:22.471 E UNLIST_DATE_01 9999-12-31
2025-07-01 05:56:22.475 E UNLIST_DATE_01 2315-08-06
2025-07-01 05:56:22.480 E UNLIST_DATE_01 1245-12-01
2025-07-01 05:56:22.485 E UNLIST_DATE_01 5555-12-28
2025-07-01 05:56:22.490 E Statement failed, SQLSTATE = 22008
2025-07-01 05:56:22.495 E value exceeds the range for valid dates
2025-07-01 05:56:22.502 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:22.513 E conversion error from string "1.01.10000"
2025-07-01 05:56:22.523 E EXTRACT 1
2025-07-01 05:56:22.530 E UNLIST_DECIMAL_01 4.00
2025-07-01 05:56:22.539 E UNLIST_DECIMAL_01 2.00
2025-07-01 05:56:22.548 E UNLIST_DECIMAL_01 5.83
2025-07-01 05:56:22.553 E UNLIST_DECIMAL_01 23.01
2025-07-01 05:56:22.559 E UNLIST_DECIMAL_02 55555555555555555555555555555555555555
2025-07-01 05:56:22.565 E Statement failed, SQLSTATE = HY104
2025-07-01 05:56:22.571 E Dynamic SQL Error
2025-07-01 05:56:22.578 E -SQL error code = -842
2025-07-01 05:56:22.587 E -Precision must be from 1 to 38
2025-07-01 05:56:22.596 E -At line 2, column 97
2025-07-01 05:56:22.603 E UNLIST_DECFLOAT16_01 4
2025-07-01 05:56:22.611 E UNLIST_DECFLOAT16_01 2.00
2025-07-01 05:56:22.617 E UNLIST_DECFLOAT16_01 5.83
2025-07-01 05:56:22.624 E UNLIST_DECFLOAT16_01 23.00000000000001
2025-07-01 05:56:22.630 E UNLIST_DECFLOAT16_01 24.00000000000001
2025-07-01 05:56:22.637 E UNLIST_DECFLOAT34_01 4
2025-07-01 05:56:22.646 E UNLIST_DECFLOAT34_01 2.00
2025-07-01 05:56:22.654 E UNLIST_DECFLOAT34_01 5.83
2025-07-01 05:56:22.660 E UNLIST_DECFLOAT34_01 23.00000000000001000000000000000001
2025-07-01 05:56:22.666 E UNLIST_DECFLOAT34_01 24.00000000000001000000000000000001
2025-07-01 05:56:22.670 E UNLIST_DOUBLE_01 0.000000000000000
2025-07-01 05:56:22.676 E UNLIST_DOUBLE_01 -0.000000000000000
2025-07-01 05:56:22.682 E UNLIST_DOUBLE_01 9.900000000000000e-307
2025-07-01 05:56:22.689 E UNLIST_DOUBLE_01 1.797693134862316e+308
2025-07-01 05:56:22.696 E UNLIST_DOUBLE_01 4.000000000000000
2025-07-01 05:56:22.702 E UNLIST_DOUBLE_01 2.000000000000000
2025-07-01 05:56:22.713 E UNLIST_DOUBLE_01 5.830000000000000
2025-07-01 05:56:22.723 E UNLIST_DOUBLE_01 23.00000000000001
2025-07-01 05:56:22.730 E UNLIST_DOUBLE_01 24.00000000000001
2025-07-01 05:56:22.739 E UNLIST_FLOAT_01 4
2025-07-01 05:56:22.749 E UNLIST_FLOAT_01 2
2025-07-01 05:56:22.758 E UNLIST_FLOAT_01 5.8299999
2025-07-01 05:56:22.764 E UNLIST_FLOAT_01 23.000002
2025-07-01 05:56:22.771 E UNLIST_FLOAT_01 24.000002
2025-07-01 05:56:22.778 E UNLIST_INT_01 -2147483648
2025-07-01 05:56:22.787 E UNLIST_INT_01 2147483647
2025-07-01 05:56:22.795 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:22.801 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.807 E -numeric value is out of range
2025-07-01 05:56:22.813 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:22.819 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.828 E -numeric value is out of range
2025-07-01 05:56:22.836 E UNLIST_INT128_01 -170141183460469231731687303715884105728
2025-07-01 05:56:22.843 E UNLIST_INT128_01 170141183460469231731687303715884105727
2025-07-01 05:56:22.849 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:22.855 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.860 E -numeric value is out of range
2025-07-01 05:56:22.865 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:22.870 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.874 E -numeric value is out of range
2025-07-01 05:56:22.879 E UNLIST_NCHAR_01 qwer
2025-07-01 05:56:22.887 E UNLIST_NCHAR_01 asdf
2025-07-01 05:56:22.894 E UNLIST_NCHAR_01 zxcv
2025-07-01 05:56:22.905 E Statement failed, SQLSTATE = 22001
2025-07-01 05:56:22.915 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:22.922 E -string right truncation
2025-07-01 05:56:22.929 E -expected length 1, actual 4
2025-07-01 05:56:22.942 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:22.949 E Dynamic SQL Error
2025-07-01 05:56:22.955 E -SQL error code = -842
2025-07-01 05:56:22.963 E -Positive value expected
2025-07-01 05:56:22.969 E -At line 2, column 49
2025-07-01 05:56:22.974 E UNLIST_VARCHAR_01 text
2025-07-01 05:56:22.980 E UNLIST_VARCHAR_01 texttext
2025-07-01 05:56:22.984 E UNLIST_VARCHAR_01 1243
2025-07-01 05:56:22.989 E Statement failed, SQLSTATE = 22001
2025-07-01 05:56:22.995 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:23.002 E -string right truncation
2025-07-01 05:56:23.013 E -expected length 8, actual 12
2025-07-01 05:56:23.025 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:23.034 E Dynamic SQL Error
2025-07-01 05:56:23.043 E -SQL error code = -104
2025-07-01 05:56:23.052 E -Token unknown - line 2, column 50
2025-07-01 05:56:23.062 E -)
2025-07-01 05:56:23.074 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:23.086 E Dynamic SQL Error
2025-07-01 05:56:23.097 E -SQL error code = -842
2025-07-01 05:56:23.110 E -Positive value expected
2025-07-01 05:56:23.121 E -At line 2, column 51
2025-07-01 05:56:23.133 E UNLIST_NVARCHAR_01 text
2025-07-01 05:56:23.145 E UNLIST_NVARCHAR_01 texttext
2025-07-01 05:56:23.156 E UNLIST_NVARCHAR_01 1243
2025-07-01 05:56:23.165 E Statement failed, SQLSTATE = 22001
2025-07-01 05:56:23.173 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:23.179 E -string right truncation
2025-07-01 05:56:23.187 E -expected length 8, actual 12
2025-07-01 05:56:23.194 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:23.201 E Dynamic SQL Error
2025-07-01 05:56:23.212 E -SQL error code = -104
2025-07-01 05:56:23.223 E -Token unknown - line 2, column 56
2025-07-01 05:56:23.231 E -)
2025-07-01 05:56:23.239 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:23.250 E Dynamic SQL Error
2025-07-01 05:56:23.261 E -SQL error code = -842
2025-07-01 05:56:23.271 E -Positive value expected
2025-07-01 05:56:23.279 E -At line 2, column 57
2025-07-01 05:56:23.287 E UNLIST_SMALLINT_01 -32768
2025-07-01 05:56:23.299 E UNLIST_SMALLINT_01 32767
2025-07-01 05:56:23.311 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:23.320 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:23.331 E -numeric value is out of range
2025-07-01 05:56:23.342 E Statement failed, SQLSTATE = 22003
2025-07-01 05:56:23.352 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:23.361 E -numeric value is out of range
2025-07-01 05:56:23.368 E - UNLIST_TIME_01 00:00:00.0000
2025-07-01 05:56:23.381 E + UNLIST_TIME_01 00:00:0
2025-07-01 05:56:23.386 E - UNLIST_TIME_01 23:59:59.9999
2025-07-01 05:56:23.398 E + UNLIST_TIME_01 23:59:5
2025-07-01 05:56:23.408 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.418 E conversion error from string "00:00:00.10000"
2025-07-01 05:56:23.425 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.431 E conversion error from string "00"
2025-07-01 05:56:23.437 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.442 E conversion error from string "10000"
2025-07-01 05:56:23.447 E - UNLIST_TIME_05 23:59:59.0000
2025-07-01 05:56:23.457 E + UNLIST_TIME_05 23:59:5
2025-07-01 05:56:23.463 E UNLIST_TMTZ_01 00:00:00.0000 Indian/Cocos
2025-07-01 05:56:23.467 E UNLIST_TMTZ_01 23:59:59.9999 Indian/Cocos
2025-07-01 05:56:23.473 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.478 E conversion error from string "00:00:00.10000"
2025-07-01 05:56:23.488 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.498 E conversion error from string "00"
2025-07-01 05:56:23.504 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.510 E conversion error from string "10000"
2025-07-01 05:56:23.516 E UNLIST_TMTZ_05 23:59:59.0000 Indian/Cocos
2025-07-01 05:56:23.526 E UNLIST_TMTZ_06 23:59:59.9999 Europe/Moscow
2025-07-01 05:56:23.536 E UNLIST_TMTZ_06 23:59:59.9999 -03:00
2025-07-01 05:56:23.548 E UNLIST_TMTZ_06 23:59:59.9999 GMT
2025-07-01 05:56:23.558 E UNLIST_TMTZ_06 23:59:59.9999 AET
2025-07-01 05:56:23.569 E UNLIST_TMTZ_06 23:59:59.9999 ART
2025-07-01 05:56:23.581 E UNLIST_TMTZ_06 23:59:59.9999 Etc/GMT+5
2025-07-01 05:56:23.594 E UNLIST_TMTZ_06 23:59:59.9999 America/Kentucky/Monticello
2025-07-01 05:56:23.605 E UNLIST_TIMESTAMP_01 2315-08-06 00:00:00.0000
2025-07-01 05:56:23.615 E UNLIST_TIMESTAMP_01 1245-12-01 23:59:59.9999
2025-07-01 05:56:23.622 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.629 E conversion error from string "00:00:00.0000,1245-12-01"
2025-07-01 05:56:23.635 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.641 E conversion error from string "8/06/2315 00"
2025-07-01 05:56:23.646 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.652 E conversion error from string "00:00:00.0000"
2025-07-01 05:56:23.658 E UNLIST_TSTZ_01 2315-08-06 00:00:00.0000 Indian/Cocos
2025-07-01 05:56:23.664 E UNLIST_TSTZ_01 1245-12-01 23:59:59.9999 Indian/Cocos
2025-07-01 05:56:23.671 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.676 E conversion error from string "00:00:00.0000,1245-12-01"
2025-07-01 05:56:23.682 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.693 E conversion error from string "8/06/2315 00"
2025-07-01 05:56:23.702 E Statement failed, SQLSTATE = 22018
2025-07-01 05:56:23.710 E conversion error from string "00:00:00.0000"
2025-07-01 05:56:23.718 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 Europe/Moscow
2025-07-01 05:56:23.726 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 -03:00
2025-07-01 05:56:23.733 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 GMT
2025-07-01 05:56:23.740 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 AET
2025-07-01 05:56:23.746 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 ART
2025-07-01 05:56:23.756 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 Etc/GMT+5
2025-07-01 05:56:23.765 E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 America/Kentucky/Monticello
2025-07-01 05:56:23.772 E UNLIST_VARBIN_01 31313131
2025-07-01 05:56:23.778 E UNLIST_VARBIN_01 3132333435363738
2025-07-01 05:56:23.787 E UNLIST_VARBIN_02 74657874
2025-07-01 05:56:23.795 E UNLIST_VARBIN_02 7465787474657874
2025-07-01 05:56:23.802 E Statement failed, SQLSTATE = 22001
2025-07-01 05:56:23.809 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:23.814 E -string right truncation
2025-07-01 05:56:23.826 E -expected length 8, actual 12
2025-07-01 05:56:23.836 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:23.843 E Dynamic SQL Error
2025-07-01 05:56:23.850 E -SQL error code = -104
2025-07-01 05:56:23.857 E -Token unknown - line 2, column 52
2025-07-01 05:56:23.863 E -)
2025-07-01 05:56:23.869 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:23.874 E Dynamic SQL Error
2025-07-01 05:56:23.888 E -SQL error code = -842
2025-07-01 05:56:23.899 E -Positive value expected
2025-07-01 05:56:23.912 E -At line 2, column 53
2025-07-01 05:56:23.921 E UNLIST_BLOB_01 0:1
2025-07-01 05:56:23.929 E 1111
2025-07-01 05:56:23.937 E UNLIST_BLOB_01 0:2
2025-07-01 05:56:23.943 E 12345678
2025-07-01 05:56:23.949 E UNLIST_BLOB_01 0:3
2025-07-01 05:56:23.955 E abcdefghijklmnopqrstuvwxyz
2025-07-01 05:56:23.963 E UNLIST_BLOB_02 0:7
2025-07-01 05:56:23.973 E 19
2025-07-01 05:56:23.982 E UNLIST_BLOB_02 0:8
2025-07-01 05:56:23.989 E 20
2025-07-01 05:56:23.997 E Statement failed, SQLSTATE = 42000
2025-07-01 05:56:24.010 E Dynamic SQL Error
2025-07-01 05:56:24.020 E -SQL error code = -104
2025-07-01 05:56:24.028 E -Token unknown - line 2, column 39
2025-07-01 05:56:24.035 E -)
2025-07-01 05:56:24.041 E UNLIST_DOMAIN_01 text
2025-07-01 05:56:24.047 E UNLIST_DOMAIN_01 texttext
2025-07-01 05:56:24.055 E UNLIST_DOMAIN_01 1243
2025-07-01 05:56:24.065 E Statement failed, SQLSTATE = 22001
2025-07-01 05:56:24.075 E arithmetic exception, numeric overflow, or string truncation
2025-07-01 05:56:24.081 E -string right truncation
2025-07-01 05:56:24.086 E -expected length 8, actual 12
2025-07-01 05:56:24.091
2025-07-01 05:56:24.095 tests/functional/intfunc/unlist/unlist_returning_types_test.py:479: AssertionError
2025-07-01 05:56:24.100 ---------------------------- Captured stdout setup -----------------------------
2025-07-01 05:56:24.105 Creating db: localhost:/var/tmp/qa_2024/test_12286/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]>
@pytest.mark.version('>=6.0')
def test_1(act: Action):
act.expected_stdout = expected_stdout
act.execute(combine_output = True)
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E UNLIST_BIGINT_01 -9223372036854775808
E UNLIST_BIGINT_01 9223372036854775807
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E UNLIST_BOOLEAN_01 <true>
E UNLIST_BOOLEAN_01 <false>
E Statement failed, SQLSTATE = 22018
E conversion error from string "right"
E UNLIST_BINARY_01 3131313100000000
E UNLIST_BINARY_01 3132333435363738
E UNLIST_BINARY_02 7465787400000000
E UNLIST_BINARY_02 7465787474657874
E UNLIST_CHAR_01 text
E UNLIST_CHAR_01 texttext
E UNLIST_CHAR_01 1243
E Statement failed, SQLSTATE = 22001
E arithmetic exception, numeric overflow, or string truncation
E -string right truncation
E -expected length 1, actual 4
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -842
E -Positive value expected
E -At line 2, column 48
E UNLIST_DATE_01 0001-01-01
E UNLIST_DATE_01 9999-12-31
E UNLIST_DATE_01 2315-08-06
E UNLIST_DATE_01 1245-12-01
E UNLIST_DATE_01 5555-12-28
E Statement failed, SQLSTATE = 22008
E value exceeds the range for valid dates
E Statement failed, SQLSTATE = 22018
E conversion error from string "1.01.10000"
E EXTRACT 1
E UNLIST_DECIMAL_01 4.00
E UNLIST_DECIMAL_01 2.00
E UNLIST_DECIMAL_01 5.83
E UNLIST_DECIMAL_01 23.01
E UNLIST_DECIMAL_02 55555555555555555555555555555555555555
E Statement failed, SQLSTATE = HY104
E Dynamic SQL Error
E -SQL error code = -842
E -Precision must be from 1 to 38
E -At line 2, column 97
E UNLIST_DECFLOAT16_01 4
E UNLIST_DECFLOAT16_01 2.00
E UNLIST_DECFLOAT16_01 5.83
E UNLIST_DECFLOAT16_01 23.00000000000001
E UNLIST_DECFLOAT16_01 24.00000000000001
E UNLIST_DECFLOAT34_01 4
E UNLIST_DECFLOAT34_01 2.00
E UNLIST_DECFLOAT34_01 5.83
E UNLIST_DECFLOAT34_01 23.00000000000001000000000000000001
E UNLIST_DECFLOAT34_01 24.00000000000001000000000000000001
E UNLIST_DOUBLE_01 0.000000000000000
E UNLIST_DOUBLE_01 -0.000000000000000
E UNLIST_DOUBLE_01 9.900000000000000e-307
E UNLIST_DOUBLE_01 1.797693134862316e+308
E UNLIST_DOUBLE_01 4.000000000000000
E UNLIST_DOUBLE_01 2.000000000000000
E UNLIST_DOUBLE_01 5.830000000000000
E UNLIST_DOUBLE_01 23.00000000000001
E UNLIST_DOUBLE_01 24.00000000000001
E UNLIST_FLOAT_01 4
E UNLIST_FLOAT_01 2
E UNLIST_FLOAT_01 5.8299999
E UNLIST_FLOAT_01 23.000002
E UNLIST_FLOAT_01 24.000002
E UNLIST_INT_01 -2147483648
E UNLIST_INT_01 2147483647
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E UNLIST_INT128_01 -170141183460469231731687303715884105728
E UNLIST_INT128_01 170141183460469231731687303715884105727
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E UNLIST_NCHAR_01 qwer
E UNLIST_NCHAR_01 asdf
E UNLIST_NCHAR_01 zxcv
E Statement failed, SQLSTATE = 22001
E arithmetic exception, numeric overflow, or string truncation
E -string right truncation
E -expected length 1, actual 4
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -842
E -Positive value expected
E -At line 2, column 49
E UNLIST_VARCHAR_01 text
E UNLIST_VARCHAR_01 texttext
E UNLIST_VARCHAR_01 1243
E Statement failed, SQLSTATE = 22001
E arithmetic exception, numeric overflow, or string truncation
E -string right truncation
E -expected length 8, actual 12
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -104
E -Token unknown - line 2, column 50
E -)
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -842
E -Positive value expected
E -At line 2, column 51
E UNLIST_NVARCHAR_01 text
E UNLIST_NVARCHAR_01 texttext
E UNLIST_NVARCHAR_01 1243
E Statement failed, SQLSTATE = 22001
E arithmetic exception, numeric overflow, or string truncation
E -string right truncation
E -expected length 8, actual 12
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -104
E -Token unknown - line 2, column 56
E -)
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -842
E -Positive value expected
E -At line 2, column 57
E UNLIST_SMALLINT_01 -32768
E UNLIST_SMALLINT_01 32767
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E Statement failed, SQLSTATE = 22003
E arithmetic exception, numeric overflow, or string truncation
E -numeric value is out of range
E - UNLIST_TIME_01 00:00:00.0000
E + UNLIST_TIME_01 00:00:0
E - UNLIST_TIME_01 23:59:59.9999
E + UNLIST_TIME_01 23:59:5
E Statement failed, SQLSTATE = 22018
E conversion error from string "00:00:00.10000"
E Statement failed, SQLSTATE = 22018
E conversion error from string "00"
E Statement failed, SQLSTATE = 22018
E conversion error from string "10000"
E - UNLIST_TIME_05 23:59:59.0000
E + UNLIST_TIME_05 23:59:5
E UNLIST_TMTZ_01 00:00:00.0000 Indian/Cocos
E UNLIST_TMTZ_01 23:59:59.9999 Indian/Cocos
E Statement failed, SQLSTATE = 22018
E conversion error from string "00:00:00.10000"
E Statement failed, SQLSTATE = 22018
E conversion error from string "00"
E Statement failed, SQLSTATE = 22018
E conversion error from string "10000"
E UNLIST_TMTZ_05 23:59:59.0000 Indian/Cocos
E UNLIST_TMTZ_06 23:59:59.9999 Europe/Moscow
E UNLIST_TMTZ_06 23:59:59.9999 -03:00
E UNLIST_TMTZ_06 23:59:59.9999 GMT
E UNLIST_TMTZ_06 23:59:59.9999 AET
E UNLIST_TMTZ_06 23:59:59.9999 ART
E UNLIST_TMTZ_06 23:59:59.9999 Etc/GMT+5
E UNLIST_TMTZ_06 23:59:59.9999 America/Kentucky/Monticello
E UNLIST_TIMESTAMP_01 2315-08-06 00:00:00.0000
E UNLIST_TIMESTAMP_01 1245-12-01 23:59:59.9999
E Statement failed, SQLSTATE = 22018
E conversion error from string "00:00:00.0000,1245-12-01"
E Statement failed, SQLSTATE = 22018
E conversion error from string "8/06/2315 00"
E Statement failed, SQLSTATE = 22018
E conversion error from string "00:00:00.0000"
E UNLIST_TSTZ_01 2315-08-06 00:00:00.0000 Indian/Cocos
E UNLIST_TSTZ_01 1245-12-01 23:59:59.9999 Indian/Cocos
E Statement failed, SQLSTATE = 22018
E conversion error from string "00:00:00.0000,1245-12-01"
E Statement failed, SQLSTATE = 22018
E conversion error from string "8/06/2315 00"
E Statement failed, SQLSTATE = 22018
E conversion error from string "00:00:00.0000"
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 Europe/Moscow
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 -03:00
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 GMT
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 AET
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 ART
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 Etc/GMT+5
E UNLIST_TSTZ_05 2315-08-06 23:59:59.9999 America/Kentucky/Monticello
E UNLIST_VARBIN_01 31313131
E UNLIST_VARBIN_01 3132333435363738
E UNLIST_VARBIN_02 74657874
E UNLIST_VARBIN_02 7465787474657874
E Statement failed, SQLSTATE = 22001
E arithmetic exception, numeric overflow, or string truncation
E -string right truncation
E -expected length 8, actual 12
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -104
E -Token unknown - line 2, column 52
E -)
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -842
E -Positive value expected
E -At line 2, column 53
E UNLIST_BLOB_01 0:1
E 1111
E UNLIST_BLOB_01 0:2
E 12345678
E UNLIST_BLOB_01 0:3
E abcdefghijklmnopqrstuvwxyz
E UNLIST_BLOB_02 0:7
E 19
E UNLIST_BLOB_02 0:8
E 20
E Statement failed, SQLSTATE = 42000
E Dynamic SQL Error
E -SQL error code = -104
E -Token unknown - line 2, column 39
E -)
E UNLIST_DOMAIN_01 text
E UNLIST_DOMAIN_01 texttext
E UNLIST_DOMAIN_01 1243
E Statement failed, SQLSTATE = 22001
E arithmetic exception, numeric overflow, or string truncation
E -string right truncation
E -expected length 8, actual 12
tests/functional/intfunc/unlist/unlist_returning_types_test.py:479: AssertionError
|