Strange behaviour of addref called from shell script (FIXED)

Hi,

I've been working on this problem off-line with Jeremy (thanks for
the ssh access!). Here's a brief summary:

- there were a few sprintf commands that did not work around an OS X
  sprintf bug which I reported a while ago. All these commands were
  fixed
- the real problem for the apparent insert failure was a
  missing prototype for a function which returns a long long
  value. The compiler assumes an 'int' as a return value in this
  case. This is not a problem on Intel/AMD boxes as the significant
  bits are in the same position on the stack, but a PPC processor
  looks at the 'wrong end' of the value and returns zero instead of an
  ID value. Adding the prototype to refdbd.h.in fixes this problem.

I've checked in the fixed header file. An updated prerelease
containing this fix will be available shortly.

regards,
Markus

Jeremy Malcolm writes:
 > Why might refdbd be showing this error (multiplied by 837):
 > 
 > BEGIN
 > LOCK TABLES t_refdb WRITE, t_author WRITE, t_keyword WRITE, t_periodical 
 > WRITE, t_user WRITE, t_xauthor WRITE, t_xkeyword WRITE, t_xuser WRITE, 
 > t_note WRITE, t_xnote WRITE, t_link WRITE, t_xlink WRITE, 
 > refdb.t_journal_words WRITE
 > SELECT refdb_id, refdb_citekey FROM t_refdb WHERE 
 > refdb_citekey='DIJK2000MODELS-OF-DEMOC'
 > INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES 
 > ('DUMMY','DUMMYJeremy-Malcolms-Computer.local11086')
 > 1062: Duplicate entry 'DUMMYJeremy-Malcolms-Computer.local11086' for key 2
 > inserting reference data failed
 > ROLLBACK
 > UNLOCK TABLES
 > failed processing dataset
 > 

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/