Re: Windows query weird result

Lutz Fischer <lfischer@xxxxxxxxxxxxxxxxxx> · Tue, 30 Apr 2013 11:52:27 +0100



    The problem is that I need not 3 rows
      but 1360000 rows. So "id=" is not really an option. Tried putting
      each condition in  brackets - but that did not help either. 

      But you are right in that it looks like the NULL values are the
      problem. Leaving that condition out both windows and linux server
      return the same amount of values...

      
      On 29/04/13 22:01, Aaron Abreu wrote:

    
      I would add each of your where fields to the
        select,
        then use all 3 id numbers in the id=
        

        I also run from windows server 2008, and sometimes
        have trouble getting it to accept records with
          nulls.
        

        or, try putting EACH  where condition enclosed in
        its own (  )  set.
      
      
        On Mon, Apr 29, 2013 at 12:52 PM, Lutz
          Fischer <lfischer@xxxxxxxxxxxxxxxxxx>
          wrote:

          Hi,

            
            had a bit of weird result for a query:

            SELECT id FROM spectrum_match WHERE search_id in
            (788,694,693,685) AND

            rescored IS NOT NULL and dynamic_rank = true ORDER BY ID;

            
            returns (among some 127K other lines):

            ...

            32694548

            32694860

            ...

            
            But if I change the query to:

            SELECT id FROM spectrum_match WHERE search_id in
            (788,694,693,685) AND

            rescored IS NOT NULL and dynamic_rank = true and id=
            32694801;

            I get

            
            32694801

            
            which is omitted from the previous result.

            
            The database is running under windows (I know that's bad -
            but we had

            reasons...).

            It only became apparent after we made a copy of the database
            and run it

            under Linux (Debian wheezy).

            There the first query returned 136k lines and this id was
            the first

            difference.

            
            Does anybody has an idea what is going on?

            
            It's postgresql 9.2.1 running under a windows 2008 R2 server

            
            Lutz

            
                --

                Lutz Fischer

                lfischer@xxxxxxxxxxxxxxxxxx

                +44 131 6517057

                
                The University of Edinburgh is a charitable body,
                registered in

                Scotland, with registration number SC005336.

                
                --

                Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)

                To make changes to your subscription:

                http://www.postgresql.org/mailpref/pgsql-general

              
        -- 

        ####
        Aaron Abreu, Systems Consultant

          Bay District Schools, Panama City,  FL
        Office:  (850) 767-4288

          >>FOCUS Student system support
        >>IRIS phone alert system support

          ABREUAL@xxxxxxxxxxxxx
      
      The information contained in this message may be privileged and confidential and protected
from disclosure. If the reader of this message is not the intended recipient, or an 
employee or agent responsible for delivering this message to the intended recipient, 
you are hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this communication in error, 
please notify us immediately by replying to the message and deleting it from your 
computer. Under Florida law, e-mail addresses are public records. If you do not want 
your e-mail address released in response to a public-records request, do not send 
electronic mail to this entity. Instead, contact this office by phone or in writing.


    -- 
Lutz Fischer
lfischer@xxxxxxxxxxxxxxxxxx
+44 131 6517057
  

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general