Обсуждение: query dumping core

Поиск
Список
Период
Сортировка

query dumping core

От
Bruce Momjian
Дата:
Here it is.  I think Tom mentioned this problem.

---------------------------------------------------------------------------


select date_trunc('month',transdate), sum(quantity) from wolf group by
1 order by 1\g
pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
We have lost the connection to the backend, so further processing is
impossible.  Terminating.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: [HACKERS] query dumping core

От
Tom Lane
Дата:
Bruce Momjian <maillist@candle.pha.pa.us> writes:
> Here it is.  I think Tom mentioned this problem.

> select date_trunc('month',transdate), sum(quantity) from wolf group by
> 1 order by 1
> pqReadData() -- backend closed the channel unexpectedly.

Yeah, this is another one of the GROUP-BY-nontrivial-expression
problems.  I'm on it.  It looks like the HAVING patch broke the
interaction between union_planner() and make_groupPlan().
I'm trying to restructure that code in a way that's more
intelligible, as well as correct...
        regards, tom lane