Re: pika failing since the per-column collation patch

On lör, 2011-02-12 at 13:34 +0100, Rémi Zara wrote:
> Since the per-column collation patch went in, pika (NetBSD 5.1/mips) started failing consistently with this diff:
>
> *** /home/pgbuildfarm/workdir/HEAD/pgsql.15101/src/test/regress/expected/polymorphism.out Sat Feb 12 02:16:07 2011
> --- /home/pgbuildfarm/workdir/HEAD/pgsql.15101/src/test/regress/results/polymorphism.out Sat Feb 12 09:10:21 2011
> ***************
> *** 624,630 ****
>
> -- such functions must protect themselves if varying element type isn't OK
> select max(histogram_bounds) from pg_stats;
> ! ERROR: cannot compare arrays of different element types
> -- test variadic polymorphic functions
> create function myleast(variadic anyarray) returns anyelement as $$
> select min($1[i]) from generate_subscripts($1,1) g(i)
> --- 624,630 ----
>
> -- such functions must protect themselves if varying element type isn't OK
> select max(histogram_bounds) from pg_stats;
> ! ERROR: locale operation to be invoked, but no collation was derived
> -- test variadic polymorphic functions
> create function myleast(variadic anyarray) returns anyelement as $$
> select min($1[i]) from generate_subscripts($1,1) g(i)
>
> Is there something I can do to help investigate this ?

It's only failing on this one machine, but there isn't anything
platform-specific in this code, so I'd look for memory management faults
on the code or a compiler problem. Try with lower optimization for a
start.