Bugs item #1670732, was opened at 2007-02-28 12:05
Message generated for change (Comment added) made by mr-meltdown
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1670732&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: SQL/JDBC
Group: (zombie: Pathfinder 0.12.0)
>Status: Closed
>Resolution: Out of Date
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Fabian (mr-meltdown)
Summary: XQ/JDBC: escaping backslash

Initial Comment:
NOTE: this applies to 0.12. don't know whether it has been fixed in 0.16, but i 
could not find an earlier bugreport about it. (please close if it was fixed)

When retrieving strings using the JDBC getString(1) from a ResultSet returned 
after executing an XQuery, the backslashes have disappeared. 

When querying using MapiClient the problem does not appear, so I guess the bug 
should be somewhere in the JDBC code.

shred a document like:

<node>c:\tmp\</node>

when querying:

doc("test.xml")/node

and in java calling:

rs.next()
rs.getString(1)

will return (in 0.12):

<node>c:tmp</node>


----------------------------------------------------------------------

>Comment By: Fabian (mr-meltdown)
Date: 2007-03-02 10:40

Message:
Logged In: YES 
user_id=963970
Originator: NO

please test with 0.16

----------------------------------------------------------------------

Comment By: Fabian (mr-meltdown)
Date: 2007-02-28 14:40

Message:
Logged In: YES 
user_id=963970
Originator: NO

Using the client I see some other stuff, so I guess your problem is deeper
under the hood.

(pegasus:portage/mail-client/mutt) fabian% JdbcClient -lxquery
Welcome to the MonetDB interactive JDBC terminal!
Type \q to quit, \h for a list of available commands
auto commit mode: on
monetdb-> 1 + 1
monetdb=>
<xquery>
<result>
  <row>
    <xml>2</xml>
  </row>
</result>
</xquery>

monetdb-> 'bla'
monetdb=>
<xquery>
<result>
  <row>
    <xml>"bla"</xml>
  </row>
</result>
</xquery>


Is it supposed to return " instead of ' here?  Or no quote at all?


monetdb-> 'bl\\a'
monetdb=>
<xquery>
<result>
  <row>
    <xml>"bl\\a"</xml>
  </row>
</result>
</xquery>

monetdb-> "bl\\a"
monetdb=>
<xquery>
<result>
  <row>
    <xml>"bl\\a"</xml>
  </row>
</result>
</xquery>

monetdb->

monetdb-> 'b\a'
monetdb=>
<xquery>
<result>
  <row>
    <xml>"b\a"</xml>
  </row>
</result>
</xquery>

monetdb->


backslashes seem to go well in this part.  But I'm not sure on the quotes.
 Could you generate a JDBC log please, and attach it for your application?

----------------------------------------------------------------------

Comment By: Fabian (mr-meltdown)
Date: 2007-02-28 13:49

Message:
Logged In: YES 
user_id=963970
Originator: NO

I think the bug is as simple as the backslash not being escaped, but I'll
check to be sure.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1670732&group_id=56967

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to