postgrespro/postgres_clusterPublic

NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitcc08d05

Jan Wieck

authored and

Jan Wieck

committed

Added 2 regression tests for NUMERIC data type.

1. Using 100 digits after decimal point on the default make runtest.2. Using 1000 digits after decimal point in a new target make bigtest.At the end of 'make runtest', a hint about the new bigtest isprinted.Jan

1 parent78f7ccc commitcc08d05Copy full SHA for cc08d05

File tree

7 files changed

+2575

-5

lines changed

src/test/regress
- GNUmakefile
- expected
  - numeric.out
  - numeric_big.out
- regress.sh
- sql

7 files changed

+2575

-5

lines changed

`‎src/test/regress/GNUmakefile‎`

Lines changed: 22 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`#`
`8`	`8`	`#`
`9`	`9`	`# IDENTIFICATION`
`10`		`-# $Header: /cvsroot/pgsql/src/test/regress/GNUmakefile,v 1.17 1999/01/17 06:19:57 momjian Exp $`
	`10`	`+# $Header: /cvsroot/pgsql/src/test/regress/GNUmakefile,v 1.18 1999/06/10 17:49:29 wieck Exp $`
`11`	`11`	`#`
`12`	`12`	`#-------------------------------------------------------------------------`
`13`	`13`
`@@ -37,6 +37,11 @@ ifdef EXPSUFF`
`37`	`37`	`INFILES+=$(DLOBJS:.o=$(EXPSUFF))`
`38`	`38`	`endif`
`39`	`39`
	`40`	`+#`
	`41`	`+# huge extra tests run in target bigtest`
	`42`	`+#`
	`43`	`+EXTRA_TESTS= numeric_big`
	`44`	`+`
`40`	`45`	`#`
`41`	`46`	`# prepare to run the test (including clean-up after the last run)`
`42`	`47`	`#`
`@@ -66,6 +71,22 @@ ifneq ($(PORTNAME), win)`
`66`	`71`	`else`
`67`	`72`	`MULTIBYTE=$(MULTIBYTE);export MULTIBYTE; \`
`68`	`73`	`./regress.sh $(PORTNAME) 2>&1 \| tee regress.out`
	`74`	`+endif`
	`75`	`+@echo "ACTUAL RESULTS OF REGRESSION TEST ARE NOW IN FILE regress.out"`
	`76`	`+@echo ""`
	`77`	`+@echo "To run the optional huge test(s) too type 'make bigtest'"`
	`78`	`+@echo "These actually are: $(EXTRA_TESTS)"`
	`79`	`+`
	`80`	`+#`
	`81`	`+# run the test including the huge extra tests`
	`82`	`+#`
	`83`	`+bigtest:$(INFILES)`
	`84`	`+ifneq ($(PORTNAME), win)`
	`85`	`+MULTIBYTE=$(MULTIBYTE);export MULTIBYTE; \`
	`86`	`+$(SHELL) ./regress.sh $(PORTNAME) $(EXTRA_TESTS) 2>&1 \| tee regress.out`
	`87`	`+else`
	`88`	`+MULTIBYTE=$(MULTIBYTE);export MULTIBYTE; \`
	`89`	`+./regress.sh $(PORTNAME) $(EXTRA_TESTS) 2>&1 \| tee regress.out`
`69`	`90`	`endif`
`70`	`91`	`@echo "ACTUAL RESULTS OF REGRESSION TEST ARE NOW IN FILE regress.out"`
`71`	`92`

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

Lines changed: 635 additions & 0 deletions

Large diffs are not rendered by default.

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

Lines changed: 625 additions & 0 deletions

Large diffs are not rendered by default.

`‎src/test/regress/regress.sh‎`

Lines changed: 7 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,9 +1,9 @@`
`1`	`1`	`#!/bin/sh`
`2`		`-# $Header: /cvsroot/pgsql/src/test/regress/Attic/regress.sh,v 1.28 1999/05/20 16:50:08 wieck Exp $`
	`2`	`+# $Header: /cvsroot/pgsql/src/test/regress/Attic/regress.sh,v 1.29 1999/06/10 17:49:30 wieck Exp $`
`3`	`3`	`#`
`4`	`4`	`if [$#-eq 0 ]`
`5`	`5`	`then`
`6`		`-echo"Syntax:$0 <portname>"`
	`6`	`+echo"Syntax:$0 <portname> [extra-tests]"`
`7`	`7`	`exit 1`
`8`	`8`	`fi`
`9`	`9`
`@@ -13,6 +13,9 @@ then`
`13`	`13`	`else`
`14`	`14`	`HOST=""`
`15`	`15`	`fi`
	`16`	`+portname=$1`
	`17`	`+export portname`
	`18`	`+shift`
`16`	`19`
`17`	`20`	`ifecho'\c'\| grep -s c>/dev/null2>&1`
`18`	`21`	`then`
`@@ -33,7 +36,7 @@ PGDATESTYLE="Postgres,US"; export PGDATESTYLE`
`33`	`36`	`#FRONTEND=monitor`
`34`	`37`	`FRONTEND="psql$HOST -n -e -q"`
`35`	`38`
`36`		-SYSTEM=`../../config.guess\| awk -F\-'{ split($3,a,/[0-9]/); printf"%s-%s", $1, a[1] }'`
	`39`	+SYSTEM=`../../config.guess\| awk -F\-'{ split($3,a,/[0-9]/); printf"%s-%s", $portname, a[1] }'`
`37`	`40`
`38`	`41`	`echo"=============== Notes... ================="`
`39`	`42`	`echo"postmaster must already be running for the regression tests to succeed."`
`@@ -72,7 +75,7 @@ fi`
`72`	`75`
`73`	`76`	`echo"=============== running regression queries... ================="`
`74`	`77`	`echo""> regression.diffs`
`75`		-foriin`cat sql/tests`$mbtests
	`78`	+foriin`cat sql/tests`$mbtests$*
`76`	`79`	`do`
`77`	`80`	`$ECHO_N"${i} .."$ECHO_C`
`78`	`81`	`$FRONTEND regression< sql/${i}.sql> results/${i}.out2>&1`

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

Lines changed: 649 additions & 0 deletions

Large diffs are not rendered by default.

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

Lines changed: 636 additions & 0 deletions

Large diffs are not rendered by default.

`‎src/test/regress/sql/tests‎`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -68,3 +68,4 @@ rules`
`68`	`68`	`limit`
`69`	`69`	`plpgsql`
`70`	`70`	`temp`
	`71`	`+numeric`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitcc08d05

File tree

7 files changed

7 files changed

`‎src/test/regress/GNUmakefile‎`

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

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

`‎src/test/regress/regress.sh‎`

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

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

`‎src/test/regress/sql/tests‎`

0 commit comments