Re: [gnome-db] MySQL hex to blob marking as unknown node

--===============7858605701790758753==
Content-Type: multipart/alternative; boundary=001a11c37656dab410052aba344a

--001a11c37656dab410052aba344a
Content-Type: text/plain; charset=UTF-8

Hi!

Sorry for taking so long to answer...
Libgda's internal parser does not recognize that syntax, hence the result.
The parser could probably quite easily corrected, but it was never meant to
be a comprehensive parser (in the way that some specific SQL constructs are
not and will probably never be recognized); it was meant to be able to
actually distinguish in many cases the type of SQL query.

Regards,
Vivien


2016-01-14 22:49 GMT+01:00 Arthur Neves <[email protected]>:

> Hi everyone,
> I am using libgda to parse some queries from my application, however I am
> confused about a few queries been marked as unknown (top level node).
> Seems like that queries that include a x'' syntax, which is valid on mysql
> are marked as unknown. Follow an example code:
> https://gist.github.com/arthurnn/a5056d644e5b0076bec5 , This is hitting
> the UNKNOWN branch. Not sure where the problem is. Any clue?
>
> Thanks a lot
>
> _______________________________________________
> gnome-db-list mailing list
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnome-db-list
>
>

--001a11c37656dab410052aba344a
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">Hi!<br><br></div><div class=3D"gmail_default" style=3D"=
font-family:arial,helvetica,sans-serif">Sorry for taking so long to answer.=
..<br></div><div class=3D"gmail_default" style=3D"font-family:arial,helveti=
ca,sans-serif">Libgda&#39;s internal parser does not recognize that syntax,=
 hence the result.<br></div><div class=3D"gmail_default" style=3D"font-fami=
ly:arial,helvetica,sans-serif">The parser could probably quite easily corre=
cted, but it was never meant to be a comprehensive parser (in the way that =
some specific SQL constructs are not and will probably never be recognized)=
; it was meant to be able to actually distinguish in many cases the type of=
 SQL query.<br><br></div><div class=3D"gmail_default" style=3D"font-family:=
arial,helvetica,sans-serif">Regards,<br></div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif">Vivien<br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">2016-01-=
14 22:49 GMT+01:00 Arthur Neves <span dir=3D"ltr">&lt;<a href=3D"mailto:art=
[email protected]" target=3D"_blank">[email protected]</a>&gt;</span>:<br><b=
lockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px =
#ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>Hi everyone,=C2=A0</div>=
<div>I am using libgda to parse some queries from my application, however I=
 am confused about a few queries been marked as unknown (top level node).=
=C2=A0</div><div>Seems like that queries that include a x&#39;&#39; syntax,=
 which is valid on mysql are marked as unknown. Follow an example code: <a =
href=3D"https://gist.github.com/arthurnn/a5056d644e5b0076bec5" target=3D"_b=
lank">https://gist.github.com/arthurnn/a5056d644e5b0076bec5</a>=C2=A0, This=
 is hitting the UNKNOWN branch. Not sure where the problem is. Any clue?</d=
iv><div><br></div><div>Thanks a lot=C2=A0</div></div>
<br>_______________________________________________<br>
gnome-db-list mailing list<br>
<a href=3D"mailto:[email protected]">[email protected]</a><br>
<a href=3D"https://mail.gnome.org/mailman/listinfo/gnome-db-list" rel=3D"no=
referrer" target=3D"_blank">https://mail.gnome.org/mailman/listinfo/gnome-d=
b-list</a><br>
<br></blockquote></div><br></div>

--001a11c37656dab410052aba344a--

--===============7858605701790758753==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
gnome-db-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnome-db-list

--===============7858605701790758753==--