Re: [sqlite] sql syntax grammar: single-source

[Vitali Kiruta]

> This currently works.  But because it is not part of the language spec, we
> do not guarantee that we will continue to support it.

Thanks a lot for quick answer.
Do you mean the sqlite language spec, or the sql standard?

I would be very much in favor of keeping this behavior. It makes
select statement more modular and simplifies sql code generation.

Regards,
Vitali
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sql syntax grammar: single-source

[Richard Hipp]

On Tue, Apr 5, 2011 at 8:30 AM, Vitali Kiruta  wrote:

> Hi everybody,
>
> I hope somebody could clarify this for me. According to the sql
> grammar definition, the single-source production
> does not allow the table-alias after the join-source
>
> See http://www.sqlite.org/syntaxdiagrams.html#single-source
>
> However, when I'm trying to run this query it works just fine:
>
> select t.* from (t1 join t2) as t;
>
> Is it an oversight in the definition or am I missing something?
>

This currently works.  But because it is not part of the language spec, we
do not guarantee that we will continue to support it.


>
> Thanks in advance
> Vitali
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users