Re: Problem with planer - Mailing list pgsql-bugs

From Hans-Juergen Schoenig
Subject Re: Problem with planer
Date
Msg-id 48B3D7D6.3050709@cybertec.at
Whole thread Raw
In response to Problem with planer  (<Eugen.Konkov@aldec.com>)
List pgsql-bugs
Eugen.Konkov@aldec.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

pgsql-bugs by date:

Previous
From: "Thomas H."
Date:
Subject: Re: BUG #4281: some types of errors do not log statements
Next
From:
Date:
Subject: Re: Problem with planer