From bf023bd1624b19725c546642e19dbd9091a489fe Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Sun, 20 Feb 2000 02:16:02 +0000
Subject: [PATCH] Add a simple regress test for SERIAL --- it's not much, but
 it's better than no test at all...

---
 src/test/regress/expected/create_misc.out  | 19 +++++++++++++++++++
 src/test/regress/expected/sanity_check.out |  3 ++-
 src/test/regress/output/misc.source        |  4 +++-
 src/test/regress/sql/create_misc.sql       | 13 +++++++++++++
 4 files changed, 37 insertions(+), 2 deletions(-)

diff --git a/src/test/regress/expected/create_misc.out b/src/test/regress/expected/create_misc.out
index c3f17296a3..add55bc767 100644
--- a/src/test/regress/expected/create_misc.out
+++ b/src/test/regress/expected/create_misc.out
@@ -149,3 +149,22 @@ INSERT INTO iportaltest (i, d, p)
    VALUES (1, 3.567, '(3.0,1.0),(4.0,2.0)'::polygon);
 INSERT INTO iportaltest (i, d, p)
    VALUES (2, 89.05, '(4.0,2.0),(3.0,1.0)'::polygon);
+---
+--- test creation of SERIAL column
+---
+CREATE TABLE serialTest (f1 text, f2 serial);
+NOTICE:  CREATE TABLE will create implicit sequence 'serialtest_f2_seq' for SERIAL column 'serialtest.f2'
+NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'serialtest_f2_key' for table 'serialtest'
+INSERT INTO serialTest VALUES ('foo');
+INSERT INTO serialTest VALUES ('bar');
+INSERT INTO serialTest VALUES ('force', 100);
+INSERT INTO serialTest VALUES ('wrong', NULL);
+ERROR:  ExecAppend: Fail to add null value in not null attribute f2
+SELECT * FROM serialTest;
+  f1   | f2  
+-------+-----
+ foo   |   1
+ bar   |   2
+ force | 100
+(3 rows)
+
diff --git a/src/test/regress/expected/sanity_check.out b/src/test/regress/expected/sanity_check.out
index 6a196cb95c..0926299445 100644
--- a/src/test/regress/expected/sanity_check.out
+++ b/src/test/regress/expected/sanity_check.out
@@ -49,8 +49,9 @@ SELECT relname, relhasindex
  pg_trigger          | t
  pg_type             | t
  road                | t
+ serialtest          | t
  shighway            | t
  tenk1               | t
  tenk2               | t
-(43 rows)
+(44 rows)
 
diff --git a/src/test/regress/output/misc.source b/src/test/regress/output/misc.source
index a309838775..034e42c524 100644
--- a/src/test/regress/output/misc.source
+++ b/src/test/regress/output/misc.source
@@ -607,6 +607,8 @@ SELECT user_relns() AS user_relns
  real_city
  reltime_tbl
  road
+ serialtest
+ serialtest_f2_seq
  shighway
  slow_emp4000
  street
@@ -621,7 +623,7 @@ SELECT user_relns() AS user_relns
  toyemp
  varchar_tbl
  xacttest
-(84 rows)
+(86 rows)
 
 --SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name;
 --
diff --git a/src/test/regress/sql/create_misc.sql b/src/test/regress/sql/create_misc.sql
index 307767c5be..cd73f64060 100644
--- a/src/test/regress/sql/create_misc.sql
+++ b/src/test/regress/sql/create_misc.sql
@@ -228,3 +228,16 @@ INSERT INTO iportaltest (i, d, p)
 INSERT INTO iportaltest (i, d, p)
    VALUES (2, 89.05, '(4.0,2.0),(3.0,1.0)'::polygon);
 
+
+---
+--- test creation of SERIAL column
+---
+
+CREATE TABLE serialTest (f1 text, f2 serial);
+
+INSERT INTO serialTest VALUES ('foo');
+INSERT INTO serialTest VALUES ('bar');
+INSERT INTO serialTest VALUES ('force', 100);
+INSERT INTO serialTest VALUES ('wrong', NULL);
+
+SELECT * FROM serialTest;
-- 
2.40.0