From ba61eebcd657b312cc12f0623a91966617f9ea8a Mon Sep 17 00:00:00 2001 From: Pavan Deolasee Date: Thu, 25 Jun 2015 08:20:21 +0530 Subject: [PATCH] Fix expected output for the test case 'xc_sequence' We no longer display NOTICEs about implicit sequence creation --- src/test/regress/expected/xc_sequence.out | 2 -- 1 file changed, 2 deletions(-) diff --git a/src/test/regress/expected/xc_sequence.out b/src/test/regress/expected/xc_sequence.out index 222519102d..5ba8bf9c14 100644 --- a/src/test/regress/expected/xc_sequence.out +++ b/src/test/regress/expected/xc_sequence.out @@ -99,7 +99,6 @@ DROP SEQUENCE xc_sequence_2; -- Columns with SERIAL -- Serial sequence is named xc_sequence_tab1_col2_seq CREATE TABLE xc_sequence_tab1 (col1 int, col2 serial) DISTRIBUTE BY ROUNDROBIN; -NOTICE: CREATE TABLE will create implicit sequence "xc_sequence_tab1_col2_seq" for serial column "xc_sequence_tab1.col2" -- Some data INSERT INTO xc_sequence_tab1 VALUES (1, DEFAULT); INSERT INTO xc_sequence_tab1 VALUES (2, DEFAULT); @@ -145,7 +144,6 @@ COMMIT; DROP TABLE xc_sequence_tab1; -- Need to recreate here, serial column is no more CREATE TABLE xc_sequence_tab1 (col1 int, col2 serial) DISTRIBUTE BY ROUNDROBIN; -NOTICE: CREATE TABLE will create implicit sequence "xc_sequence_tab1_col2_seq" for serial column "xc_sequence_tab1.col2" INSERT INTO xc_sequence_tab1 VALUES (1234, DEFAULT); SELECT col1, col2 FROM xc_sequence_tab1 ORDER BY 1; col1 | col2 -- 2.39.5