pgsql: Fix UtilityContainsQuery() to handle CREATE TABLE AS EXECUTE cor - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix UtilityContainsQuery() to handle CREATE TABLE AS EXECUTE cor
Date
Msg-id E1TPL8p-0004UO-JY@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix UtilityContainsQuery() to handle CREATE TABLE AS EXECUTE correctly.

The code seems to have been written to handle the pre-parse-analysis
representation, where an ExecuteStmt would appear directly under
CreateTableAsStmt.  But in reality the function is only run on
already-parse-analyzed statements, so there will be a Query node in
between.  We'd not noticed the bug because the function is generally
not used at all except in extended query protocol.

Per report from Robert Haas and Rushabh Lathia.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/5d1abe64e62f2bb3c1a8a4181974f0b17b8bc21d

Modified Files
--------------
src/backend/tcop/utility.c |   13 ++++---------
1 files changed, 4 insertions(+), 9 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix UtilityContainsQuery() to handle CREATE TABLE AS EXECUTE cor
Next
From: Tom Lane
Date:
Subject: pgsql: Prevent overflow in pgbench's percent-done display.