X-Original-To: pgsql-docs@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C89C24762F8 for ; Wed, 12 Feb 2003 16:08:47 -0500 (EST) Received: from express.corp.cubic.com (express.corp.cubic.com [149.63.71.200]) by postgresql.org (Postfix) with ESMTP id EE8D04764BA for ; Wed, 12 Feb 2003 15:55:03 -0500 (EST) Received: from shemp.ds.cubic.com (shemp.ds.cubic.com [149.63.70.56]) by express.corp.cubic.com (8.9.3+Sun/8.9.1) with ESMTP id MAA00287 for ; Wed, 12 Feb 2003 12:54:54 -0800 (PST) Received: by shemp.ds.cubic.com with Internet Mail Service (5.5.2653.19) id <1LYB3XFQ>; Wed, 12 Feb 2003 12:54:53 -0800 Message-ID: <547FB5C65F37D6119C150003471B550784F5D4@shemp.ds.cubic.com> From: "Wilson, Scott" To: "'pgsql-docs@postgresql.org'" Subject: Row ordering difference in regression test output Date: Wed, 12 Feb 2003 12:54:44 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2D2D8.F87DD440" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/16 X-Sequence-Number: 1650 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2D2D8.F87DD440 Content-Type: text/plain Hello, In the documentation on the following page: http://www.postgresql.org/docs/view.php?version=7.3 &idoc=1&file=regress-evaluation.html in section 13.3.6, you state that benign row ordering differences should be reported. I got the following output, which I believe is a bogus failure: *** ./expected/select_having_1.out Wed Nov 20 19:45:18 2002 --- ./results/select_having.out Wed Feb 12 15:10:08 2003 *************** *** 26,33 **** GROUP BY b, c HAVING b = 3; b | c ---+---------- - 3 | BBBB 3 | bbbb (2 rows) SELECT lower(c), count(c) FROM test_having --- 26,33 ---- GROUP BY b, c HAVING b = 3; b | c ---+---------- 3 | bbbb + 3 | BBBB (2 rows) SELECT lower(c), count(c) FROM test_having I am running Linux 7.2 and Postgresql 7.3. Please don't hesitate to contact me at the following address with questions/problems: Scott.wilson@cubic.com ------_=_NextPart_001_01C2D2D8.F87DD440 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

Hello,

 

In the documentation on the following page:

 

http://www.postgresql.org/docs/view.php= ?version=3D7.3&idoc=3D1&file=3Dregress-evaluation.html

 

in section 13= .3.6, you state that benign row ordering differences should be reported.  I got the following output, <= /o:p>

which I= believe is a bogus failure:

 

*=
** ./expected/select_having_1.out    Wed Nov 20 19:45:18 2002
--- ./result=
s/select_having.out&nbs=
p;      Wed Feb 12 15:10:08 2003
************=
***
*** 26,33 ****
        GROUP BY b,=
 c HAVING b =3D 3; 
   b |   =
 c     <=
o:p>
  ---+----------
-  3 | BBBB    
   3 | bbbb  &nbs=
p; 
  (2 rows)<=
/pre>
  
  SELECT lower(c), count(c) FROM test_having
--- 26,33 ----
        GROUP BY b,=
 c HAVING b =3D 3; 
   b |   =
 c     <=
o:p>
  ---+----------
   3 | bbbb  &nbs=
p; 
+  3 | BBBB    <=
/o:p>
  (2 rows)<=
/pre>
  
  SELECT lower(c), count(c) FROM test_having



 



 



I am running Linux 7.2 and Postgresql 7.3.  Please don't hesitate to contact me
at the following address



with q=
uestions/problems:



 



Scott.wilson@c=
ubic.com



 



 
------_=_NextPart_001_01C2D2D8.F87DD440--