NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit12b721a

committed

Fix UtilityContainsQuery() to handle CREATE TABLE AS EXECUTE correctly.

The code seems to have been written to handle the pre-parse-analysisrepresentation, where an ExecuteStmt would appear directly underCreateTableAsStmt. But in reality the function is only run onalready-parse-analyzed statements, so there will be a Query node inbetween. We'd not noticed the bug because the function is generallynot used at all except in extended query protocol.Per report from Robert Haas and Rushabh Lathia.

1 parent8a3249f commit12b721aCopy full SHA for 12b721a

File tree

1 file changed

-9

lines changed

src/backend/tcop
- utility.c

1 file changed

-9

lines changed

`‎src/backend/tcop/utility.c`

Lines changed: 4 additions & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -1365,16 +1365,11 @@ UtilityContainsQuery(Node *parsetree)`
`1365`	`1365`	`returnqry;`
`1366`	`1366`
`1367`	`1367`	`caseT_CreateTableAsStmt:`
`1368`		`-/* might or might not contain a Query ... */`
`1369`	`1368`	`qry= (Query) ((CreateTableAsStmt)parsetree)->query;`
`1370`		`-if (IsA(qry,Query))`
`1371`		`-{`
`1372`		`-/* Recursion currently can't be necessary here */`
`1373`		`-Assert(qry->commandType!=CMD_UTILITY);`
`1374`		`-returnqry;`
`1375`		`-}`
`1376`		`-Assert(IsA(qry,ExecuteStmt));`
`1377`		`-returnNULL;`
	`1369`	`+Assert(IsA(qry,Query));`
	`1370`	`+if (qry->commandType==CMD_UTILITY)`
	`1371`	`+returnUtilityContainsQuery(qry->utilityStmt);`
	`1372`	`+returnqry;`
`1378`	`1373`
`1379`	`1374`	`default:`
`1380`	`1375`	`returnNULL;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit12b721a

File tree

1 file changed

1 file changed

`‎src/backend/tcop/utility.c`

0 commit comments