src/interfaces/ecpg/test/expected/sql-sqlda.stdout - master - githubmirror/postgres

src/interfaces/ecpg/test/expected/sql-sqlda.stdout
84 строки3 KB
Tom Lane
Second try at fixing numeric data passed through an ECPG SQLDA.
14 ноя 2018, 19:27
14 ноя 2018, 19:2706c7234
FETCH RECORD 1
name sqlda descriptor: 'id' value 1
name sqlda descriptor: 't' value 'a'
name sqlda descriptor: 'd1' value NUMERIC '1.0'
name sqlda descriptor: 'd2' value 1.000000
name sqlda descriptor: 'c' value 'a         '
name sqlda descriptor: 'big' value 1111111111111111111
FETCH RECORD 2
name sqlda descriptor: 'id' value 2
name sqlda descriptor: 't' value NULL'
name sqlda descriptor: 'd1' value NULL'
name sqlda descriptor: 'd2' value NULL'
name sqlda descriptor: 'c' value NULL'
name sqlda descriptor: 'big' value NULL'
FETCH RECORD 3
name sqlda descriptor: 'id' value 3
name sqlda descriptor: 't' value 'c'
name sqlda descriptor: 'd1' value NUMERIC '0.0'
name sqlda descriptor: 'd2' value 3.000000
name sqlda descriptor: 'c' value 'c         '
name sqlda descriptor: 'big' value 3333333333333333333
FETCH RECORD 4
name sqlda descriptor: 'id' value 4
name sqlda descriptor: 't' value 'd'
name sqlda descriptor: 'd1' value NUMERIC 'NaN'
name sqlda descriptor: 'd2' value 4.000000
name sqlda descriptor: 'c' value 'd         '
name sqlda descriptor: 'big' value 4444444444444444444
FETCH RECORD 5
name sqlda descriptor: 'id' value 5
name sqlda descriptor: 't' value 'e'
name sqlda descriptor: 'd1' value NUMERIC '0.001234'
name sqlda descriptor: 'd2' value 5.000000
name sqlda descriptor: 'c' value 'e         '
name sqlda descriptor: 'big' value 5555555555555555555
FETCH RECORD 1
name sqlda descriptor: 'id' value 1
name sqlda descriptor: 't' value 'a'
name sqlda descriptor: 'd1' value NUMERIC '1.0'
name sqlda descriptor: 'd2' value 1.000000
name sqlda descriptor: 'c' value 'a         '
name sqlda descriptor: 'big' value 1111111111111111111
FETCH RECORD 2
name sqlda descriptor: 'id' value 2
name sqlda descriptor: 't' value NULL'
name sqlda descriptor: 'd1' value NULL'
name sqlda descriptor: 'd2' value NULL'
name sqlda descriptor: 'c' value NULL'
name sqlda descriptor: 'big' value NULL'
FETCH RECORD 3
name sqlda descriptor: 'id' value 3
name sqlda descriptor: 't' value 'c'
name sqlda descriptor: 'd1' value NUMERIC '0.0'
name sqlda descriptor: 'd2' value 3.000000
name sqlda descriptor: 'c' value 'c         '
name sqlda descriptor: 'big' value 3333333333333333333
FETCH RECORD 4
name sqlda descriptor: 'id' value 4
name sqlda descriptor: 't' value 'd'
name sqlda descriptor: 'd1' value NUMERIC 'NaN'
name sqlda descriptor: 'd2' value 4.000000
name sqlda descriptor: 'c' value 'd         '
name sqlda descriptor: 'big' value 4444444444444444444
FETCH RECORD 5
name sqlda descriptor: 'id' value 5
name sqlda descriptor: 't' value 'e'
name sqlda descriptor: 'd1' value NUMERIC '0.001234'
name sqlda descriptor: 'd2' value 5.000000
name sqlda descriptor: 'c' value 'e         '
name sqlda descriptor: 'big' value 5555555555555555555
EXECUTE RECORD 4
name sqlda descriptor: 'id' value 4
name sqlda descriptor: 't' value 'd'
name sqlda descriptor: 'd1' value NUMERIC 'NaN'
name sqlda descriptor: 'd2' value 4.000000
name sqlda descriptor: 'c' value 'd         '
name sqlda descriptor: 'big' value 4444444444444444444
EXECUTE RECORD 4
name sqlda descriptor: 'id' value 4
name sqlda descriptor: 't' value 'd'
name sqlda descriptor: 'd1' value NUMERIC 'NaN'
name sqlda descriptor: 'd2' value 4.000000
name sqlda descriptor: 'c' value 'd         '
name sqlda descriptor: 'big' value 4444444444444444444