Commit48e1a39

committed

I guess the intention was to test incomplete SELECT statements, not

missing semicolons.I also added a SELECT statement without a target list.Manfred Koizar

1 parent92a162c commit48e1a39Copy full SHA for 48e1a39

File tree

+16

-5

lines changed

+16

-5

lines changed

Lines changed: 12 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,12 @@`
`2`	`2`	`-- ERRORS`
`3`	`3`	`--`
`4`	`4`	`-- bad in postquel, but ok in postsql`
`5`		`-select 1`
	`5`	`+select 1;`
	`6`	`+ ?column?`
	`7`	`+----------`
	`8`	`+ 1`
	`9`	`+(1 row)`
	`10`	`+`
`6`	`11`	`--`
`7`	`12`	`-- UNSUPPORTED STUFF`
`8`	`13`
`@@ -16,10 +21,14 @@ select 1`
`16`	`21`	`-- RETRIEVE`
`17`	`22`
`18`	`23`	`-- missing relation name`
`19`		`-select`
	`24`	`+select;`
	`25`	`+ERROR: parser: parse error at or near ";" at character 7`
`20`	`26`	`-- no such relation`
`21`	`27`	`select * from nonesuch;`
`22`		`-ERROR: parser: parse error at or near "select" at character 10`
	`28`	`+ERROR: Relation "nonesuch" does not exist`
	`29`	`+-- missing target list`
	`30`	`+select from pg_database;`
	`31`	`+ERROR: parser: parse error at or near "from" at character 8`
`23`	`32`	`-- bad name in target list`
`24`	`33`	`select nonesuch from pg_database;`
`25`	`34`	`ERROR: Attribute "nonesuch" not found`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`--`
`4`	`4`
`5`	`5`	`-- bad in postquel, but ok in postsql`
`6`		`-select1`
	`6`	`+select1;`
`7`	`7`
`8`	`8`
`9`	`9`	`--`
`@@ -20,11 +20,13 @@ select 1`
`20`	`20`	`-- RETRIEVE`
`21`	`21`
`22`	`22`	`-- missing relation name`
`23`		`-select`
	`23`	`+select;`
`24`	`24`
`25`	`25`	`-- no such relation`
`26`	`26`	`select*from nonesuch;`
`27`	`27`
	`28`	`+-- missing target list`
	`29`	`+selectfrom pg_database;`
`28`	`30`	`-- bad name in target list`
`29`	`31`	`select nonesuchfrom pg_database;`
`30`	`32`	`-- bad attribute name on lhs of operator`

Comments

(0)