[gnome-db] [PATCH] support for inner queries alias without the `AS`.
Arthur Neves <[email protected]> Wed, 03 Feb 2016 21:39:20 +0000
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <CAA6kw-8viW4zdD1N9ZpGZnEA-+mGUYQSpb4UhF1nbjWVCmWuqw@mail.gmail.com> |
--===============9110314525802569968==
Content-Type: multipart/alternative; boundary=001a113eb60a00a604052ae4747e
--001a113eb60a00a604052ae4747e
Content-Type: text/plain; charset=UTF-8
Hi folks,
I am using libgda to parse all queries on my app, however I saw that
sub-queries that had an alias were not working, for instance:
SELECT foo.abc FROM (select abc from bar) foo;
See this is valid on sqlite3:
sqlite> create table bar(abc varchar(10));
sqlite> insert into bar values('hi');
sqlite> SELECT foo.abc FROM (select abc from bar) foo;
hi
Seems like that syntax was not handled by the parser.y lemon file. So I
have a patch for it:
https://github.com/arthurnn/libgda/commit/0ba0e8f49f90304256e4fca637928d8cad55a1e0
Let me know what is the proper way to contribute to this library, if
sending a Pull Request on GitHub, or sending a .patch file on the mailing
list.
Let me know if this makes sense
Thanks a lot
--001a113eb60a00a604052ae4747e
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div>Hi folks,</div><div><br></div>I am using libgda to pa=
rse all queries on my app, however I saw that sub-queries that had an alias=
were not working, for instance:=C2=A0<div><br><div>=C2=A0 SELECT foo.abc F=
ROM (select abc from bar) foo;</div><div><br></div><div>See this is valid o=
n sqlite3:</div><div><br></div><div><div>sqlite> create table bar(abc va=
rchar(10));</div><div>sqlite> insert into bar values('hi');</div=
><div>sqlite> SELECT foo.abc FROM (select abc from bar) foo;</div><div>h=
i</div></div><div><br></div><div>Seems like that syntax was not handled by =
the parser.y lemon file. So I have a patch for it:=C2=A0</div><div><a href=
=3D"https://github.com/arthurnn/libgda/commit/0ba0e8f49f90304256e4fca637928=
d8cad55a1e0">https://github.com/arthurnn/libgda/commit/0ba0e8f49f90304256e4=
fca637928d8cad55a1e0</a></div><div><br></div><div>Let me know what is the p=
roper way to contribute to this library, if sending a Pull Request on GitHu=
b, or sending a .patch file on the mailing list.</div><div><br></div><div>L=
et me know if this makes sense</div><div><br></div><div>Thanks a lot</div><=
div><br></div><div><br></div></div></div>
--001a113eb60a00a604052ae4747e--
--===============9110314525802569968==
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
--===============9110314525802569968==--