[Nitro] Postgres failures in Og test suite.

Bryan Soto bryan.a.soto at gmail.com
Thu Apr 6 21:02:04 EDT 2006


On 4/6/06, Bryan Soto <bryan.a.soto at gmail.com> wrote:
> On 4/6/06, Kashia Buch <kashia at vfemail.net> wrote:
> > sql = %{
> >          SELECT *
> >          FROM #{info[:owner_table]} AS o
> >          WHERE o.oid IN (
> >            SELECT j.#{info[:owner_key]}
> >            FROM #{info[:target_table]} AS t
> >            JOIN #{info[:table]} AS j
> >            ON t.oid = j.#{info[:target_key]}
> >            WHERE (t.name IN (#{names})
> >          )
> >          GROUP BY j.#{info[:owner_key]}
> >        }
> >

Thanks Kashia, I just needed to add a closing parenthesis. I'm going
to see if subselects work with sqlite and mysql, if not I'm just going
to make it conditional. One way or the other, I should be sending out
a postgres patch tonight.

--
"Never tell people how to do things. Tell them what to do and they
will surprise you with their ingenuity." —General George S. Patton




More information about the Nitro-general mailing list