blob: 71122f4177443608eb1f77be72a09b7f47339dc9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
|
#! /bin/sh
# $PostgreSQL: pgsql/src/interfaces/ecpg/test/pg_regress.sh,v 1.4 2006/08/04 08:52:17 meskes Exp $
me=`basename $0`
. pg_regress.inc.sh
additional_regress_options=""
build_help "$additional_regress_options"
init_vars
parse_special_options(){
# no special options so far
case $1 in
-*)
echo "$me: invalid argument $1" 1>&2
exit 2;;
esac
}
# this will call parse_special_options from above
parse_general_options $*
# ----------
# Set up the environment variables (some of them depend on the parameters)
# ----------
setup_environment_variables
trap 'exit_trap $?' 0
trap 'sig_trap $?' 1 2 13 15
if [ x"$temp_install" != x"" ]
then
do_temp_install
else # not temp-install
dont_temp_install
fi
# ----------
# Postmaster is started, now we can change some environment variables for the
# client
# ----------
setup_client_environment_variables
# set up the dbs we use for ecpg regression tests
#"$bindir/createdb" $encoding_opt $psql_options --template template0 regress1
#"$bindir/createdb" $encoding_opt $psql_options --template template0 connectdb
#database_cleanup
create_database $dbname
create_database connectdb
# ----------
# Let's go
# ----------
message "running regression test queries"
outputdir="results/"
if [ ! -d "$outputdir" ]; then
mkdir -p "$outputdir" || { (exit 2); exit; }
fi
#result_summary_file=$outputdir/regression.out
#diff_file=$outputdir/regression.diffs
#cat /dev/null >"$result_summary_file"
#cat /dev/null >"$diff_file"
# we also have different users for ecpg regression diffs (need them for testing
# connects)
echo "$bindir/createuser" $psql_options -R -S -D -q regressuser1
"$bindir/createuser" $psql_options -R -S -D -q regressuser1
if [ $? -ne 0 ]; then
echo Could not create user regressuser1
fi
echo "$bindir/createuser" $psql_options -R -S -D -q connectuser
"$bindir/createuser" $psql_options -R -S -D -q connectuser
if [ $? -ne 0 ]; then
echo Could not create user connectuser
fi
# this variable prevents that the PID gets included in the logfiles
export ECPG_DONT_LOG_PID=1
export PGPORT=$temp_port
export LD_LIBRARY_PATH=$libdir
DIFFFLAGS="$DIFFFLAGS -C3"
FAILNUM=0
for i in \
connect/*.pgc \
compat_informix/*.pgc \
complex/*.pgc \
errors/*.pgc \
pgtypeslib/*.pgc \
sql/*.pgc \
thread/*.pgc; do
formatted=`echo $i | awk '{printf "%-38.38s", $1;}'`
$ECHO_N "testing $formatted ... $ECHO_C"
# connect/test1.pgc uses tcp to connect to the server. We run this test
# only if called with --listen-on-tcp
if [ $listen_on_tcp = no ] && [ "$i" = "connect/test1.pgc" ]; then
echo skipped
continue;
fi
runprg=${i%.pgc}
outprg=`echo $runprg | sed -e's/\//-/'`
outfile_stderr="$outputdir/$outprg.stderr"
outfile_stdout="$outputdir/$outprg.stdout"
outfile_source="$outputdir/$outprg.c"
cp $runprg.c "$outfile_source"
# echo "$runprg > $outfile_stdout 2> $outfile_stderr"
$runprg > "$outfile_stdout" 2> "$outfile_stderr"
# If we don't run on the default port we'll get different output
# so tweak output files and replace the port number (we put a warning
# but the price to pay is that we have to tweak the files every time
# now not only if the port differs from the standard port).
if [ "$i" = "connect/test1.pgc" ]; then
# can we use sed -i on all platforms?
for f in "$outfile_stderr" "$outfile_stdout" "$outfile_source"; do
mv $f $f.tmp
echo >> $f
echo "THE PORT NUMBER MIGHT HAVE BEEN CHANGED BY THE REGRESSION SCRIPT" >> $f
echo >> $f
cat $f.tmp | sed -e s,$PGPORT,55432,g >> $f
rm $f.tmp
done
fi
DIFFER=""
diff $DIFFFLAGS expected/$outprg.stderr "$outfile_stderr" >> regression.diff 2>&1 || DIFFER="$DIFFER, log"
diff $DIFFFLAGS expected/$outprg.stdout "$outfile_stdout" >> regression.diff 2>&1 || DIFFER="$DIFFER, output"
diff $DIFFFLAGS expected/$outprg.c "$outputdir"/$outprg.c >> regression.diff 2>&1 || DIFFER="$DIFFER, source"
DIFFER=${DIFFER#, }
if [ "x$DIFFER" = "x" ]; then
echo ok
else
echo "FAILED ($DIFFER)"
FAILNUM=$((FAILNUM+1))
fi
done
if [ $FAILNUM -eq 0 ]; then
rm regression.diff
fi
postmaster_shutdown
[ $FAILNUM -eq 0 ] && exit
[ $FAILNUM -ne 0 ] && (exit 1); exit
|
