BUG #3509: bug with command from with two tables

From: "Raimundo Alves" <raimundoas(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3509: bug with command from with two tables
Date: 2007-08-03 12:30:12
Message-ID: 200708031230.l73CUCch053847@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message William Leite Araújo 2007-08-03 14:19:48 Re: BUG #3509: bug with command from with two tables
Previous Message Казорез Александр Олегович 2007-08-03 11:33:51 Bug Pgsql