@Abilio
Luuk's description sums it up pretty well. To be precise, SQLite offers a
recursive WITH clause (CTE). "Recursive *aggregate*" refers to the use of
aggregate functions inside the WITH clause on columns of the table
recursively built by the WITH clause.

The thread is so long partly because it took me some time to understand the
implication of not disabling aggregate functions in the recursive WITH, not
because it is particularly important.

I dont't consider SQLite buggy because the recursive CTE doesn't work as
expected with aggregate functions in certain contexts, even less now that
the aggregate functions have been disabled. Standard recursive common table
expressions work very well.

For my part, I consider this subject closed. Thanks to everybody for their
contribution.

On Sun, Sep 13, 2015 at 9:45 AM, Abilio Marques <abiliojr at gmail.com> wrote:

> This is for making a quick question and leaving a note:
> ??
>
> What is a recursive aggregate query? What is it useful for? Been using SQL
> for a while, and is the first time I face the term. I even used Oracle for
> a year and a half, and never saw a CONNECT BY (seems to be a proprietary
> equivalent) in all the queries I ever saw (I did code maintenance from time
> to time).
>
> I keep reading at this thread, and I see it becoming longer and longer, so
> I'm starting to believe "recursive aggregate queries" must be important
> somehow. As I'm a dummy, I read the Wikipedia entry for it, and I'm still
> at the same place... As I never saw the need for this kind of solution in
> my life, I believe I must see a rather interesting (and useful) example to
> actually dig the idea. Any place I can find it?
>
> By the way, as a note, the Wikipedia entry does mention CTE support from
> SQLite 3.8.3 onwards, and as I'm a bit confused by this thread right now,
> I'm not sure if CTEs and recursive queries go hand in hand, and I'm not
> sure if it's CTE as a whole or just recursive queries which are faulty in
> SQLite...
>
> To cut straight to the point, maybe Wikipedia shouldn't mention SQLite (if
> it's really buggy), and I believe someone with the understanding of the
> SQLite reality perhaps should go and edit the article:
>
> https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL
>
> I can do it myself, but I need confirmation from someone else.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Aurel Wisse
(514) 814-5421

Reply via email to