Cppdb: Bound double constant becomes string of integer

Brought to you by: artyom-beilis

#114 Cppdb: Bound double constant becomes string of integer

Milestone: cppcms-1.2

Status: open

Owner: nobody

Labels: cppdb (9)

Priority: 5

Updated: 2014-10-30

Created: 2014-03-13

Creator: CN Liou

Private: No

Double constant 1000000. passed to PostgreSQL reaches PostgreSQL as string '1000000':

const double E6=1000000.f;
cppdb::result r=db_session << "SELECT amount/? FROM mytable" << E6;

PostgreSQL log:

Parameter:$1 = '1000000'

As a result, when amount is small, the selected result always becomes 0 rather than decimal like 0.01.

Anonymous