Bugs item #2852928, was opened at 2009-09-06 15:34 Message generated for change (Tracker Item Submitted) made by yingying You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2852928&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 "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Ying Zhang (yingying) Assigned to: Nobody/Anonymous (nobody) Summary: PF: updates broken using algebra front-end? Initial Comment: On my CWI desktop machine, using latest stable branch (monetdb-install.sh --enable-xquery --enable-optimize --nightly=stable --prefix='...'), using the algebra front-end, all updates (insert, delete, rename, replace) gives error, *after* updates have been applied to the document: $ Mserver --dbinit='module(pathfinder);' --set xquery_cacheMB=0 --dbname='blah' # MonetDB Server v4.32.0 # based on GDK v1.32.0 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.13.0 loaded. http://dbappl.cs.utwente.nl/pftijah # MonetDB/XQuery module v0.28.3 loaded (default back-end is 'algebra') # XRPC administrative console at http://127.0.0.1:50001/admin MonetDB>shred_doc("/ufs/zhang/tmp/hello.xml" , "hello.xml", "hello", 10LL); # shredding with holes: pagesize=16384, #fillsize=14746 # Elapsed time = 024ms 888us [001ms 382us/node] # Shredded 1 XML document (hello.xml), total time after commit=0.038s MonetDB> $ mclient -lx -t xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo>text of node foo<bar>text of node bar</bar></foo> <!-- a comment node --> <?pi action=beep?> <world/> <path>\asfda\asdfasf\asdf</path> </hello> Trans 3.270 msec Shred 1.991 msec Query 8.308 msec Print 0.237 msec Timer 16.923 msec xquery>do insert <a/> into doc("hello.xml")/hello more><> MAPI = mone...@localhost:50000 QUERY = do insert <a/> into doc("hello.xml")/hello ERROR = !ERROR: interpret: no matching MIL operator to '-(lng, void)'. !MAYBE YOU MEAN: ! -(dbl) : dbl ! -(lng) : lng ! -(flt) : flt ! -(wrd) : wrd ! -(int) : int ! -(sht) : sht ! -(bte) : bte ! -(chr) : chr ! -(lng, dbl) : dbl ! -(lng, flt) : dbl ! -(lng, lng) : lng ! -(lng, wrd) : lng ! -(lng, int) : lng ! -(lng, sht) : lng ! -(lng, bte) : lng ! -(lng, chr) : lng ! -(dbl, dbl) : dbl ! -(dbl, flt) : dbl ! -(dbl, lng) : dbl ! -(dbl, wrd) : dbl ! -(dbl, int) : dbl ! -(dbl, sht) : dbl ! -(dbl, bte) : dbl ! -(dbl, chr) : dbl ! -(flt, dbl) : dbl ! -(flt, flt) : flt ! -(flt, lng) : flt ! -(flt, wrd) : flt ! -(flt, int) : flt ! -(flt, sht) : flt ! -(flt, bte) : flt ! -(flt, chr) : flt ! -(wrd, dbl) : dbl ! -(wrd, flt) : flt ! -(wrd, lng) : lng ! -(wrd, wrd) : wrd ! -(wrd, int) : wrd ! -(wrd, sht) : wrd ! -(wrd, bte) : wrd ! -(wrd, chr) : wrd ! -(int, dbl) : dbl ! -(int, flt) : flt ! -(int, lng) : lng ! -(int, wrd) : wrd ! -(int, int) : int ! -(int, sht) : int ! -(int, bte) : int ! -(int, chr) : int ! -(sht, dbl) : dbl ! -(sht, flt) : flt ! -(sht, lng) : lng ! -(sht, wrd) : wrd ! -(sht, int) : int ! -(sht, sht) : sht ! -(sht, bte) : sht ! -(sht, chr) : sht ! -(bte, dbl) : dbl ! -(bte, flt) : flt ! -(bte, lng) : lng ! -(bte, wrd) : wrd ! -(bte, int) : int ! -(bte, sht) : sht ! -(bte, chr) : bte ! -(bte, bte) : bte ! -(chr, dbl) : dbl ! -(chr, flt) : flt ! -(chr, lng) : lng ! -(chr, wrd) : wrd ! -(chr, int) : int ! -(chr, sht) : sht ! -(chr, bte) : bte ! -(chr, chr) : chr Timer 63.229 msec xquery>do delete doc("hello.xml")//world more><> MAPI = mone...@localhost:50000 QUERY = do delete doc("hello.xml")//world ERROR = !ERROR: interpret: no matching MIL operator to '-(lng, void)'. !MAYBE YOU MEAN: ! -(dbl) : dbl ! -(lng) : lng ! -(flt) : flt ! -(wrd) : wrd ! -(int) : int ! -(sht) : sht ! -(bte) : bte ! -(chr) : chr ! -(lng, dbl) : dbl ! -(lng, flt) : dbl ! -(lng, lng) : lng ! -(lng, wrd) : lng ! -(lng, int) : lng ! -(lng, sht) : lng ! -(lng, bte) : lng ! -(lng, chr) : lng ! -(dbl, dbl) : dbl ! -(dbl, flt) : dbl ! -(dbl, lng) : dbl ! -(dbl, wrd) : dbl ! -(dbl, int) : dbl ! -(dbl, sht) : dbl ! -(dbl, bte) : dbl ! -(dbl, chr) : dbl ! -(flt, dbl) : dbl ! -(flt, flt) : flt ! -(flt, lng) : flt ! -(flt, wrd) : flt ! -(flt, int) : flt ! -(flt, sht) : flt ! -(flt, bte) : flt ! -(flt, chr) : flt ! -(wrd, dbl) : dbl ! -(wrd, flt) : flt ! -(wrd, lng) : lng ! -(wrd, wrd) : wrd ! -(wrd, int) : wrd ! -(wrd, sht) : wrd ! -(wrd, bte) : wrd ! -(wrd, chr) : wrd ! -(int, dbl) : dbl ! -(int, flt) : flt ! -(int, lng) : lng ! -(int, wrd) : wrd ! -(int, int) : int ! -(int, sht) : int ! -(int, bte) : int ! -(int, chr) : int ! -(sht, dbl) : dbl ! -(sht, flt) : flt ! -(sht, lng) : lng ! -(sht, wrd) : wrd ! -(sht, int) : int ! -(sht, sht) : sht ! -(sht, bte) : sht ! -(sht, chr) : sht ! -(bte, dbl) : dbl ! -(bte, flt) : flt ! -(bte, lng) : lng ! -(bte, wrd) : wrd ! -(bte, int) : int ! -(bte, sht) : sht ! -(bte, chr) : bte ! -(bte, bte) : bte ! -(chr, dbl) : dbl ! -(chr, flt) : flt ! -(chr, lng) : lng ! -(chr, wrd) : wrd ! -(chr, int) : int ! -(chr, sht) : sht ! -(chr, bte) : bte ! -(chr, chr) : chr Timer 39.003 msec xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo>text of node foo<bar>text of node bar</bar></foo> <!-- a comment node --> <?pi action=beep?> ^^^^^^^^^^^^^^^^^ '<world/>' has been deleted <path>\asfda\asdfasf\asdf</path> <a/></hello> ^^^^^ previous insertion was applied Trans 3.279 msec Shred 1.957 msec Query 8.039 msec Print 0.247 msec Timer 16.519 msec xquery>do rename doc("hello.xml")//foo into "foo2" more><> MAPI = mone...@localhost:50000 QUERY = do rename doc("hello.xml")//foo into "foo2" ERROR = !ERROR: interpret: no matching MIL operator to '-(lng, void)'. !MAYBE YOU MEAN: ! -(dbl) : dbl ! -(lng) : lng ! -(flt) : flt ! -(wrd) : wrd ! -(int) : int ! -(sht) : sht ! -(bte) : bte ! -(chr) : chr ! -(lng, dbl) : dbl ! -(lng, flt) : dbl ! -(lng, lng) : lng ! -(lng, wrd) : lng ! -(lng, int) : lng ! -(lng, sht) : lng ! -(lng, bte) : lng ! -(lng, chr) : lng ! -(dbl, dbl) : dbl ! -(dbl, flt) : dbl ! -(dbl, lng) : dbl ! -(dbl, wrd) : dbl ! -(dbl, int) : dbl ! -(dbl, sht) : dbl ! -(dbl, bte) : dbl ! -(dbl, chr) : dbl ! -(flt, dbl) : dbl ! -(flt, flt) : flt ! -(flt, lng) : flt ! -(flt, wrd) : flt ! -(flt, int) : flt ! -(flt, sht) : flt ! -(flt, bte) : flt ! -(flt, chr) : flt ! -(wrd, dbl) : dbl ! -(wrd, flt) : flt ! -(wrd, lng) : lng ! -(wrd, wrd) : wrd ! -(wrd, int) : wrd ! -(wrd, sht) : wrd ! -(wrd, bte) : wrd ! -(wrd, chr) : wrd ! -(int, dbl) : dbl ! -(int, flt) : flt ! -(int, lng) : lng ! -(int, wrd) : wrd ! -(int, int) : int ! -(int, sht) : int ! -(int, bte) : int ! -(int, chr) : int ! -(sht, dbl) : dbl ! -(sht, flt) : flt ! -(sht, lng) : lng ! -(sht, wrd) : wrd ! -(sht, int) : int ! -(sht, sht) : sht ! -(sht, bte) : sht ! -(sht, chr) : sht ! -(bte, dbl) : dbl ! -(bte, flt) : flt ! -(bte, lng) : lng ! -(bte, wrd) : wrd ! -(bte, int) : int ! -(bte, sht) : sht ! -(bte, chr) : bte ! -(bte, bte) : bte ! -(chr, dbl) : dbl ! -(chr, flt) : flt ! -(chr, lng) : lng ! -(chr, wrd) : wrd ! -(chr, int) : int ! -(chr, sht) : sht ! -(chr, bte) : bte ! -(chr, chr) : chr Timer 76.213 msec xquery>doc("hello.xml")/hello more><> <hello x="y" lang="en"> <foo2>text of node foo<bar>text of node bar</bar></foo2> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ rename has been done <!-- a comment node --> <?pi action=beep?> <path>\asfda\asdfasf\asdf</path> <a/></hello> Trans 4.082 msec Shred 1.931 msec Query 11.054 msec Print 0.261 msec Timer 20.973 msec xquery>do replace doc("hello.xml")//bar with <noot/> more><> MAPI = mone...@localhost:50000 QUERY = do replace doc("hello.xml")//bar with <noot/> ERROR = !ERROR: interpret: no matching MIL operator to '-(lng, void)'. !MAYBE YOU MEAN: ! -(dbl) : dbl ! -(lng) : lng ! -(flt) : flt ! -(wrd) : wrd ! -(int) : int ! -(sht) : sht ! -(bte) : bte ! -(chr) : chr ! -(lng, dbl) : dbl ! -(lng, flt) : dbl ! -(lng, lng) : lng ! -(lng, wrd) : lng ! -(lng, int) : lng ! -(lng, sht) : lng ! -(lng, bte) : lng ! -(lng, chr) : lng ! -(dbl, dbl) : dbl ! -(dbl, flt) : dbl ! -(dbl, lng) : dbl ! -(dbl, wrd) : dbl ! -(dbl, int) : dbl ! -(dbl, sht) : dbl ! -(dbl, bte) : dbl ! -(dbl, chr) : dbl ! -(flt, dbl) : dbl ! -(flt, flt) : flt ! -(flt, lng) : flt ! -(flt, wrd) : flt ! -(flt, int) : flt ! -(flt, sht) : flt ! -(flt, bte) : flt ! -(flt, chr) : flt ! -(wrd, dbl) : dbl ! -(wrd, flt) : flt ! -(wrd, lng) : lng ! -(wrd, wrd) : wrd ! -(wrd, int) : wrd ! -(wrd, sht) : wrd ! -(wrd, bte) : wrd ! -(wrd, chr) : wrd ! -(int, dbl) : dbl ! -(int, flt) : flt ! -(int, lng) : lng ! -(int, wrd) : wrd ! -(int, int) : int ! -(int, sht) : int ! -(int, bte) : int ! -(int, chr) : int ! -(sht, dbl) : dbl ! -(sht, flt) : flt ! -(sht, lng) : lng ! -(sht, wrd) : wrd ! -(sht, int) : int ! -(sht, sht) : sht ! -(sht, bte) : sht ! -(sht, chr) : sht ! -(bte, dbl) : dbl ! -(bte, flt) : flt ! -(bte, lng) : lng ! -(bte, wrd) : wrd ! -(bte, int) : int ! -(bte, sht) : sht ! -(bte, chr) : bte ! -(bte, bte) : bte ! -(chr, dbl) : dbl ! -(chr, flt) : flt ! -(chr, lng) : lng ! -(chr, wrd) : wrd ! -(chr, int) : int ! -(chr, sht) : sht ! -(chr, bte) : bte ! -(chr, chr) : chr Timer 55.182 msec xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo2>text of node foo<noot/></foo2> ^^^^^^^^^ replace has been done <!-- a comment node --> <?pi action=beep?> <path>\asfda\asdfasf\asdf</path> <a/></hello> Trans 4.688 msec Shred 1.965 msec Query 8.381 msec Print 0.244 msec Timer 17.948 msec Could someone please check if this could be reproduced? FYI, the updates work fine with the MPS front-end (for this mclient session, the doc. has been deleted and re-shredded): $ mclient -lx -t -g xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo>text of node foo<bar>text of node bar</bar></foo> <!-- a comment node --> <?pi action=beep?> <world/> <path>\asfda\asdfasf\asdf</path> </hello> Trans 9.883 msec Shred 7.381 msec Query 2.549 msec Print 0.832 msec Timer 25.371 msec xquery>do insert <a/> into doc("hello.xml")/hello more><> Trans 11.521 msec Shred 5.279 msec Query 16.776 msec Update 18.536 msec Timer 62.439 msec xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo>text of node foo<bar>text of node bar</bar></foo> <!-- a comment node --> <?pi action=beep?> <world/> <path>\asfda\asdfasf\asdf</path> <a/></hello> Trans 4.615 msec Shred 5.154 msec Query 2.556 msec Print 0.819 msec Timer 16.668 msec xquery>do delete doc("hello.xml")//world more><> Trans 5.566 msec Shred 5.344 msec Query 5.401 msec Update 12.175 msec Timer 35.438 msec xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo>text of node foo<bar>text of node bar</bar></foo> <!-- a comment node --> <?pi action=beep?> <path>\asfda\asdfasf\asdf</path> <a/></hello> Trans 4.419 msec Shred 5.135 msec Query 2.547 msec Print 0.826 msec Timer 16.462 msec xquery>do rename doc("hello.xml")//foo into 'foo2' more><> Trans 5.700 msec Shred 5.329 msec Query 5.074 msec Update 13.145 msec Timer 36.176 msec xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo2>text of node foo<bar>text of node bar</bar></foo2> <!-- a comment node --> <?pi action=beep?> <path>\asfda\asdfasf\asdf</path> <a/></hello> Trans 4.407 msec Shred 5.168 msec Query 2.566 msec Print 0.860 msec Timer 16.514 msec xquery>do replace doc("hello.xml")//bar with <noot/> more><> Trans 7.433 msec Shred 5.321 msec Query 8.120 msec Update 15.398 msec Timer 47.425 msec xquery>doc("hello.xml") more><> <?xml version="1.0" encoding="utf-8"?> <hello x="y" lang="en"> <foo2>text of node foo<noot/></foo2> <!-- a comment node --> <?pi action=beep?> <path>\asfda\asdfasf\asdf</path> <a/></hello> Trans 4.410 msec Shred 5.160 msec Query 2.584 msec Print 0.855 msec Timer 16.553 msec xquery>\q Regards, Jennie ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2852928&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
