On Thu, Aug 9, 2007, Jesse Norell <[EMAIL PROTECTED]> said: > On Thu, 2007-08-09 at 08:35 -0700, Aaron Stone wrote: >> However I am considering just slurping the entire result set into >> memory >> at level of auth_check_user_ext recursion. One would need an absurd >> number of improperly recursive aliases for this to be a problem. >> Thinking of a heuristic to work defensively around such a situation. > > Keep a list of the alias_idnr and an already_seen flag so you never > follow a given alias expansion more than once? (Or maybe that's how > it's handled with the "old" way.)
A more involved rewrite is probably not a bad idea. In particular, I started thinking about self-join schemes; the problem with them is that they only go to a particular level of depth (the number of joins in the query). Well, I bet that 1 and 2 levels deep is the vast majority of everyone's aliases. If we can do them in one query, so much the better. It would leave a much smaller list of aliases that have to be traversed recursively one-by-one. Aaron _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
