Bugs item #2792307, was opened at 2009-05-15 16:56 Message generated for change (Settings changed) made by boncz 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: Invalid >Priority: 1 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: Peter Boncz (boncz) Date: 2009-11-12 10:25 Message: The script produces input that differs at [ 0...@0, "601998" ] it has there [ 0...@0, "0" ] so it seems something is wrong with this report.. ---------------------------------------------------------------------- Comment By: Jan Rittinger (tsheyar) Date: 2009-06-12 16:07 Message: As you observed correctly the script prints 3 times 2 BATs. The two BATs are input and output to the PROC add_content() that adds strings to the text container and returns the references for all strings. In my up-to-date stable version the first and the second iteration provide an incorrect single line output (see the void-oid BAT in the initial report). The third iteration provides (on my machine) the expected result (a BAT with void head starting from 0...@0 and 49 times 0...@0 and 1 time 3...@0 in the tail). ---------------------------------------------------------------------- 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 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
