blob update failure

[Mark J. Lilback]

I'm running into a problem updating a blob column. The table is:

CREATE TABLE product(
  product_id int(11) NOT NULL auto_increment,
  name varchar(60) NOT NULL,
  cat_id int(11) DEFAULT 0 NOT NULL,
  releasedate date,
  price decimal(10,2),
  description text,
  imagedata blob,
  PRIMARY KEY (product_id)
);
A "select product_id from product" returns:
+-------------+
|product_id   |
+-------------+
|           1 |
|           2 |
|           3 |
|           4 |
+-------------+
But the following query fails. Anyone got a suggestion as to what the 
problem is? max_allowed_packet is set to be very high on both the 
client and the server.

update product set imagedata = 
0xFDFE0144440000000000FD0400000000000000001000001110111111111222222221123223333312333332333FC00005060010FC0100000000000000000000000000000FC0B100000000000000070000010123401560271389A024BC15DF23678001111122222233333334444444455555555666666667777777788888888999999999AAAAAAAAABBBBBBBBBCCCCCCCCCDDDDDDDDDEEEEEEEEEEFFFFFFFFFFFD00000030FF8FDA9CB5DE4C19E9CC96EB1EF0C5571E373BBBB7642B4623DC51975E0E72784DF23AAD2C8F3E94353D68F78513CF18CFD4AD4A12880D5AA7E70AD1D73D7C1F1C5DE86A0362DB3E63C3936BE2A82AB1CA5F7F10E264E60BA4B3F7779FD8F0C10ADB32579DC70F95E8B37B31E30FFDA777734772951A332AD5FBC01572B31C26381A5BC0010760B80A4BF1DF4AF25F8D62BCD8683971444EEC0A5415537CEB8F2EB47851AD60FA0CA022C3C34CA1DF8C1659BF8BB9C2580E0600F15CCE5B8CC02B9C41696301E76EEE6C322313C64CDB327C13059EF7C872AF35635BFAD11454F5E21B3CE2823B2040F40C2809E5F4C1FB5D4B2E63E6C2CEEDEA909417D35497430B41550F1E58FE065096AFAE53C0A2110EC706AB7A5F9BE4D87C70466F4A782A53C8F7AE6FED314F18D652F80703EFC0F1F079CC8F4815858EEBFC461B957EE889E99E974FF108C33C 
E9324EE57CB4C02050BA70FA88B0E51D1BB5420F97C350FFA3F7F5CD2F9F00FA986A7C22F4702D7C713FAAF15DFC439D46721F5702AC1AF7FE262D26BB2693215A83336B9C90F06A6BB2DA5152BAC5850570EF3BEEADFA8F0078D5D57D911364C20EF80A1F6AE0EF7D770A0CA4B836EA90E8BE7132574DA70BD202BB644ED8F80881728ADCDC390ADA7EAEB5B4C32DCB632BF1D732FCC77F2C9F140C67DA0B441FA1637F0C2BE8CA2D34A6DD1F5A760C3EB997360DD544FCF55DD5D0490A89DE03AF2BD746AF9585271A97F4A33174E5FE9D04BD6BE1B3178759F2B0C309E170C44FA06F0DF1BD7C39DA171836F70B2D975F6AFE5DAB9B808E389C4E25E9B033546C32F28C35976AFA6FDC991AEB3FEAC287A2A8EF0E5F5E36770A9B677CE349BA26BF09DAB70D59EC9E4814E6A2FBC4962666E62E153465E5B9097A554016DE89495FBE45D4F59ADD4760ED420558EF231E5D16CA0E52BD3C73D9AB7FE0620D32830A737FC485E8F5ADD65B9AB40ABD24643DFF8AEF5171F4C50BBD22BB12B399362B8941F3F78B30F1BF789C1F94928DCDD1F3853C3EA8F3EC1D5E93C10C1842E6113891AADBC4E1AE0DE146EF09225D2001D9939889F9CE076C5E6ACFC7FFD2DD7EE75EF86F4F0F7F78B352B86B4CBA67A11634E6ACFA790667624678413BF2FA93374DC339217A0CCC01192383 
04CFC7F72F7EE82B3AF867BD538292285001E3EFA6AB7A0E12B54648F06CB279197887139A569637908D04704543C34AC0C11FDC5EF3AAEA4AAB0331973A726572F2AA59135ACBC24A7462E11F2DF0A4A67D41B05699C49391875BCDB70F86AAD8B78B877F5E7A18A899C9FDDD78989BBBBBB026A543D21F2CB14E21C762F3D366C3709D3A4E079EF5C516179AC39FD543C289ABD417DD3DD15415C3174812F9F086B9AE973BB641718ED7804554AE98877825B67B108DD8D1AD72621BD026845E324DFF08FF01C728AC7B8158DE09AD0905471F58FCAEDF02A9887375A27880D23A0375BD4154B41D3103E8F0E3FC8A75F3EE93F35326427CBB2F8C3010060BC7FC3F0DABBBBB4DC0991AE2A9EEDA6DF55DFAB4E2FDC6B5F44BE9ED55EC8FC8337A55D4185227C2F00E13747EB8DF5DA394C337CDE76A63B97244918B1FAA8A924274144E26A82A9EA9EE536DFE19FA1FCFEB4AD6DE212ED2ABD8C7CB7FB356F3485F6A6EC414FBE6407EA318E883E0FDD84A4D8E9191900638EDB482DB1736D39E7EDFD9 
WHERE product_id = 4

Thanks.

--
__________________________________________________________________________
                                  "They that can give up essential liberty
Mark J. Lilback                    to obtain a little temporary safety
<[EMAIL PROTECTED]>                 deserve neither liberty or safety."
http://www.lilback.com/                               -- Benjamin Franklin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]