Hi,
In fdb, the BIGINT fail on insert with lower limit value.
>>> import fdb
>>>
>>> maxval = 9223372036854775807
>>> minval = -maxval - 1
>>>
>>> conn = fdb.connect(dsn='django-test', user='sysdba', password='masterkey')
>>> cur.execute('INSERT INTO MODEL_FIELDS_BIGINT("VALUE") VALUES (?)', [minval])
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2697, in
execute
self._ps._execute(parameters)
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2375, in
_execute
self.__Tuple2XSQLDA(self.in_sqlda, parameters)
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2217, in
__Tuple2XSQLDA
int_to_bytes(value, sqlvar.sqllen))), buf_pointer)
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 443, in
int_to_bytes
return struct.pack(fmt, val)
error: integer out of range for 'Q' format code
>>>
The table structure is:
CREATE TABLE MODEL_FIELDS_BIGINT
(
ID Integer NOT NULL,
"VALUE" Bigint NOT NULL,
NULL_VALUE Bigint,
PRIMARY KEY (ID)
);
--
Maxi
b: http://maxirobaina.tumblr.com
t: http://twitter.com/maxirobaina
