[Nitro] Postgres failures in Og test suite.
bryan.a.soto at gmail.com
Thu Apr 6 02:22:22 EDT 2006
Because some of the tickets/patches we have are specifically for the
Postgres store, I need the test suite running so I know if they break
things. And so, I begin my new project.
With the postgres join table patch I sent earlier, I get to here.
E, [2006-04-05T22:23:56.328000 #4784] ERROR -- : DB error ERROR:
column "o.title" must appear in the GROUP BY clause or be used in an
aggregate function, [
ogglue_tag AS t,
ogtestogtaggable_article as o,
ogj_glue_tag_testogtaggable_article as j
WHERE o.oid = j.article_oid
AND t.oid = j.tag_oid
AND (t.name in ('navel','gmosx'))
GROUP BY j.article_oid
HAVING COUNT(j.article_oid) = 2;
Google explained to me that Postgres is a stickler and that it
requires the o.* fields to be in the group by clause. I don't know
that we have access to this info in taggable. That'll be the first way
I try to solve this, but perhaps there is a trick to make this work
one of you Postgres wizards know?
A snippet of the backtrace from the above:
E, [2006-04-05T23:08:14.000000 #6132] ERROR -- : K:/nitro.pristine/og/lib/og/sto
I renamed the file to keep the test from running and then I got the
suite to pass with the following results.
NoMethodError: undefined method `to_f' for ["58"]:Array
<TC_OgInheritance::Photo> expected but was
<2> expected but was
<false> is not true.
43 tests, 216 assertions, 3 failures, 1 errors
The failure in number 4 is an incorrect test, in my opinion, and
should be removed. But the rest aren't.
Anyway, if someone has nothing to do, please help a postgres novice. :)
"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