EXEC_EVALDEBUG debugging broken?

Поиск
Список
Период
Сортировка
От peter.trautmeier@gmx.de
Тема EXEC_EVALDEBUG debugging broken?
Дата
Msg-id 20070724093606.6420@gmx.net
обсуждение исходный текст
Ответы Re: EXEC_EVALDEBUG debugging broken?
Список pgsql-hackers
Hi all,

I am using version 8.2.4 of the source and compiled it with
both OPTIMIZER_DEBUG and EXEC_EVALDEBUG enabled to take a look
at how quals are evaluated by the executor.

However, when I issue a query like

SELECT name FROM city WHERE population < 100000 LIMIT 10;

I get the following debug output from postgres:

After canonicalize_qual()  {OPEXPR   :opno 97   :opfuncid 66   :opresulttype 16   :opretset false   :args (     {VAR
 :varno 1      :varattno 4      :vartype 23      :vartypmod -1      :varlevelsup 0      :varnoold 1      :varoattno 4
 }     {CONST      :consttype 23      :constlen 4      :constbyval true      :constisnull false      :constvalue 4 [
-96-122 1 0 ]     }  )  }
 

RELOPTINFO (1): rows=1018 width=88       baserestrictinfo: city.population < 100000       path list:       SeqScan(1)
rows=1018cost=0.00..66.16
 
       cheapest startup path:       SeqScan(1) rows=1018 cost=0.00..66.16
       cheapest total path:       SeqScan(1) rows=1018 cost=0.00..66.16

WARNING:  could not dump unrecognized node type: 404
ExecQual: qual is (  {  }
)


WARNING:  could not dump unrecognized node type: 404
ExecQual: qual is (  {  }
)

... and many more of this WARNINGs.

What happens to the OpExpr on its way from canonicalize_qual() to ExecQual() that makes _outNode() stumble over it when
itis encounteredin ExecQual()?
 

Regards,
Peter


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: GucContext of log_autovacuum
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: avoiding WAL logging in 8.3