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

[Arthur Neves <arthurnn gmail com>]

Interesting, I thought it did, by looking at the code: 

https://github.com/GNOME/libgda/blob/293b3c1a9ae0c0e5f4f6b8997ceb3e48dfab4892/libgda/sql-parser/gda-sql-parser.c#L1435

https://github.com/GNOME/libgda/blob/293b3c1a9ae0c0e5f4f6b8997ceb3e48dfab4892/libgda/sql-parser/gda-sql-parser.c#L1299

I havent debugged it yet to tell for sure if it is a bug or not. But from the code, seems like it was suppose to support that.

Thoughts? If you can confirm it is a bug, I can work in a patch.

Thanks

On Mon, Feb 1, 2016 at 2:15 PM Vivien Malerba <vmalerba gmail com> wrote:

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 <arthurnn gmail com>:

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
gnome-db-list gnome org
https://mail.gnome.org/mailman/listinfo/gnome-db-list