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-09-01 Thread Christopher Kings-Lynne
regression test failure 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

Re: [HACKERS] RULE regression test failure

2002-08-30 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

Re: [HACKERS] RULE regression test failure

2002-08-30 Thread Christopher Kings-Lynne
U...how do I make the regression database!? Do I have to do installcheck instead of check? 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

Re: [HACKERS] RULE regression test failure

2002-08-30 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

Re: [HACKERS] RULE regression test failure

2002-08-30 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-Lynne [EMAIL PROTECTED] writes: With the recent

Re: [HACKERS] RULE regression test failure

2002-08-30 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 a

Re: [HACKERS] RULE regression test failure

2002-08-30 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 dependency. Any

[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

[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