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.