Re: BUG #4113: server closed the connection unexpectedly

Javier Hernandez wrote:

> select * from numeric_col_table where num_col in (select int_col from
> int_col_table);

#0  0x0000000000752368 in pg_detoast_datum (datum=0x1)
    at /pgsql/source/00head/src/backend/utils/fmgr/fmgr.c:2101
#1  0x00000000006bf8bc in hash_numeric (fcinfo=0x7fffc5140550)
    at /pgsql/source/00head/src/backend/utils/adt/numeric.c:1163
#2  0x000000000075081f in FunctionCall1 (flinfo=0xc65688, arg1=1)
    at /pgsql/source/00head/src/backend/utils/fmgr/fmgr.c:1250
#3  0x00000000005898c1 in TupleHashTableHash (key=0x7fffc51409f0, keysize=8)
    at /pgsql/source/00head/src/backend/executor/execGrouping.c:513
#4  0x00000000007550ee in hash_search (hashp=0xc6aec8, keyPtr=0x7fffc51409f0, action=HASH_ENTER,
    foundPtr=0x7fffc51409ef "") at /pgsql/source/00head/src/backend/utils/hash/dynahash.c:791
#5  0x0000000000589635 in LookupTupleHashEntry (hashtable=0xc68eb8, slot=0xc63078,
    isnew=0x7fffc5140a6f "") at /pgsql/source/00head/src/backend/executor/execGrouping.c:368
#6  0x000000000059e2e3 in lookup_hash_entry (aggstate=0xc64490, inputslot=0xc63138)
    at /pgsql/source/00head/src/backend/executor/nodeAgg.c:777
#7  0x000000000059e701 in agg_fill_hash_table (aggstate=0xc64490)
    at /pgsql/source/00head/src/backend/executor/nodeAgg.c:1028
#8  0x000000000059e35e in ExecAgg (node=0xc64490)
    at /pgsql/source/00head/src/backend/executor/nodeAgg.c:812


So what's happening here is that it's writing the hash table using the
wrong datatype ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support