Bugs item #2792307, was opened at 2009-05-15 16:56 Message generated for change (Tracker Item Submitted) made by tsheyar You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2792307&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: PF/runtime Group: Pathfinder CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jan Rittinger (tsheyar) Assigned to: Nobody/Anonymous (nobody) Summary: PF: BATjoin on strings incorrect. Initial Comment: I analyzed the failing NFI query (nfi05.xq) and detected the error in a leftjoin in PROC add_content. To me it seems that some properties (the BATjoin relies on) are set incorrectly. Attached you find the annotated MIL script. In the following you see the information and the content of the input BAT of add_content (as well as for the join) and the incorrect output (without matches for the string "0"). #-------------------------------------------------# # h t # name # str str # type #-------------------------------------------------# [ "batId", "tmp_2053" ] [ "batCacheid", "1067" ] [ "hparentid", "0" ] [ "tparentid", "-766" ] [ "batSharecnt", "0" ] [ "batCount", "50" ] [ "batCapacity", "50" ] [ "head", "void" ] [ "tail", "str" ] [ "batPersistence", "transient" ] [ "batRestricted", "read-only" ] [ "batRefcnt", "1" ] [ "batLRefcnt", "1" ] [ "batDirty", "dirty" ] [ "batSet", "0" ] [ "hsorted", "65" ] [ "hident", "h" ] [ "hdense", "1" ] [ "hseqbase", "0...@0" ] [ "hkey", "1" ] [ "hvarsized", "1" ] [ "halign", "2295944" ] [ "hnosorted", "0" ] [ "hnosorted_rev", "0" ] [ "hnodense", "0" ] [ "hnokey[0]", "0" ] [ "hnokey[1]", "0" ] [ "hnonil", "1" ] [ "hnil", "0" ] [ "tident", "t" ] [ "tdense", "0" ] [ "tseqbase", "0...@0" ] [ "tsorted", "0" ] [ "tkey", "0" ] [ "tvarsized", "1" ] [ "talign", "2295952" ] [ "tnosorted", "0" ] [ "tnosorted_rev", "0" ] [ "tnodense", "0" ] [ "tnokey[0]", "0" ] [ "tnokey[1]", "0" ] [ "tnonil", "0" ] [ "tnil", "0" ] [ "batInserted", "0" ] [ "batDeleted", "0" ] [ "batFirst", "0" ] [ "htop", "0" ] [ "ttop", "200" ] [ "batStamp", "-1104" ] [ "lastUsed", "10355727" ] [ "curStamp", "1108" ] [ "batCopiedtodisk", "0" ] [ "batDirtydesc", "dirty" ] [ "H->heap.dirty", "clean" ] [ "T->heap.dirty", "clean" ] [ "head.free", "0" ] [ "head.size", "0" ] [ "head.maxsize", "0" ] [ "head.storage", "absent" ] [ "head.newstorage", "malloced" ] [ "head.filename", "no file" ] [ "tail.free", "200" ] [ "tail.size", "200" ] [ "tail.maxsize", "200" ] [ "tail.storage", "malloced" ] [ "tail.newstorage", "malloced" ] [ "tail.filename", "13/1376.tail" ] [ "H->vheap->dirty", "clean" ] [ "T->vheap->dirty", "clean" ] [ "theap.free", "2074" ] [ "theap.size", "4096" ] [ "theap.maxsize", "4096" ] [ "theap.storage", "malloced" ] [ "theap.newstorage", "malloced" ] [ "theap.filename", "13/1376.theap" ] #-------------------------# # h t # name # void str # type #-------------------------# [ 0...@0, "601998" ] [ 1...@0, "0" ] [ 2...@0, "0" ] [ 3...@0, "0" ] [ 4...@0, "0" ] [ 5...@0, "0" ] [ 6...@0, "0" ] [ 7...@0, "0" ] [ 8...@0, "0" ] [ 9...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 1...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 2...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 3...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] [ 4...@0, "0" ] #-----------------# # h t # name # void oid # type #-----------------# [ 0...@0, 3...@0 ] ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2792307&group_id=56967 ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
