[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    Concat to long fields not always working?
From:       jim () rubylane ! com
Date:       2000-12-07 1:56:13
[Download RAW message or body]

We are sometimes seeing field corruption when concatenating to a long
varchar field, for example, here is the SQL that updated a field:

[03/Dec/2000:17:34:47 -0800][1601.1807][rl] Notice: SQL(UPipe SOLID):  update \
itemhistory set  comment=comment || ' {replytext {Hi there:^M  sure can send them \
together but what else did you buy! I have no other outstanding orders and Bid Pay \
only sent payment for the item and not the shipping... so... what is the other \
item..... HELP....^M Nancie Mann^M
Ruby Lane shop AsianArts^M
http://asianarts.rubylane.com}} {email xxx@xx.com} {name {Crystal Watson}} {entrydate \
{2000-12-03 17:34:46}} ',datechanged=now(),refuserid=104314 where \
shopnickname='asianarts' and itemid='39' and entrydate='2000-12-03 16:53:53'


After this update, the comment field contains this:

select comment from itemhistory where shopnickname='asianarts' and itemid='39' and \
datechanged='2000-12-05 09:09:10'; COMMENT            
-------            
 {replytext {Hi there:
 sure can send them together but what else did you buy! I have no other outstanding \
orders and Bid Pay only sent payment for the item and not the shipping... so... what \
is the other item..... HELP.... Nancie Mann
Ruby Lane shop Aw<division symbol here>
1 rows fetched.


So we try to update it by hand:

update itemhistory set comment=concat(comment,'Add more') where \
shopnickname='asianarts' and itemid='39' and datechanged='2000-12-05 09:09:10'; \
Command completed succesfully, 1 rows affected.


Now it is still unchanged:

select comment from itemhistory where shopnickname='asianarts' and itemid='39' and \
datechanged='2000-12-05 09:09:10'; COMMENT            
-------            
 {replytext {Hi there:
 sure can send them together but what else did you buy! I have no other outstanding \
orders and Bid Pay only sent payment for the item and not the shipping... so... what \
is the other item..... HELP.... Nancie Mann
Ruby Lane shop Aw<division symbol here>
1 rows fetched.


We are using:
 SOLID SQL Editor (teletype) v.02.30.0039
on Linux 2.2.17.

Does anyone understand this?  Often times it works, sometimes it does
not.

Thanks,
Jim
www.rubylane.com


[prev in list] [next in list] [prev in thread] [next in thread]