Bug #325 Length of geometry data type
Submitted: 25 Apr 2003 17:56 Modified: 15 May 2003 1:08
Reporter: Abel Coronado Iruegas Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.0 OS:Linux (Linux,Windows and solaris(sparc))
Assigned to: Alexander Barkov CPU Architecture:Any

[25 Apr 2003 17:56] Abel Coronado Iruegas
The length of the data type GEOMETRY is not enough.
Blob size, produce rare errors on the asText query of the field. On inserts not send message errors. When the data exceds the flob limits.

How to repeat:
Insert features than exceed the blob limits. Then query these features with the asText funcion. The results are nulls.

Suggested fix:
Modifing the files fields.cc to the longblob and Recompiling the server the problem is out.
[15 May 2003 1:08] Alexander Barkov
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 

I guess this was about pre-4.1.0 downloaded from BK. BLOB
was used to store GEOMETRY originally. The final 4.1.0 has a fix
for this problem. Now LONG BLOB underlays GEOMETRY.