Re: [HACKERS] RULE regression test failure

2002-09-01 Thread Christopher Kings-Lynne
Subject: Re: [HACKERS] RULE regression test failure > > > > OK, patch attached that adds ORDER BY to the problem regression query. > > -- > - > > Christopher Kings-Lynne wrote: > > > That

Re: [HACKERS] RULE regression test failure

2002-09-01 Thread Bruce Momjian
OK, patch attached that adds ORDER BY to the problem regression query. --- Christopher Kings-Lynne wrote: > > That seems substantially the same plan as I see here. I guess > > that the different output order must reflect a

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Christopher Kings-Lynne
> That seems substantially the same plan as I see here. I guess > that the different output order must reflect a platform-specific > difference in qsort()'s treatment of equal keys. > > Probably the best answer is to add "ORDER BY shoename" to the test > query to eliminate the platform dependenc

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: >> Hm, what do you get from >> explain SELECT * FROM shoe_ready WHERE total_avail >= 2; >> in the regression database? > > [this plan] That seems substantially the same plan as I see here. I guess that the different output order must reflect

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Christopher Kings-Lynne
Attached. Chris > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Friday, 30 August 2002 2:31 PM > To: Christopher Kings-Lynne > Cc: Hackers > Subject: Re: [HACKERS] RULE regression test failure > > > "Christopher Kings-L

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > U...how do I make the regression database!? Do I have to do > installcheck instead of check? That's the easiest way; or you can restart the temp postmaster that the regression script starts and kills. regards, t

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Gavin Sherry
On Fri, 30 Aug 2002, Christopher Kings-Lynne wrote: > U...how do I make the regression database!? Do I have to do > installcheck instead of check? yes Database is 'regression' g ---(end of broadcast)--- TIP 1: subscribe and unsubscribe com

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Christopher Kings-Lynne
Re: [HACKERS] RULE regression test failure > > > "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > > With the recent talk of RULE regression failures, I thought I'd > bring back > > up that I _always_ have a rule failure on Freebsd/alpha. > > Hm

Re: [HACKERS] RULE regression test failure

2002-08-29 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > With the recent talk of RULE regression failures, I thought I'd bring back > up that I _always_ have a rule failure on Freebsd/alpha. Hm, what do you get from explain SELECT * FROM shoe_ready WHERE total_avail >= 2; in the regression

[HACKERS] RULE regression test failure

2002-08-29 Thread Christopher Kings-Lynne
With the recent talk of RULE regression failures, I thought I'd bring back up that I _always_ have a rule failure on Freebsd/alpha. The files are attached... Chris regression.diffs Description: Binary data regression.out Description: Binary data ---(end of broadcas

[HACKERS] Rule Regression Test Failure on FreeBSD/Alpha

2002-07-01 Thread Christopher Kings-Lynne
OK, On HEAD, I am still seeing the attached failures. They didn't happen before, but appeared in the last couple of months. All other tests pass. It seems to just be a tuple ordering issue - I really don't know what caused it? If necessary, I can just modify the expected result, but I haven't