Bug #693: python interface doesn't handle int8 correctly.

Ragnar Kjrstad (postgresql(at)ragnark(dot)vesdtata(dot)no) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
python interface doesn't handle int8 correctly.

Long Description
This applies to postgresql 7.2.1 on linux x86 (32 bit)

getresult() and dictresult() return int4 data in a python int object, but it should use a python long object, or it will overflow.

From postgresql-7.2.1/src/interfaces/python:pgquery_dictresult :
switch (PQftype(self->last_result, j)) {
case INT2OID:
case INT4OID:
case INT8OID:
case OIDOID:
typ[j] = 1;
break;
}
...
switch (typ[j]) {
case 1:
val = PyInt_FromLong(strtol(s, NULL, 10));
break;
}

clearly this is wrong....

Sample Code

No file was uploaded with this report