Thread: BUG #3509: bug with command from with two tables
The following bug has been logged online: Bug reference: 3509 Logged by: Raimundo Alves Email address: raimundoas@gmail.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.
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
--
William Leite Araújo
Estudante de paternidade - 17a semana
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@gmail.com>:
The following bug has been logged online:
Bug reference: 3509
Logged by: Raimundo Alves
Email address: raimundoas@gmail.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