Skip site navigation (1) Skip section navigation (2)

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

From: William Leite Araújo <william(dot)bh(at)gmail(dot)com>
To: "Raimundo Alves" <raimundoas(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3509: bug with command from with two tables
Date: 2007-08-03 14:19:48
Message-ID: bc63ad820708030719u521385d6rac5cafa96315d586@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
     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

In response to

pgsql-bugs by date

Next:From: William Leite AraújoDate: 2007-08-03 14:47:51
Subject: Re: BUG #3506: to_number silently ignore characters
Previous:From: Raimundo AlvesDate: 2007-08-03 12:30:12
Subject: BUG #3509: bug with command from with two tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group