#941: Trucated history revision for revisions
--------------------+-----------------------
Reporter: adeiana | Owner:
Type: defect | Status: new
Priority: major | Component: *general*
Version: | Keywords:
--------------------+-----------------------
We have a problem over here in inspire where some revisions for our
records are truncated because they are longer than 65535 which is the max
length for BLOBs in MySQL.
I would suggest to converting the blob to mediumblob.
r = run_sql('SELECT marcxml FROM hstRECORD WHERE id_bibrec=%s AND
job_date=%s', ('1083313', '20120106133541'))
>>> len(r[0][0])
65535
>>> zlib.decompress(r[0][0])
Traceback (most recent call last):
File "<stdin>", line 1, in ?
zlib.error: Error -5 while decompressing data
--
Ticket URL: <http://invenio-software.org/ticket/941>
Invenio <http://invenio-software.org>
