Bugs item #2792307, was opened at 2009-05-15 16:56 Message generated for change (Comment added) made by sjoerd 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 ] ---------------------------------------------------------------------- >Comment By: Sjoerd Mullender (sjoerd) Date: 2009-06-11 16:29 Message: What is the expected output of your script? When I run it, I get three times two bats. The first is a 50 element void-str bat where all tail values are the string "0", and the second is a void-oid bat where all tail values are 0...@0. And this repeated three times. This is on an up-to-date stable version. ---------------------------------------------------------------------- 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
