NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit869312e

committed

Per SQL spec (in particular, the grammar in SQL:2008 7.13) we should allow

parentheses around the <query expression body> that follows a WITH clause, egwith cte(foo) as ( values(0) ) ((select foo from cte));This seems to be just an oversight/thinko in gram.y. Noted whileexperimenting with bug #4902.

1 parent9298d2f commit869312eCopy full SHA for 869312e

File tree

1 file changed

-2

lines changed

src/backend/parser
- gram.y

1 file changed

-2

lines changed

`‎src/backend/parser/gram.y`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@`
`11`	`11`	`*`
`12`	`12`	`*`
`13`	`13`	`* IDENTIFICATION`
`14`		`- * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.665 2009/06/18 01:27:02 tgl Exp $`
	`14`	`+ * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.666 2009/07/06 02:58:40 tgl Exp $`
`15`	`15`	`*`
`16`	`16`	`* HISTORY`
`17`	`17`	`* AUTHORDATEMAJOR EVENT`
`@@ -6879,7 +6879,7 @@ select_no_parens:`
`6879`	`6879`	`NULL);`
`6880`	`6880`	`$$ =$1;`
`6881`	`6881`	`}`
`6882`		`-\| with_clausesimple_select`
	`6882`	`+\| with_clauseselect_clause`
`6883`	`6883`	`{`
`6884`	`6884`	`insertSelectOptions((SelectStmt *) $2, NULL, NIL,`
`6885`	`6885`	`NULL, NULL,`

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!

Commit869312e

File tree

1 file changed

1 file changed

`‎src/backend/parser/gram.y`

0 commit comments