Re: Problem with planer

From: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
To: Eugen(dot)Konkov(at)aldec(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problem with planer
Date: 2008-08-26 10:15:50
Message-ID: 48B3D7D6.3050709@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Eugen(dot)Konkov(at)aldec(dot)com wrote:
> select ats.id, ap.value from akh_test_suit ats
> LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
> where ats.ID = 472
> id | value
> 472 | 472
> ID -- integer
> value -- text
> select * from akh_test_suit ats
> LEFT JOIN akh_properties ap on ap.ID = ats.test_suit_type_id
> where ats.ID = 472 and ap.value::integer = ats.ID
> ERROR: invalid input syntax for integer: "--username sergeiz
> --password sergeiz --non-interactive svn://sergeiz"
> akh_properties.values has non numeric values, but those rows do not
> (MUST NOT) participate in results as showed in first query
> Why PG check them?

can you share the PostgreSQL version you are using with us?
maybe you can compile a test case?
or maybe you are facing some sort of corruption? what happens after dump
/ reload?

many thanks,

hans

--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql-support.de, www.postgresql-support.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eugen.Konkov 2008-08-26 12:36:15 Re: Problem with planer
Previous Message Thomas H. 2008-08-26 09:45:09 Re: BUG #4281: some types of errors do not log statements