Artifact 2df8e511fd162db7f6e89651031e17f751b0d7b0:

Ticket change [2df8e511fd] - Ticket [2ee159304e] Error in timeline (armv5tel-linux) showing events status still Open with 1 other change by anonymous 2010-11-30 20:33:57.

---

D 2010-11-30T20:33:57
J +comment \n\n<hr\s/><i>anonymous\sclaiming\sto\sbe\sviric\sadded\son\s2010-11-30\s20:33:57:</i><br\s/>\nSo,\smanifest_parse\sincludes:\r\n<verbatim>\r\n\s\s\s\s\s\s\s\sp->rDate\s=\sdb_double(0.0,\s"SELECT\sjulianday(%Q)",\snext_token(&x,0));\r\n</verbatim>\r\n\r\nWhile\sthe\stag_insert\scalled\sin\smanifest_crosslink()\sdoes:\r\n<verbatim>\r\n\s\sdb_prepare(&s,\r\n\s\s\s\s"REPLACE\sINTO\stagxref(tagid,tagtype,srcId,origid,value,mtime,rid)"\r\n\s\s\s\s"\sVALUES(%d,%d,%d,%d,%Q,:mtime,%d)",\r\n\s\s\s\stagid,\stagtype,\ssrcId,\srid,\szValue,\srid\r\n\s\s);\r\n\s\sdb_bind_double(&s,\s":mtime",\smtime);\r\n</verbatim>\r\n\r\nWhile\sthe\scall\sat\smanifest_crosslink()\sdoes:\r\n<verbatim>\r\n\s\s\s\sprior\s=\sdb_int(0,\r\n\s\s\s\s\s\s"SELECT\srid\sFROM\stagxref"\r\n\s\s\s\s\s\s"\sWHERE\stagid=%d\sAND\smtime<%.17g"\r\n\s\s\s\s\s\s"\sORDER\sBY\smtime\sDESC",\r\n\s\s\s\s\s\stagid,\sp->rDate\r\n\s\s\s\s);\r\n</verbatim>\r\n\r\nI\sthink\sthat\sthe\s<tt>%.17g</tt>\sprintf\skind\sof\sprompt\sshould\sbe\smoved\sinto\sdb_bind_double,\sas\sbefore.\sOtherwise\sthere\smay\sbe\srounding\sproblems,\slike\sthose\sI\sam\sexperiencing.\r\n\r\nNotice\sthat\sthe\stag_insert\sresulted,\sin\sboth\scomputers,\sin:\r\n<verbatim>\r\nREPLACE\sINTO\stagxref(tagid,tagtype,srcId,origid,value,mtime,rid)\sVALUES(11,1,74,74,'365',2455525.42240741,74);\r\n</verbatim>\r\n\r\nWhile\sthe\sprintf-style\sSQL\squeries\swith\s<tt>%.17g</tt>\shad\sdifferent\sresults\sin\sthe\stwo\scomputers.
K 2ee159304e721349aae20e7a8155c7e6c2b041a9
U anonymous
Z d934b39c9b29a7bd9425964be245399d