Re: BUG #3509: bug with command from with two tables

Bom, então provavelmente o problema é como JDBC que está usando, já
que no PGAdmin3 funciona corretamente.
Lembre-se que a versão TEM QUE SER do postgresql 8.2...

Veja http://jdbc.postgresql.org/download.html

2007/8/3, Raimundo Alves <raimundoas(at)gmail(dot)com>:
>
>
> The following bug has been logged online:
>
> Bug reference: 3509
> Logged by: Raimundo Alves
> Email address: raimundoas(at)gmail(dot)com
> PostgreSQL version: 8.2.4
> Operating system: Windows
> Description: bug with command from with two tables
> Details:
>
> i am using the postgres at an application Java with jdbc3.
>
> i have two tables with this struct:
>
> CREATE TABLE table1
> (
> field1 bigint,
> field2 timestamp without time zone,
> field3 integer[],
> field4 text[],
> field5 text[],
> field6 text[],
> field7 text[],
> field8 integer[],
> field9text[],
> field10 character(1)[],
> field11 real[],
> field12 bigint[],
> field13 timestamp without time zone[],
> field14 boolean[],
> field15 bytea[],
> field16 text[],
> field17 double precision[]
> )
>
> CREATE TABLE table2
> (
> field1 bigint,
> field2 bigint,
> field3 character varying(200),
> field4 boolean
> )
>
> when i use this command "select * from table1, table2 where table2.field1=
> 1 and table2.field3 = 'value' and table2.field2 = table1.field1", the
> return
> come field7 of table1 with values incomplete.
>
> other problem is when exist only one register in database and i execute
> select "select * from table1 where 'value' = any (objects.field4) and 1 =
> any (objects.field3)", not return the register.
>
> all these commands when i execute in "execute query" of pgadminIII not
> have
> problem.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
William Leite Araújo
Estudante de paternidade - 17a semana