diff options
| -rw-r--r-- | src/test/regress/expected/with.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/with.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/with.out b/src/test/regress/expected/with.out index 3e2b34c6fcd..0646451fb0b 100644 --- a/src/test/regress/expected/with.out +++ b/src/test/regress/expected/with.out @@ -2280,7 +2280,7 @@ LINE 1: WITH test AS (SELECT 42) INSERT INTO test VALUES (1); -- check response to attempt to modify table with same name as a CTE (perhaps -- surprisingly it works, because CTEs don't hide tables from data-modifying -- statements) -create table test (i int); +create temp table test (i int); with test as (select 42) insert into test select * from test; select * from test; i diff --git a/src/test/regress/sql/with.sql b/src/test/regress/sql/with.sql index baf65488a8e..512ff1b3ba2 100644 --- a/src/test/regress/sql/with.sql +++ b/src/test/regress/sql/with.sql @@ -1035,7 +1035,7 @@ WITH test AS (SELECT 42) INSERT INTO test VALUES (1); -- check response to attempt to modify table with same name as a CTE (perhaps -- surprisingly it works, because CTEs don't hide tables from data-modifying -- statements) -create table test (i int); +create temp table test (i int); with test as (select 42) insert into test select * from test; select * from test; drop table test; |