postgres.git / summary / log / commit / refs

commit    54bce381a7b4802b7516de7876e026e757779235
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sun Jun 04 17:52:54 2000 +0000

    Remove FROM warning by fixing query.


 src/test/regress/expected/select_into.out | 7 ++-----
 src/test/regress/sql/select_into.sql      | 4 ++--
 2 files changed, 4 insertions(+), 7 deletions(-)

diff --git a/src/test/regress/expected/select_into.out b/src/test/regress/expected/select_into.out
index 5c550ced7a9..503efe04fc2 100644
--- a/src/test/regress/expected/select_into.out
+++ b/src/test/regress/expected/select_into.out
@@ -3,14 +3,11 @@
 --
 SELECT *
    INTO TABLE tmp1
-   FROM tmp
+   FROM onek
    WHERE onek.unique1 < 2;
-NOTICE:  Adding missing FROM-clause entry for table onek
 DROP TABLE tmp1;
 SELECT *
    INTO TABLE tmp1
-   FROM tmp
+   FROM onek2
    WHERE onek2.unique1 < 2;
 DROP TABLE tmp1;
-NOTICE:  Adding missing FROM-clause entry for table onek
-
diff --git a/src/test/regress/sql/select_into.sql b/src/test/regress/sql/select_into.sql
index 91214512acf..993c44b727d 100644
--- a/src/test/regress/sql/select_into.sql
+++ b/src/test/regress/sql/select_into.sql
@@ -4,14 +4,14 @@
 
 SELECT *
    INTO TABLE tmp1
-   FROM tmp
+   FROM onek
    WHERE onek.unique1 < 2;
 
 DROP TABLE tmp1;
 
 SELECT *
    INTO TABLE tmp1
-   FROM tmp
+   FROM onek2
    WHERE onek2.unique1 < 2;
 
 DROP TABLE tmp1;


[parent: 0a54de8fafeb]