Movatterモバイル変換

Skip to content

postgrespro/postgresPublic

forked frompostgres/postgres

NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit54bce38

bmomjian

committed

Remove FROM warning by fixing query.

1 parent0a54de8 commit54bce38Copy full SHA for 54bce38

File tree

2 files changed

+4

-7

lines changed

src/test/regress
- expected
  - select_into.out
- sql
  - select_into.sql

2 files changed

+4

-7

lines changed

`‎src/test/regress/expected/select_into.out`

Lines changed: 2 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,14 +3,11 @@`
`3`	`3`	`--`
`4`	`4`	`SELECT *`
`5`	`5`	`INTO TABLE tmp1`
`6`		`- FROMtmp`
	`6`	`+ FROMonek`
`7`	`7`	`WHERE onek.unique1 < 2;`
`8`		`-NOTICE: Adding missing FROM-clause entry for table onek`
`9`	`8`	`DROP TABLE tmp1;`
`10`	`9`	`SELECT *`
`11`	`10`	`INTO TABLE tmp1`
`12`		`- FROMtmp`
	`11`	`+ FROMonek2`
`13`	`12`	`WHERE onek2.unique1 < 2;`
`14`	`13`	`DROP TABLE tmp1;`
`15`		`-NOTICE: Adding missing FROM-clause entry for table onek`
`16`		`-`

`‎src/test/regress/sql/select_into.sql`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,14 +4,14 @@`
`4`	`4`
`5`	`5`	`SELECT*`
`6`	`6`	`INTO TABLE tmp1`
`7`		`-FROMtmp`
	`7`	`+FROMonek`
`8`	`8`	`WHEREonek.unique1<2;`
`9`	`9`
`10`	`10`	`DROPTABLE tmp1;`
`11`	`11`
`12`	`12`	`SELECT*`
`13`	`13`	`INTO TABLE tmp1`
`14`		`-FROMtmp`
	`14`	`+FROMonek2`
`15`	`15`	`WHEREonek2.unique1<2;`
`16`	`16`
`17`	`17`	`DROPTABLE tmp1;`

0 commit comments

Comments

(0)

[8]ページ先頭

©2009-2025 Movatter.jp