Received: from mail1.panix.com (mail1.panix.com [166.84.0.212]) by hub.org (8.10.1/8.10.1) with ESMTP id e8B3C8f24980; Sun, 10 Sep 2000 23:12:08 -0400 (EDT) Received: from panix.com (mail2.panix.com [166.84.0.213]) by mail1.panix.com (Postfix) with ESMTP id 4979E487B1; Sun, 10 Sep 2000 23:12:08 -0400 (EDT) Received: from panix.com (pyz.dialup.access.net [166.84.202.155]) by panix.com (Postfix) with ESMTP id 9C4C643B22; Sun, 10 Sep 2000 23:12:05 -0400 (EDT) Message-ID: <39BC4E83.E357F887@panix.com> Date: Sun, 10 Sep 2000 23:16:19 -0400 From: Max Pyziur Organization: BRAMA - Gateway Ukraine X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org, pgsql-bugs@hub.org Subject: Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? References: <39BBD09C.C8F6B3F8@panix.com> <5410.968632518@sss.pgh.pa.us> <39BC3003.FC5A3449@panix.com> <9111.968637041@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/18 Tom Lane wrote: > > Max Pyziur writes: > >> That's pretty bizarre (not to say difficult to believe). What LOCALE > >> setting are you running the postmaster in? > > > On none of the installations - the two 6.5.x and the 7.0.2-2 one - I > > don't have any locale set. I get (what I think are) correct results > > with the first two. > > > Does 7.0.2-2 require the setting of locale. > > AFAIK its behavior should be the same as 6.5 for LOCALE issues. That's > why I suspect an environment difference. Thanks for your quick replies. I dropped my databases, uninstalled the 7.0.2-2 rpms and installed 6.5.3 rpms on my development RH6.2 Linux 2.2.14-5.0 system and I still get the anomalous query result on that box. > I can assure you there is no code in the backend that will do > case-insensitive, punctuation-insensitive comparisons --- much less any > to do so without request. I'm betting that either this is your error, > or the strcmp() library function is doing it; and as far as I've heard, > only LOCALE environment variables might affect the behavior of strcmp(). There is a $LANG variable which is set to en_US; is this what might be causing the problem? I've tried unsetting it (unset LANG) and still get the problem. Is there something else which I should be looking at? > It also seems possible that no sort is happening at all (which would be > a planner bug), and the ordering you're getting is just whatever happens > to be in the underlying table. Does EXPLAIN show that the query is > being done with an explicit sort? Running EXPLAIN the results are: headlines1=> explain select headline from headlines where headline like 'Alb%' order by 1 ; NOTICE: QUERY PLAN: Sort (cost=221.15 rows=1 width=12) -> Seq Scan on headlines (cost=221.15 rows=1 width=12) EXPLAIN > regards, tom lane Thanks again, Max Pyziur BRAMA - Gateway Ukraine pyz@brama.com http://www.brama.com/