Re: Concat Occasionally Drops a Character or Two
Posted by:
Rick James
Date: September 27, 2009 12:27PM
Puzzling. Let's try something... Create an extra table with just a AUTO_INCREMENT id and a BLOB. Load the 10K chunks into it. Then try several things:
* See if each chunk (except last) is exactly 10K.
* Create the 'real' blob via an UPDATE like you have; display the size after each CONCAT. Probably should do this via an extra SELECT LENGTH(content) FROM Media WHERE id = ...
Did you try it without casting to BINARY?
Please SHOW CREATE TABLE -- just checking for surprises.
Subject
Written By
Posted
September 24, 2009 06:30PM
September 25, 2009 11:10PM
September 27, 2009 10:54AM
Re: Concat Occasionally Drops a Character or Two
September 27, 2009 12:27PM
September 27, 2009 03:03PM
September 27, 2009 03:24PM
September 27, 2009 05:33PM
September 28, 2009 05:30PM
September 28, 2009 09:57PM
September 29, 2009 07:51PM
September 29, 2009 10:25PM
September 28, 2009 11:23PM
September 29, 2009 05:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.