Hi,
I'm doing some tests on django-firebird (firebird backend for django) [1] and I
see that inserting smallint data just on limit of the range fails
In Firebird technical specifications [2] the smallint range is -2^15 to 2^15-1
(-32768 to 32767).
but insert fails if I try to insert a record with a value -32768
Example:
CREATE TABLE MODEL_FIELDS_SMALLINTEGERMODEL
(
ID INTEGER NOT NULL,
"VALUE" SMALLINT NOT NULL,
CONSTRAINT INTEG_38 PRIMARY KEY (ID)
);
>>> conn = fdb.connect(dsn=....
>>> cur = conn.cursor()
>>> cur.execute('INSERT INTO "MODEL_FIELDS_SMALLINTEGERMODEL" ("VALUE") VALUES
>>> (?)', (-32768,))
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 3574, in
execute
self._ps._execute(parameters)
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 3258, in
_execute
self.__Tuple2XSQLDA(self._in_sqlda, parameters)
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 3044, in
__Tuple2XSQLDA
sqlvar.sqlscale)
File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2538, in
_check_integer_range
raise ProgrammingError(msg, -802)
ProgrammingError: ('numeric overflow: value -32768\n (SMALLINT scaled for 0
decimal places) is of\n too great a magnitude to fit into its internal storage
type SQL_SHORT,\n which has range [-32767,32767].', -802)
Why in fdb.ibase.py smaillint min range is defined as SHRT_MIN = -32767 ?
Is it just a mistake or is there another limitation?
Regards.
--
Maxi
[1] https://github.com/maxirobaina/django-firebird
[2] http://www.firebirdsql.org/en/firebird-technical-specifications/
