2 @message |
assert
bigint_bigint 80
80.4450
bigint_char(10) 80.4450
bigint_date 2003-04-22
bigint_decimal( 4,2) 0.04
bigint_decimal( 4,2) 0.05
bigint_decimal(10,4) 80.4450
bigint_double precision 80.44499999999999
bigint_float 80.445
bigint_nchar(10) 80.4450
bigint_numeric( 4,2) 0.04
bigint_numeric( 4,2) 0.05
bigint_numeric(10,4) 80.4450
bigint_smallint 80
- bigint_time 01:02:03.0000
+ bigint_time 01:02:0
bigint_timestamp 2003-04-22 11:35:39.0000
bigint_varchar(10) 80.4450
blob_bigint 9223372036854775807
blob_boolean <true>
blob_char(30) 81985529216487135
blob_date 2004-02-29
blob_decimal(5,2) 80.45
blob_double precision 80.44499999999999
blob_float 80.445
blob_int -2147483648
blob_nchar(30) 81985529216487135
blob_numeric(5,2) 80.45
blob_smallint 32767
- blob_time 01:02:03.4560
+ blob_time 01:02:0
blob_varchar(30) 81985529216487135
char(30)_bigint 9223372036854775807
81985529216487135
char(30)_boolean <true>
char(30)_date 2004-02-29
char(30)_decimal(5,2) 80.45
char(30)_double precision 80.44499999999999
char(30)_float 80.445
char(30)_int -2147483648
char(30)_nchar(30) 81985529216487135
char(30)_numeric(5,2) 80.45
char(30)_smallint 32767
- char(30)_time 01:02:03.4560
+ char(30)_time 01:02:0
char(30)_varchar(30) 81985529216487135
date_bigint 147558
2004-02-29
date_char(10) 2004-02-29
date_decimal(4,2) 2.00
date_double precision 2.000000000000000
date_float 2
date_int 147558
date_nchar(10) 2004-02-29
date_numeric(4,2) 2.00
date_smallint 1461
- date_time 01:02:05.0000
+ date_time 01:02:0
date_timestamp 2003-02-03 01:02:03.0000
date_varchar(10) 2004-02-29
decimal(4,2)_bigint 80
0.05
0.06
0.08
decimal(4,2)_char(10) 0.05
decimal(4,2)_char(10) 0.06
decimal(4,2)_char(10) 0.08
decimal(4,2)_date 2003-04-22
decimal(4,2)_decimal(4,2) 0.05
decimal(4,2)_decimal(4,2) 0.06
decimal(4,2)_decimal(4,2) 0.08
decimal(4,2)_double precision 80.45000000000000
decimal(4,2)_double precision 0.05000000000000000
decimal(4,2)_double precision 0.06000000000000000
decimal(4,2)_double precision 0.08000000000000000
decimal(4,2)_float 80.449997
decimal(4,2)_float 0.050000001
decimal(4,2)_float 0.059999999
decimal(4,2)_float 0.079999998
decimal(4,2)_int 80
decimal(4,2)_nchar(10) 0.05
decimal(4,2)_nchar(10) 0.06
decimal(4,2)_nchar(10) 0.08
decimal(4,2)_numeric(4,2) 0.05
decimal(4,2)_numeric(4,2) 0.06
decimal(4,2)_numeric(4,2) 0.08
decimal(4,2)_smallint 80
- decimal(4,2)_time 01:03:23.4500
+ decimal(4,2)_time 01:03:2
decimal(4,2)_timestamp 2003-04-22 11:50:03.0000
decimal(4,2)_varchar(10) 0.05
decimal(4,2)_varchar(10) 0.06
decimal(4,2)_varchar(10) 0.08
double precision_bigint 80
80.44499999999999
double precision_char(10) 80.445000
double precision_date 2003-04-22
ouble precision_decimal(10,4) 80.4450
double precision_decimal(4,2) 0.05
double precision_decimal(4,2) 0.06
double precision_decimal(4,2) 0.08
double precision_float 80.445
double precision_int 80
double precision_nchar(10) 80.445000
ouble precision_numeric(10,4) 80.4450
double precision_numeric(4,2) 0.05
double precision_numeric(4,2) 0.06
double precision_numeric(4,2) 0.08
double precision_smallint 80
- double precision_time 01:03:23.4450
+ double precision_time 01:03:2
double precision_timestamp 2003-04-22 11:42:51.0000
double precision_varchar(10) 80.445000
float_bigint 80
80.445000
float_char(10) 80.445000
float_date 2003-04-22
float_decimal(10,4) 80.4450
float_decimal(4,2) 0.05
float_double precision 80.44499969482422
float_int 80
float_nchar(10) 80.445000
float_numeric( 4,2) 0.05
float_numeric(10,4) 80.4450
float_smallint 80
- float_time 01:03:23.4450
+ float_time 01:03:2
float_timestamp 2003-04-22 11:42:50.9736
float_varchar(10) 80.445000
int_bigint 80
80.4450
int_char(10) 80.4450
int_date 2003-04-22
int_decimal( 4,2) 0.04
int_decimal( 4,2) 0.05
int_decimal(10,4) 80.4450
int_double precision 80.44499999999999
int_float 80.445
int_nchar(10) 80.4450
int_numeric( 4,2) 0.04
int_numeric( 4,2) 0.05
int_numeric(10,4) 80.4450
int_smallint 80
- int_time 01:02:03.0000
+ int_time 01:02:0
int_timestamp 2003-04-22 11:35:39.0000
int_varchar(10) 80.4450
nchar(30)_bigint 9223372036854775807
81985529216487135
nchar(30)_boolean <true>
nchar(30)_char(30) 81985529216487135
nchar(30)_date 2004-02-29
nchar(30)_decimal(5,2) 80.45
nchar(30)_double precision 80.44499999999999
nchar(30)_float 80.445
nchar(30)_int -2147483648
nchar(30)_numeric(5,2) 80.45
nchar(30)_smallint 32767
- nchar(30)_time 01:02:03.4560
+ nchar(30)_time 01:02:0
nchar(30)_varchar(30) 81985529216487135
numeric(4,2)_bigint 80
0.05
0.06
0.08
numeric(4,2)_char(10) 0.05
numeric(4,2)_char(10) 0.06
numeric(4,2)_char(10) 0.08
numeric(4,2)_date 2003-04-22
numeric(4,2)_decimal(4,2) 0.05
numeric(4,2)_decimal(4,2) 0.06
numeric(4,2)_decimal(4,2) 0.08
numeric(4,2)_double precision 80.45000000000000
numeric(4,2)_double precision 0.05000000000000000
numeric(4,2)_double precision 0.06000000000000000
numeric(4,2)_double precision 0.08000000000000000
numeric(4,2)_float 80.449997
numeric(4,2)_float 0.050000001
numeric(4,2)_float 0.059999999
numeric(4,2)_float 0.079999998
numeric(4,2)_int 80
numeric(4,2)_nchar(10) 0.05
numeric(4,2)_nchar(10) 0.06
numeric(4,2)_nchar(10) 0.08
numeric(4,2)_numeric(4,2) 0.05
numeric(4,2)_numeric(4,2) 0.06
numeric(4,2)_numeric(4,2) 0.08
numeric(4,2)_smallint 80
- numeric(4,2)_time 01:03:23.4500
+ numeric(4,2)_time 01:03:2
numeric(4,2)_timestamp 2003-04-22 11:50:03.0000
numeric(4,2)_varchar(10) 0.05
numeric(4,2)_varchar(10) 0.06
numeric(4,2)_varchar(10) 0.08
smallint_bigint 10922
80.4450
smallint_char(10) 80.4450
smallint_date 2003-11-19
smallint_decimal( 4,2) 80.45
smallint_decimal(10,4) 80.4450
smallint_double precision 80.44499999999999
smallint_float 80.445
smallint_int -10922
smallint_int 10922
smallint_nchar(10) 80.4450
smallint_numeric( 4,2) 80.45
smallint_numeric(10,4) 80.4450
- smallint_time 01:06:55.0000
+ smallint_time 01:06:5
smallint_timestamp 2003-11-21 01:02:03.0000
smallint_varchar(10) 80.4450
time_bigint 82677
01:02:03.0000
time_char(13) 01:02:03.0000
time_date 2003-02-01
time_decimal(10,2) 82676.67
time_double precision 82676.66600000000
time_float 82676.664
time_int 82677
time_nchar(13) 01:02:03.0000
time_numeric(10,2) 82676.67
time_smallint 3661
time_timestamp 2003-02-01 01:02:03.0000
time_varchar(13) 01:02:03.0000
timestamp_bigint 1
2004-02-29 01:02:03.4560
timestamp_char(30) 2004-02-29 01:02:03.4560
timestamp_date 2004-02-29
timestamp_decimal(10,2) 0.58
timestamp_double precision 0.5755401160000000
timestamp_float 0.57554013
timestamp_int 1
timestamp_nchar(30) 2004-02-29 01:02:03.4560
timestamp_numeric(10,2) 0.58
timestamp_smallint 0
- timestamp_time 01:02:03.0000
+ timestamp_time 01:02:0
timestamp_varchar(30) 2004-02-29 01:02:03.4560
varchar(30)_bigint -268435456
varchar(30)_bigint 4026531840
varchar(30)_bigint 9223372036854775807
varchar(30)_bigint -1
81985529216487135
varchar(30)_boolean <true>
varchar(30)_char(30) 81985529216487135
varchar(30)_date 2004-02-29
varchar(30)_decimal(5,2) 80.45
varchar(30)_double precision 80.44499999999999
varchar(30)_float 80.445
varchar(30)_int -2147483648
varchar(30)_nchar(30) 81985529216487135
varchar(30)_numeric(5,2) 80.45
varchar(30)_smallint 32767
- varchar(30)_time 01:02:03.4560
+ varchar(30)_time 01:02:0
LOG DETAILS:
2025-07-01 05:55:57.492
2025-07-01 05:55:57.501 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-01 05:55:57.507 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-01 05:55:57.513
2025-07-01 05:55:57.518 @pytest.mark.version('>=3.0')
2025-07-01 05:55:57.524 def test_1(act: Action, capsys):
2025-07-01 05:55:57.530
2025-07-01 05:55:57.536 act.isql(switches=['-q'], input_file = act.files_dir / 'gtcs-cast-gen-ddl.sql')
2025-07-01 05:55:57.543 init_script = act.stdout
2025-07-01 05:55:57.550 init_err = act.stderr
2025-07-01 05:55:57.557 assert init_err == ''
2025-07-01 05:55:57.564 act.reset()
2025-07-01 05:55:57.577
2025-07-01 05:55:57.584 act.expected_stdout = expected_stdout
2025-07-01 05:55:57.591 act.isql(switches=['-q'], input = init_script, combine_output= True)
2025-07-01 05:55:57.599 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-01 05:55:57.607 E assert
2025-07-01 05:55:57.618 E bigint_bigint 80
2025-07-01 05:55:57.626 E 80.4450
2025-07-01 05:55:57.632 E bigint_char(10) 80.4450
2025-07-01 05:55:57.638 E bigint_date 2003-04-22
2025-07-01 05:55:57.643 E bigint_decimal( 4,2) 0.04
2025-07-01 05:55:57.649 E bigint_decimal( 4,2) 0.05
2025-07-01 05:55:57.655 E bigint_decimal(10,4) 80.4450
2025-07-01 05:55:57.662 E bigint_double precision 80.44499999999999
2025-07-01 05:55:57.671 E bigint_float 80.445
2025-07-01 05:55:57.682 E bigint_nchar(10) 80.4450
2025-07-01 05:55:57.695 E bigint_numeric( 4,2) 0.04
2025-07-01 05:55:57.705 E bigint_numeric( 4,2) 0.05
2025-07-01 05:55:57.716 E bigint_numeric(10,4) 80.4450
2025-07-01 05:55:57.726 E bigint_smallint 80
2025-07-01 05:55:57.735 E - bigint_time 01:02:03.0000
2025-07-01 05:55:57.754 E + bigint_time 01:02:0
2025-07-01 05:55:57.761 E bigint_timestamp 2003-04-22 11:35:39.0000
2025-07-01 05:55:57.766 E bigint_varchar(10) 80.4450
2025-07-01 05:55:57.771 E blob_bigint 9223372036854775807
2025-07-01 05:55:57.775 E blob_boolean <true>
2025-07-01 05:55:57.781 E blob_char(30) 81985529216487135
2025-07-01 05:55:57.786 E blob_date 2004-02-29
2025-07-01 05:55:57.792 E blob_decimal(5,2) 80.45
2025-07-01 05:55:57.797 E blob_double precision 80.44499999999999
2025-07-01 05:55:57.802 E blob_float 80.445
2025-07-01 05:55:57.806 E blob_int -2147483648
2025-07-01 05:55:57.811 E blob_nchar(30) 81985529216487135
2025-07-01 05:55:57.816 E blob_numeric(5,2) 80.45
2025-07-01 05:55:57.821 E blob_smallint 32767
2025-07-01 05:55:57.826 E - blob_time 01:02:03.4560
2025-07-01 05:55:57.835 E + blob_time 01:02:0
2025-07-01 05:55:57.841 E blob_varchar(30) 81985529216487135
2025-07-01 05:55:57.846 E char(30)_bigint 9223372036854775807
2025-07-01 05:55:57.852 E 81985529216487135
2025-07-01 05:55:57.859 E char(30)_boolean <true>
2025-07-01 05:55:57.866 E char(30)_date 2004-02-29
2025-07-01 05:55:57.873 E char(30)_decimal(5,2) 80.45
2025-07-01 05:55:57.879 E char(30)_double precision 80.44499999999999
2025-07-01 05:55:57.886 E char(30)_float 80.445
2025-07-01 05:55:57.893 E char(30)_int -2147483648
2025-07-01 05:55:57.900 E char(30)_nchar(30) 81985529216487135
2025-07-01 05:55:57.907 E char(30)_numeric(5,2) 80.45
2025-07-01 05:55:57.913 E char(30)_smallint 32767
2025-07-01 05:55:57.920 E - char(30)_time 01:02:03.4560
2025-07-01 05:55:57.934 E + char(30)_time 01:02:0
2025-07-01 05:55:57.942 E char(30)_varchar(30) 81985529216487135
2025-07-01 05:55:57.949 E date_bigint 147558
2025-07-01 05:55:57.954 E 2004-02-29
2025-07-01 05:55:57.959 E date_char(10) 2004-02-29
2025-07-01 05:55:57.964 E date_decimal(4,2) 2.00
2025-07-01 05:55:57.968 E date_double precision 2.000000000000000
2025-07-01 05:55:57.973 E date_float 2
2025-07-01 05:55:57.979 E date_int 147558
2025-07-01 05:55:57.984 E date_nchar(10) 2004-02-29
2025-07-01 05:55:57.990 E date_numeric(4,2) 2.00
2025-07-01 05:55:58.000 E date_smallint 1461
2025-07-01 05:55:58.011 E - date_time 01:02:05.0000
2025-07-01 05:55:58.025 E + date_time 01:02:0
2025-07-01 05:55:58.030 E date_timestamp 2003-02-03 01:02:03.0000
2025-07-01 05:55:58.035 E date_varchar(10) 2004-02-29
2025-07-01 05:55:58.040 E decimal(4,2)_bigint 80
2025-07-01 05:55:58.045 E 0.05
2025-07-01 05:55:58.049 E 0.06
2025-07-01 05:55:58.055 E 0.08
2025-07-01 05:55:58.060 E decimal(4,2)_char(10) 0.05
2025-07-01 05:55:58.066 E decimal(4,2)_char(10) 0.06
2025-07-01 05:55:58.073 E decimal(4,2)_char(10) 0.08
2025-07-01 05:55:58.081 E decimal(4,2)_date 2003-04-22
2025-07-01 05:55:58.088 E decimal(4,2)_decimal(4,2) 0.05
2025-07-01 05:55:58.093 E decimal(4,2)_decimal(4,2) 0.06
2025-07-01 05:55:58.099 E decimal(4,2)_decimal(4,2) 0.08
2025-07-01 05:55:58.104 E decimal(4,2)_double precision 80.45000000000000
2025-07-01 05:55:58.109 E decimal(4,2)_double precision 0.05000000000000000
2025-07-01 05:55:58.114 E decimal(4,2)_double precision 0.06000000000000000
2025-07-01 05:55:58.125 E decimal(4,2)_double precision 0.08000000000000000
2025-07-01 05:55:58.134 E decimal(4,2)_float 80.449997
2025-07-01 05:55:58.141 E decimal(4,2)_float 0.050000001
2025-07-01 05:55:58.147 E decimal(4,2)_float 0.059999999
2025-07-01 05:55:58.153 E decimal(4,2)_float 0.079999998
2025-07-01 05:55:58.158 E decimal(4,2)_int 80
2025-07-01 05:55:58.163 E decimal(4,2)_nchar(10) 0.05
2025-07-01 05:55:58.167 E decimal(4,2)_nchar(10) 0.06
2025-07-01 05:55:58.172 E decimal(4,2)_nchar(10) 0.08
2025-07-01 05:55:58.177 E decimal(4,2)_numeric(4,2) 0.05
2025-07-01 05:55:58.181 E decimal(4,2)_numeric(4,2) 0.06
2025-07-01 05:55:58.186 E decimal(4,2)_numeric(4,2) 0.08
2025-07-01 05:55:58.195 E decimal(4,2)_smallint 80
2025-07-01 05:55:58.204 E - decimal(4,2)_time 01:03:23.4500
2025-07-01 05:55:58.217 E + decimal(4,2)_time 01:03:2
2025-07-01 05:55:58.226 E decimal(4,2)_timestamp 2003-04-22 11:50:03.0000
2025-07-01 05:55:58.234 E decimal(4,2)_varchar(10) 0.05
2025-07-01 05:55:58.240 E decimal(4,2)_varchar(10) 0.06
2025-07-01 05:55:58.245 E decimal(4,2)_varchar(10) 0.08
2025-07-01 05:55:58.250 E double precision_bigint 80
2025-07-01 05:55:58.255 E 80.44499999999999
2025-07-01 05:55:58.260 E double precision_char(10) 80.445000
2025-07-01 05:55:58.266 E double precision_date 2003-04-22
2025-07-01 05:55:58.272 E ouble precision_decimal(10,4) 80.4450
2025-07-01 05:55:58.278 E double precision_decimal(4,2) 0.05
2025-07-01 05:55:58.283 E double precision_decimal(4,2) 0.06
2025-07-01 05:55:58.290 E double precision_decimal(4,2) 0.08
2025-07-01 05:55:58.300 E double precision_float 80.445
2025-07-01 05:55:58.308 E double precision_int 80
2025-07-01 05:55:58.315 E double precision_nchar(10) 80.445000
2025-07-01 05:55:58.321 E ouble precision_numeric(10,4) 80.4450
2025-07-01 05:55:58.326 E double precision_numeric(4,2) 0.05
2025-07-01 05:55:58.332 E double precision_numeric(4,2) 0.06
2025-07-01 05:55:58.339 E double precision_numeric(4,2) 0.08
2025-07-01 05:55:58.345 E double precision_smallint 80
2025-07-01 05:55:58.352 E - double precision_time 01:03:23.4450
2025-07-01 05:55:58.367 E + double precision_time 01:03:2
2025-07-01 05:55:58.378 E double precision_timestamp 2003-04-22 11:42:51.0000
2025-07-01 05:55:58.387 E double precision_varchar(10) 80.445000
2025-07-01 05:55:58.393 E float_bigint 80
2025-07-01 05:55:58.398 E 80.445000
2025-07-01 05:55:58.403 E float_char(10) 80.445000
2025-07-01 05:55:58.408 E float_date 2003-04-22
2025-07-01 05:55:58.418 E float_decimal(10,4) 80.4450
2025-07-01 05:55:58.424 E float_decimal(4,2) 0.05
2025-07-01 05:55:58.431 E float_double precision 80.44499969482422
2025-07-01 05:55:58.438 E float_int 80
2025-07-01 05:55:58.445 E float_nchar(10) 80.445000
2025-07-01 05:55:58.452 E float_numeric( 4,2) 0.05
2025-07-01 05:55:58.459 E float_numeric(10,4) 80.4450
2025-07-01 05:55:58.467 E float_smallint 80
2025-07-01 05:55:58.478 E - float_time 01:03:23.4450
2025-07-01 05:55:58.494 E + float_time 01:03:2
2025-07-01 05:55:58.500 E float_timestamp 2003-04-22 11:42:50.9736
2025-07-01 05:55:58.507 E float_varchar(10) 80.445000
2025-07-01 05:55:58.514 E int_bigint 80
2025-07-01 05:55:58.521 E 80.4450
2025-07-01 05:55:58.527 E int_char(10) 80.4450
2025-07-01 05:55:58.534 E int_date 2003-04-22
2025-07-01 05:55:58.542 E int_decimal( 4,2) 0.04
2025-07-01 05:55:58.553 E int_decimal( 4,2) 0.05
2025-07-01 05:55:58.561 E int_decimal(10,4) 80.4450
2025-07-01 05:55:58.568 E int_double precision 80.44499999999999
2025-07-01 05:55:58.573 E int_float 80.445
2025-07-01 05:55:58.579 E int_nchar(10) 80.4450
2025-07-01 05:55:58.585 E int_numeric( 4,2) 0.04
2025-07-01 05:55:58.591 E int_numeric( 4,2) 0.05
2025-07-01 05:55:58.596 E int_numeric(10,4) 80.4450
2025-07-01 05:55:58.602 E int_smallint 80
2025-07-01 05:55:58.608 E - int_time 01:02:03.0000
2025-07-01 05:55:58.626 E + int_time 01:02:0
2025-07-01 05:55:58.637 E int_timestamp 2003-04-22 11:35:39.0000
2025-07-01 05:55:58.645 E int_varchar(10) 80.4450
2025-07-01 05:55:58.656 E nchar(30)_bigint 9223372036854775807
2025-07-01 05:55:58.667 E 81985529216487135
2025-07-01 05:55:58.674 E nchar(30)_boolean <true>
2025-07-01 05:55:58.683 E nchar(30)_char(30) 81985529216487135
2025-07-01 05:55:58.694 E nchar(30)_date 2004-02-29
2025-07-01 05:55:58.702 E nchar(30)_decimal(5,2) 80.45
2025-07-01 05:55:58.709 E nchar(30)_double precision 80.44499999999999
2025-07-01 05:55:58.715 E nchar(30)_float 80.445
2025-07-01 05:55:58.720 E nchar(30)_int -2147483648
2025-07-01 05:55:58.726 E nchar(30)_numeric(5,2) 80.45
2025-07-01 05:55:58.733 E nchar(30)_smallint 32767
2025-07-01 05:55:58.739 E - nchar(30)_time 01:02:03.4560
2025-07-01 05:55:58.754 E + nchar(30)_time 01:02:0
2025-07-01 05:55:58.762 E nchar(30)_varchar(30) 81985529216487135
2025-07-01 05:55:58.768 E numeric(4,2)_bigint 80
2025-07-01 05:55:58.774 E 0.05
2025-07-01 05:55:58.779 E 0.06
2025-07-01 05:55:58.785 E 0.08
2025-07-01 05:55:58.790 E numeric(4,2)_char(10) 0.05
2025-07-01 05:55:58.796 E numeric(4,2)_char(10) 0.06
2025-07-01 05:55:58.803 E numeric(4,2)_char(10) 0.08
2025-07-01 05:55:58.809 E numeric(4,2)_date 2003-04-22
2025-07-01 05:55:58.816 E numeric(4,2)_decimal(4,2) 0.05
2025-07-01 05:55:58.823 E numeric(4,2)_decimal(4,2) 0.06
2025-07-01 05:55:58.829 E numeric(4,2)_decimal(4,2) 0.08
2025-07-01 05:55:58.839 E numeric(4,2)_double precision 80.45000000000000
2025-07-01 05:55:58.851 E numeric(4,2)_double precision 0.05000000000000000
2025-07-01 05:55:58.862 E numeric(4,2)_double precision 0.06000000000000000
2025-07-01 05:55:58.869 E numeric(4,2)_double precision 0.08000000000000000
2025-07-01 05:55:58.875 E numeric(4,2)_float 80.449997
2025-07-01 05:55:58.881 E numeric(4,2)_float 0.050000001
2025-07-01 05:55:58.887 E numeric(4,2)_float 0.059999999
2025-07-01 05:55:58.894 E numeric(4,2)_float 0.079999998
2025-07-01 05:55:58.905 E numeric(4,2)_int 80
2025-07-01 05:55:58.914 E numeric(4,2)_nchar(10) 0.05
2025-07-01 05:55:58.920 E numeric(4,2)_nchar(10) 0.06
2025-07-01 05:55:58.925 E numeric(4,2)_nchar(10) 0.08
2025-07-01 05:55:58.931 E numeric(4,2)_numeric(4,2) 0.05
2025-07-01 05:55:58.936 E numeric(4,2)_numeric(4,2) 0.06
2025-07-01 05:55:58.941 E numeric(4,2)_numeric(4,2) 0.08
2025-07-01 05:55:58.946 E numeric(4,2)_smallint 80
2025-07-01 05:55:58.951 E - numeric(4,2)_time 01:03:23.4500
2025-07-01 05:55:58.961 E + numeric(4,2)_time 01:03:2
2025-07-01 05:55:58.966 E numeric(4,2)_timestamp 2003-04-22 11:50:03.0000
2025-07-01 05:55:58.971 E numeric(4,2)_varchar(10) 0.05
2025-07-01 05:55:58.977 E numeric(4,2)_varchar(10) 0.06
2025-07-01 05:55:58.982 E numeric(4,2)_varchar(10) 0.08
2025-07-01 05:55:58.988 E smallint_bigint 10922
2025-07-01 05:55:58.995 E 80.4450
2025-07-01 05:55:59.001 E smallint_char(10) 80.4450
2025-07-01 05:55:59.012 E smallint_date 2003-11-19
2025-07-01 05:55:59.023 E smallint_decimal( 4,2) 80.45
2025-07-01 05:55:59.029 E smallint_decimal(10,4) 80.4450
2025-07-01 05:55:59.036 E smallint_double precision 80.44499999999999
2025-07-01 05:55:59.042 E smallint_float 80.445
2025-07-01 05:55:59.052 E smallint_int -10922
2025-07-01 05:55:59.059 E smallint_int 10922
2025-07-01 05:55:59.066 E smallint_nchar(10) 80.4450
2025-07-01 05:55:59.073 E smallint_numeric( 4,2) 80.45
2025-07-01 05:55:59.080 E smallint_numeric(10,4) 80.4450
2025-07-01 05:55:59.087 E - smallint_time 01:06:55.0000
2025-07-01 05:55:59.100 E + smallint_time 01:06:5
2025-07-01 05:55:59.107 E smallint_timestamp 2003-11-21 01:02:03.0000
2025-07-01 05:55:59.115 E smallint_varchar(10) 80.4450
2025-07-01 05:55:59.123 E time_bigint 82677
2025-07-01 05:55:59.133 E 01:02:03.0000
2025-07-01 05:55:59.141 E time_char(13) 01:02:03.0000
2025-07-01 05:55:59.147 E time_date 2003-02-01
2025-07-01 05:55:59.153 E time_decimal(10,2) 82676.67
2025-07-01 05:55:59.158 E time_double precision 82676.66600000000
2025-07-01 05:55:59.167 E time_float 82676.664
2025-07-01 05:55:59.179 E time_int 82677
2025-07-01 05:55:59.191 E time_nchar(13) 01:02:03.0000
2025-07-01 05:55:59.204 E time_numeric(10,2) 82676.67
2025-07-01 05:55:59.213 E time_smallint 3661
2025-07-01 05:55:59.226 E time_timestamp 2003-02-01 01:02:03.0000
2025-07-01 05:55:59.238 E time_varchar(13) 01:02:03.0000
2025-07-01 05:55:59.247 E timestamp_bigint 1
2025-07-01 05:55:59.256 E 2004-02-29 01:02:03.4560
2025-07-01 05:55:59.269 E timestamp_char(30) 2004-02-29 01:02:03.4560
2025-07-01 05:55:59.280 E timestamp_date 2004-02-29
2025-07-01 05:55:59.288 E timestamp_decimal(10,2) 0.58
2025-07-01 05:55:59.297 E timestamp_double precision 0.5755401160000000
2025-07-01 05:55:59.304 E timestamp_float 0.57554013
2025-07-01 05:55:59.309 E timestamp_int 1
2025-07-01 05:55:59.315 E timestamp_nchar(30) 2004-02-29 01:02:03.4560
2025-07-01 05:55:59.322 E timestamp_numeric(10,2) 0.58
2025-07-01 05:55:59.329 E timestamp_smallint 0
2025-07-01 05:55:59.335 E - timestamp_time 01:02:03.0000
2025-07-01 05:55:59.347 E + timestamp_time 01:02:0
2025-07-01 05:55:59.354 E timestamp_varchar(30) 2004-02-29 01:02:03.4560
2025-07-01 05:55:59.360 E varchar(30)_bigint -268435456
2025-07-01 05:55:59.366 E varchar(30)_bigint 4026531840
2025-07-01 05:55:59.372 E varchar(30)_bigint 9223372036854775807
2025-07-01 05:55:59.380 E varchar(30)_bigint -1
2025-07-01 05:55:59.390 E 81985529216487135
2025-07-01 05:55:59.402 E varchar(30)_boolean <true>
2025-07-01 05:55:59.413 E varchar(30)_char(30) 81985529216487135
2025-07-01 05:55:59.421 E varchar(30)_date 2004-02-29
2025-07-01 05:55:59.429 E varchar(30)_decimal(5,2) 80.45
2025-07-01 05:55:59.435 E varchar(30)_double precision 80.44499999999999
2025-07-01 05:55:59.440 E varchar(30)_float 80.445
2025-07-01 05:55:59.448 E varchar(30)_int -2147483648
2025-07-01 05:55:59.455 E varchar(30)_nchar(30) 81985529216487135
2025-07-01 05:55:59.465 E varchar(30)_numeric(5,2) 80.45
2025-07-01 05:55:59.473 E varchar(30)_smallint 32767
2025-07-01 05:55:59.480 E - varchar(30)_time 01:02:03.4560
2025-07-01 05:55:59.491 E + varchar(30)_time 01:02:0
2025-07-01 05:55:59.495
2025-07-01 05:55:59.500 tests/functional/gtcs/test_cast_datatypes.py:312: AssertionError
2025-07-01 05:55:59.506 ---------------------------- Captured stdout setup -----------------------------
2025-07-01 05:55:59.513 Creating db: localhost:/var/tmp/qa_2024/test_12073/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('>=3.0')
def test_1(act: Action, capsys):
act.isql(switches=['-q'], input_file = act.files_dir / 'gtcs-cast-gen-ddl.sql')
init_script = act.stdout
init_err = act.stderr
assert init_err == ''
act.reset()
act.expected_stdout = expected_stdout
act.isql(switches=['-q'], input = init_script, combine_output= True)
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E bigint_bigint 80
E 80.4450
E bigint_char(10) 80.4450
E bigint_date 2003-04-22
E bigint_decimal( 4,2) 0.04
E bigint_decimal( 4,2) 0.05
E bigint_decimal(10,4) 80.4450
E bigint_double precision 80.44499999999999
E bigint_float 80.445
E bigint_nchar(10) 80.4450
E bigint_numeric( 4,2) 0.04
E bigint_numeric( 4,2) 0.05
E bigint_numeric(10,4) 80.4450
E bigint_smallint 80
E - bigint_time 01:02:03.0000
E + bigint_time 01:02:0
E bigint_timestamp 2003-04-22 11:35:39.0000
E bigint_varchar(10) 80.4450
E blob_bigint 9223372036854775807
E blob_boolean <true>
E blob_char(30) 81985529216487135
E blob_date 2004-02-29
E blob_decimal(5,2) 80.45
E blob_double precision 80.44499999999999
E blob_float 80.445
E blob_int -2147483648
E blob_nchar(30) 81985529216487135
E blob_numeric(5,2) 80.45
E blob_smallint 32767
E - blob_time 01:02:03.4560
E + blob_time 01:02:0
E blob_varchar(30) 81985529216487135
E char(30)_bigint 9223372036854775807
E 81985529216487135
E char(30)_boolean <true>
E char(30)_date 2004-02-29
E char(30)_decimal(5,2) 80.45
E char(30)_double precision 80.44499999999999
E char(30)_float 80.445
E char(30)_int -2147483648
E char(30)_nchar(30) 81985529216487135
E char(30)_numeric(5,2) 80.45
E char(30)_smallint 32767
E - char(30)_time 01:02:03.4560
E + char(30)_time 01:02:0
E char(30)_varchar(30) 81985529216487135
E date_bigint 147558
E 2004-02-29
E date_char(10) 2004-02-29
E date_decimal(4,2) 2.00
E date_double precision 2.000000000000000
E date_float 2
E date_int 147558
E date_nchar(10) 2004-02-29
E date_numeric(4,2) 2.00
E date_smallint 1461
E - date_time 01:02:05.0000
E + date_time 01:02:0
E date_timestamp 2003-02-03 01:02:03.0000
E date_varchar(10) 2004-02-29
E decimal(4,2)_bigint 80
E 0.05
E 0.06
E 0.08
E decimal(4,2)_char(10) 0.05
E decimal(4,2)_char(10) 0.06
E decimal(4,2)_char(10) 0.08
E decimal(4,2)_date 2003-04-22
E decimal(4,2)_decimal(4,2) 0.05
E decimal(4,2)_decimal(4,2) 0.06
E decimal(4,2)_decimal(4,2) 0.08
E decimal(4,2)_double precision 80.45000000000000
E decimal(4,2)_double precision 0.05000000000000000
E decimal(4,2)_double precision 0.06000000000000000
E decimal(4,2)_double precision 0.08000000000000000
E decimal(4,2)_float 80.449997
E decimal(4,2)_float 0.050000001
E decimal(4,2)_float 0.059999999
E decimal(4,2)_float 0.079999998
E decimal(4,2)_int 80
E decimal(4,2)_nchar(10) 0.05
E decimal(4,2)_nchar(10) 0.06
E decimal(4,2)_nchar(10) 0.08
E decimal(4,2)_numeric(4,2) 0.05
E decimal(4,2)_numeric(4,2) 0.06
E decimal(4,2)_numeric(4,2) 0.08
E decimal(4,2)_smallint 80
E - decimal(4,2)_time 01:03:23.4500
E + decimal(4,2)_time 01:03:2
E decimal(4,2)_timestamp 2003-04-22 11:50:03.0000
E decimal(4,2)_varchar(10) 0.05
E decimal(4,2)_varchar(10) 0.06
E decimal(4,2)_varchar(10) 0.08
E double precision_bigint 80
E 80.44499999999999
E double precision_char(10) 80.445000
E double precision_date 2003-04-22
E ouble precision_decimal(10,4) 80.4450
E double precision_decimal(4,2) 0.05
E double precision_decimal(4,2) 0.06
E double precision_decimal(4,2) 0.08
E double precision_float 80.445
E double precision_int 80
E double precision_nchar(10) 80.445000
E ouble precision_numeric(10,4) 80.4450
E double precision_numeric(4,2) 0.05
E double precision_numeric(4,2) 0.06
E double precision_numeric(4,2) 0.08
E double precision_smallint 80
E - double precision_time 01:03:23.4450
E + double precision_time 01:03:2
E double precision_timestamp 2003-04-22 11:42:51.0000
E double precision_varchar(10) 80.445000
E float_bigint 80
E 80.445000
E float_char(10) 80.445000
E float_date 2003-04-22
E float_decimal(10,4) 80.4450
E float_decimal(4,2) 0.05
E float_double precision 80.44499969482422
E float_int 80
E float_nchar(10) 80.445000
E float_numeric( 4,2) 0.05
E float_numeric(10,4) 80.4450
E float_smallint 80
E - float_time 01:03:23.4450
E + float_time 01:03:2
E float_timestamp 2003-04-22 11:42:50.9736
E float_varchar(10) 80.445000
E int_bigint 80
E 80.4450
E int_char(10) 80.4450
E int_date 2003-04-22
E int_decimal( 4,2) 0.04
E int_decimal( 4,2) 0.05
E int_decimal(10,4) 80.4450
E int_double precision 80.44499999999999
E int_float 80.445
E int_nchar(10) 80.4450
E int_numeric( 4,2) 0.04
E int_numeric( 4,2) 0.05
E int_numeric(10,4) 80.4450
E int_smallint 80
E - int_time 01:02:03.0000
E + int_time 01:02:0
E int_timestamp 2003-04-22 11:35:39.0000
E int_varchar(10) 80.4450
E nchar(30)_bigint 9223372036854775807
E 81985529216487135
E nchar(30)_boolean <true>
E nchar(30)_char(30) 81985529216487135
E nchar(30)_date 2004-02-29
E nchar(30)_decimal(5,2) 80.45
E nchar(30)_double precision 80.44499999999999
E nchar(30)_float 80.445
E nchar(30)_int -2147483648
E nchar(30)_numeric(5,2) 80.45
E nchar(30)_smallint 32767
E - nchar(30)_time 01:02:03.4560
E + nchar(30)_time 01:02:0
E nchar(30)_varchar(30) 81985529216487135
E numeric(4,2)_bigint 80
E 0.05
E 0.06
E 0.08
E numeric(4,2)_char(10) 0.05
E numeric(4,2)_char(10) 0.06
E numeric(4,2)_char(10) 0.08
E numeric(4,2)_date 2003-04-22
E numeric(4,2)_decimal(4,2) 0.05
E numeric(4,2)_decimal(4,2) 0.06
E numeric(4,2)_decimal(4,2) 0.08
E numeric(4,2)_double precision 80.45000000000000
E numeric(4,2)_double precision 0.05000000000000000
E numeric(4,2)_double precision 0.06000000000000000
E numeric(4,2)_double precision 0.08000000000000000
E numeric(4,2)_float 80.449997
E numeric(4,2)_float 0.050000001
E numeric(4,2)_float 0.059999999
E numeric(4,2)_float 0.079999998
E numeric(4,2)_int 80
E numeric(4,2)_nchar(10) 0.05
E numeric(4,2)_nchar(10) 0.06
E numeric(4,2)_nchar(10) 0.08
E numeric(4,2)_numeric(4,2) 0.05
E numeric(4,2)_numeric(4,2) 0.06
E numeric(4,2)_numeric(4,2) 0.08
E numeric(4,2)_smallint 80
E - numeric(4,2)_time 01:03:23.4500
E + numeric(4,2)_time 01:03:2
E numeric(4,2)_timestamp 2003-04-22 11:50:03.0000
E numeric(4,2)_varchar(10) 0.05
E numeric(4,2)_varchar(10) 0.06
E numeric(4,2)_varchar(10) 0.08
E smallint_bigint 10922
E 80.4450
E smallint_char(10) 80.4450
E smallint_date 2003-11-19
E smallint_decimal( 4,2) 80.45
E smallint_decimal(10,4) 80.4450
E smallint_double precision 80.44499999999999
E smallint_float 80.445
E smallint_int -10922
E smallint_int 10922
E smallint_nchar(10) 80.4450
E smallint_numeric( 4,2) 80.45
E smallint_numeric(10,4) 80.4450
E - smallint_time 01:06:55.0000
E + smallint_time 01:06:5
E smallint_timestamp 2003-11-21 01:02:03.0000
E smallint_varchar(10) 80.4450
E time_bigint 82677
E 01:02:03.0000
E time_char(13) 01:02:03.0000
E time_date 2003-02-01
E time_decimal(10,2) 82676.67
E time_double precision 82676.66600000000
E time_float 82676.664
E time_int 82677
E time_nchar(13) 01:02:03.0000
E time_numeric(10,2) 82676.67
E time_smallint 3661
E time_timestamp 2003-02-01 01:02:03.0000
E time_varchar(13) 01:02:03.0000
E timestamp_bigint 1
E 2004-02-29 01:02:03.4560
E timestamp_char(30) 2004-02-29 01:02:03.4560
E timestamp_date 2004-02-29
E timestamp_decimal(10,2) 0.58
E timestamp_double precision 0.5755401160000000
E timestamp_float 0.57554013
E timestamp_int 1
E timestamp_nchar(30) 2004-02-29 01:02:03.4560
E timestamp_numeric(10,2) 0.58
E timestamp_smallint 0
E - timestamp_time 01:02:03.0000
E + timestamp_time 01:02:0
E timestamp_varchar(30) 2004-02-29 01:02:03.4560
E varchar(30)_bigint -268435456
E varchar(30)_bigint 4026531840
E varchar(30)_bigint 9223372036854775807
E varchar(30)_bigint -1
E 81985529216487135
E varchar(30)_boolean <true>
E varchar(30)_char(30) 81985529216487135
E varchar(30)_date 2004-02-29
E varchar(30)_decimal(5,2) 80.45
E varchar(30)_double precision 80.44499999999999
E varchar(30)_float 80.445
E varchar(30)_int -2147483648
E varchar(30)_nchar(30) 81985529216487135
E varchar(30)_numeric(5,2) 80.45
E varchar(30)_smallint 32767
E - varchar(30)_time 01:02:03.4560
E + varchar(30)_time 01:02:0
tests/functional/gtcs/test_cast_datatypes.py:312: AssertionError
|