@@ -6,12 +6,12 @@ Introduction
6
6
Andrew Yu. It tests standard SQL operations as well as the extensibility
7
7
capabilities of PostgreSQL.
8
8
9
- These tests have recently been revised by Marc Fournier and others to
10
- become current for PostgreSQL v6.1. The tests are now packaged as
9
+ These tests have recently been revised by Marc Fournier and Thomas Lockhart
10
+ to become current for PostgreSQL v6.1. The tests are now packaged as
11
11
functional units and should be easier to run and easier to interpret.
12
12
13
13
Some properly installed and fully functional PostgreSQL installations
14
- can fail these regression tests due to artifacts of floating point
14
+ can fail some of these regression tests due to artifacts of floating point
15
15
representation and time zone support. The current tests are evaluated
16
16
using a simple "diff" algorithm, and are sensitive to small system
17
17
differences. For apparently failed tests, examining the differences
@@ -27,13 +27,21 @@ Preparation
27
27
files with absolute pathnames and user names.
28
28
29
29
The postmaster should be invoked with the system time zone set for
30
- Berkeley, California. On some systems, this can be accomplished by
30
+ Berkeley, California. On many systems, this can be accomplished by
31
31
setting the TZ environment variable before starting the postmaster
32
32
(for csh/bash; use set/export for some other shells):
33
33
34
- setenv TZ PST8PDT7,M04.01.0,M10.05.03
34
+ setenv TZ PST8PDT
35
+ date
35
36
/usr/local/pgsql/bin/postmaster -s
36
37
38
+ The "date" command above should have returned the current system time
39
+ in the PST8PDT time zone. If the PST8PDT database is not available, then
40
+ your system may have returned the time in GMT. If the PST8PDT time zone
41
+ is not available, you can set the time zone rules explicitly:
42
+
43
+ setenv TZ PST8PDT7,M04.01.0,M10.05.03
44
+
37
45
Directory Layout
38
46
39
47
input/ .... .source files that are converted using 'make all' into
@@ -73,6 +81,15 @@ Comparing expected/actual output
73
81
The files might not compare exactly. The following paragraphs attempt
74
82
to explain the differences.
75
83
84
+ Error message differences
85
+
86
+ Some of the regression tests involve intentional invalid input values.
87
+ Error messages can come from either the Postgres code or from the host
88
+ platform system routines. In the latter case, the messages may vary
89
+ between platforms, but should reflect similar information. These
90
+ differences in messages will result in a "failed" regression test which
91
+ can be validated by inspection.
92
+
76
93
OID differences
77
94
78
95
There are several places where PostgreSQL OID (object identifiers) appear
@@ -93,12 +110,14 @@ DATE/TIME differences
93
110
is running in the same time zone as Berkeley, California. See details in
94
111
the section on how to run the regression tests.
95
112
96
- If you do not explicitly set your time zone environment to PST/PDT , then
113
+ If you do not explicitly set your time zone environment to PST8PDT , then
97
114
most of the date and time results will reflect your local time zone and
98
115
will fail the regression testing.
99
116
100
- There appear to be some systems which do not accept the same syntax for
101
- setting the local time zone.
117
+ There appears to be some systems which do not accept the recommended syntax
118
+ for explicitly setting the local time zone rules. Some systems using the
119
+ public domain time zone package exhibit minor problems with pre-1970 PDT
120
+ times, representing them in PST instead.
102
121
103
122
FLOATING POINT differences
104
123
@@ -168,11 +187,9 @@ Current release notes (Thomas.Lockhart@jpl.nasa.gov)
168
187
169
188
Three new data types (datetime, timespan, and circle) have been added to
170
189
the native set of PostgreSQL types. Points, boxes, paths, and polygons
171
- have had their output formats improved, but the old-style input formats
172
- are accepted by v6.1. The source data files have not been updated to the
173
- new formats, but should be for the next release. The polygon output in
174
- misc.out has only been spot-checked for correctness relative to the
175
- original regression output.
190
+ have had their output formats made consistant across the data types.
191
+ The polygon output in misc.out has only been spot-checked for correctness
192
+ relative to the original regression output.
176
193
177
194
PostgreSQL v6.1 introduces a new, alternate optimizer which uses "genetic"
178
195
algorithms. These algorithms introduce a random behavior in the ordering
@@ -204,6 +221,6 @@ Sample timing results
204
221
to run, presumably due to the timing vagaries of multitasking systems.
205
222
206
223
Time System
207
- 06:12 Pentium Pro 180, 32MB, Linux 2.0.27 , gcc 2.7.2 -O2 -m486
224
+ 06:12 Pentium Pro 180, 32MB, Linux 2.0.30 , gcc 2.7.2 -O2 -m486
208
225
12:06 P-100, 48MB, Linux 2.0.29, gcc
209
226
39:58 Sparc IPC 32MB, Solaris 2.5, gcc 2.7.2.1 -O -g
0 commit comments