If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to [EMAIL PROTECTED]
To report any other bug, fill out the form below and e-mail it to
[EMAIL PROTECTED]
If you not only found the problem but solved it and generated a patch
then e-mail it to [EMAIL PROTECTED] instead. Please use the
command "diff -c" to generate the patch.
You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Rainer Tammer
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) : RS/6000
Operating System (example: Linux 2.0.26 ELF) : AIX 4.3.3.0-03
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0
Compiler used (example: gcc 2.8.0) : ibmcxx 3.6.6.0 (xlC)
Please enter a FULL description of your problem:
------------------------------------------------
The regression test fails on a couple of topics.
1. compile settings
./configure --with-includes=/usr/local/include/readline
--with-libraries=/usr/local/lib
--prefix=/usr/local/pgsql
--with-perl --with-CC=xlc --without-CXX --enable-locale
-> HINT --enable-locale !!
2. outputs
=============== Notes... =================
postmaster must already be running for the regression tests to succeed.
The time zone is set to PST8PDT for these tests by the client frontend.
Please report any apparent problems to [EMAIL PROTECTED]
See regress/README for more information.
=============== dropping old regression database... =================
ERROR: DROP DATABASE: Database "regression" does not exist
dropdb: database removal failed
=============== creating new regression database... =================
CREATE DATABASE
=============== installing languages... =================
installing PL/pgSQL .. ok
=============== running regression queries... =================
boolean .. ok
char .. failed
name .. ok
varchar .. failed
text .. ok
int2 .. ok
int4 .. ok
int8 .. ok
oid .. ok
float4 .. ok
float8 .. ok
numeric .. ok
strings .. ok
numerology .. ok
point .. ok
lseg .. ok
box .. ok
path .. ok
polygon .. ok
circle .. ok
interval .. ok
timestamp .. ok
reltime .. ok
tinterval .. ok
inet .. ok
comments .. ok
oidjoins .. ok
type_sanity .. ok
opr_sanity .. ok
abstime .. ok
geometry .. ok
horology .. ok
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok
copy .. ok
constraints .. ok
triggers .. ok
create_misc .. ok
create_aggregate .. ok
create_operator .. ok
create_index .. ok
create_view .. ok
sanity_check .. ok
errors .. ok
select .. ok
select_into .. ok
select_distinct .. ok
select_distinct_on .. ok
select_implicit .. failed
select_having .. failed
subselect .. ok
union .. ok
case .. ok
join .. ok
aggregates .. ok
transactions .. ok
random .. ok
portals .. ok
arrays .. ok
btree_index .. ok
hash_index .. ok
misc .. ok
select_views .. failed
alter_table .. ok
portals_p2 .. ok
rules .. ok
foreign_key .. ok
limit .. ok
plpgsql .. ok
temp .. ok
*** expected/char.out Tue Jan 4 17:19:34 2000
--- results/char.out Fri May 12 09:12:06 2000
***************
*** 62,73 ****
WHERE c.f1 < 'a';
five | f1
------+----
- | A
| 1
| 2
| 3
|
! (5 rows)
SELECT '' AS six, c.*
FROM CHAR_TBL c
--- 62,72 ----
WHERE c.f1 < 'a';
five | f1
------+----
| 1
| 2
| 3
|
! (4 rows)
SELECT '' AS six, c.*
FROM CHAR_TBL c
***************
*** 75,86 ****
six | f1
-----+----
| a
- | A
| 1
| 2
| 3
|
! (6 rows)
SELECT '' AS one, c.*
FROM CHAR_TBL c
--- 74,84 ----
six | f1
-----+----
| a
| 1
| 2
| 3
|
! (5 rows)
SELECT '' AS one, c.*
FROM CHAR_TBL c
***************
*** 87,94 ****
WHERE c.f1 > 'a';
one | f1
-----+----
| c
! (1 row)
SELECT '' AS two, c.*
FROM CHAR_TBL c
--- 85,93 ----
WHERE c.f1 > 'a';
one | f1
-----+----
+ | A
| c
! (2 rows)
SELECT '' AS two, c.*
FROM CHAR_TBL c
***************
*** 96,103 ****
two | f1
-----+----
| a
| c
! (2 rows)
DROP TABLE CHAR_TBL;
--
--- 95,103 ----
two | f1
-----+----
| a
+ | A
| c
! (3 rows)
DROP TABLE CHAR_TBL;
--
----------------------
*** expected/varchar.out Tue Jan 4 17:19:34 2000
--- results/varchar.out Fri May 12 09:12:15 2000
***************
*** 50,61 ****
WHERE c.f1 < 'a';
five | f1
------+----
- | A
| 1
| 2
| 3
|
! (5 rows)
SELECT '' AS six, c.*
FROM VARCHAR_TBL c
--- 50,60 ----
WHERE c.f1 < 'a';
five | f1
------+----
| 1
| 2
| 3
|
! (4 rows)
SELECT '' AS six, c.*
FROM VARCHAR_TBL c
***************
*** 63,74 ****
six | f1
-----+----
| a
- | A
| 1
| 2
| 3
|
! (6 rows)
SELECT '' AS one, c.*
FROM VARCHAR_TBL c
--- 62,72 ----
six | f1
-----+----
| a
| 1
| 2
| 3
|
! (5 rows)
SELECT '' AS one, c.*
FROM VARCHAR_TBL c
***************
*** 75,82 ****
WHERE c.f1 > 'a';
one | f1
-----+----
| c
! (1 row)
SELECT '' AS two, c.*
FROM VARCHAR_TBL c
--- 73,81 ----
WHERE c.f1 > 'a';
one | f1
-----+----
+ | A
| c
! (2 rows)
SELECT '' AS two, c.*
FROM VARCHAR_TBL c
***************
*** 84,91 ****
two | f1
-----+----
| a
| c
! (2 rows)
DROP TABLE VARCHAR_TBL;
--
--- 83,91 ----
two | f1
-----+----
| a
+ | A
| c
! (3 rows)
DROP TABLE VARCHAR_TBL;
--
----------------------
*** expected/select_implicit.out Thu Jan 6 07:40:54 2000
--- results/select_implicit.out Fri May 12 09:29:31 2000
***************
*** 22,32 ****
c | count
----------+-------
AAAA | 2
BBBB | 2
CCCC | 2
XXXX | 1
- bbbb | 1
- cccc | 2
(6 rows)
-- w/o existing GROUP BY target using a relation name in GROUP BY clause
--- 22,32 ----
c | count
----------+-------
AAAA | 2
+ bbbb | 1
BBBB | 2
+ cccc | 2
CCCC | 2
XXXX | 1
(6 rows)
-- w/o existing GROUP BY target using a relation name in GROUP BY clause
***************
*** 34,44 ****
count
-------
2
2
2
- 1
- 1
2
(6 rows)
-- w/o existing GROUP BY target and w/o existing a different ORDER BY target
--- 34,44 ----
count
-------
2
+ 1
2
2
2
+ 1
(6 rows)
-- w/o existing GROUP BY target and w/o existing a different ORDER BY target
***************
*** 104,114 ****
c | count
----------+-------
AAAA | 2
BBBB | 2
CCCC | 2
XXXX | 1
- bbbb | 1
- cccc | 2
(6 rows)
-- group using reference number out of range
--- 104,114 ----
c | count
----------+-------
AAAA | 2
+ bbbb | 1
BBBB | 2
+ cccc | 2
CCCC | 2
XXXX | 1
(6 rows)
-- group using reference number out of range
----------------------
*** expected/select_having.out Thu Jan 6 07:40:54 2000
--- results/select_having.out Fri May 12 09:29:34 2000
***************
*** 34,41 ****
GROUP BY c HAVING count(*) > 2 OR min(a) = max(a);
c | max
----------+-----
- XXXX | 0
bbbb | 5
(2 rows)
DROP TABLE test_having;
--- 34,41 ----
GROUP BY c HAVING count(*) > 2 OR min(a) = max(a);
c | max
----------+-----
bbbb | 5
+ XXXX | 0
(2 rows)
DROP TABLE test_having;
----------------------
*** expected/select_views.out Sun Jan 9 04:48:37 2000
--- results/select_views.out Fri May 12 09:31:25 2000
***************
*** 415,420 ****
--- 415,434 ----
I- 580 | 21
I- 580 | 22
I- 580 | 22
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 5
+ I- 580/I-680 Ramp | 6
+ I- 580/I-680 Ramp | 6
+ I- 580/I-680 Ramp | 6
I- 580 Ramp | 2
I- 580 Ramp | 2
I- 580 Ramp | 2
***************
*** 665,684 ****
I- 580 Ramp | 8
I- 580 Ramp | 8
I- 580 Ramp | 8
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 5
- I- 580/I-680 Ramp | 6
- I- 580/I-680 Ramp | 6
- I- 580/I-680 Ramp | 6
I- 680 | 2
I- 680 | 2
I- 680 | 2
--- 679,684 ----
----------------------
Any ideas ??
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
