Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA45671 for ; Mon, 8 Nov 1999 23:32:19 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: from cadzone ([126.0.1.40] (may be forged)) by sd.tpf.co.jp (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) with SMTP id NAA03180; Tue, 09 Nov 1999 13:32:06 +0900 From: "Hiroshi Inoue" To: "Stoyan Genov" Cc: Subject: RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Date: Tue, 9 Nov 1999 13:36:26 +0900 Message-ID: <000f01bf2a6b$fc1eafc0$2801007e@cadzone.tpf.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <38276A2C.F1ECB937@tpf.co.jp> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Importance: Normal > > > > > I knew the way to fix it but am not sure now. > > > Do you really want to make it possible ? > > > It isn't an appropriate way to get last rows because "move forward > > > all" takes very long time. > > > > > > > Of course it is not an appropriate way to get the last rows like this. > > The "right" way IMHO is to reverse the order in the query and to get the > > first > > rows. > > > > It is just for the sake of truth... > > > > OK Attached is a patch. > Could you apply to 6.5.3 ? > Sorry the patch is not right for 6.5.3 . Please apply the following patch to 6.5.3 . Regards. Hiroshi Inoue Inoue@tpf.co.jp *** access/heap/heapam.c.orig Mon Aug 2 14:56:36 1999 --- access/heap/heapam.c Tue Nov 9 12:59:48 1999 *************** *** 775,782 **** if (scan->rs_ptup.t_data == scan->rs_ctup.t_data && BufferIsInvalid(scan->rs_pbuf)) { - if (BufferIsValid(scan->rs_nbuf)) - ReleaseBuffer(scan->rs_nbuf); return NULL; } --- 775,780 ---- *************** *** 833,842 **** ReleaseBuffer(scan->rs_pbuf); scan->rs_ptup.t_data = NULL; scan->rs_pbuf = InvalidBuffer; - if (BufferIsValid(scan->rs_nbuf)) - ReleaseBuffer(scan->rs_nbuf); - scan->rs_ntup.t_data = NULL; - scan->rs_nbuf = InvalidBuffer; return NULL; } --- 831,836 ---- *************** *** 855,862 **** if (scan->rs_ctup.t_data == scan->rs_ntup.t_data && BufferIsInvalid(scan->rs_nbuf)) { - if (BufferIsValid(scan->rs_pbuf)) - ReleaseBuffer(scan->rs_pbuf); HEAPDEBUG_3; /* heap_getnext returns NULL at end */ return NULL; } --- 849,854 ---- *************** *** 915,924 **** ReleaseBuffer(scan->rs_nbuf); scan->rs_ntup.t_data = NULL; scan->rs_nbuf = InvalidBuffer; - if (BufferIsValid(scan->rs_pbuf)) - ReleaseBuffer(scan->rs_pbuf); - scan->rs_ptup.t_data = NULL; - scan->rs_pbuf = InvalidBuffer; HEAPDEBUG_6; /* heap_getnext returning EOS */ return NULL; } --- 907,912 ----