BUG #3509: bug with command from with two tables
От | Raimundo Alves |
---|---|
Тема | BUG #3509: bug with command from with two tables |
Дата | |
Msg-id | 200708031230.l73CUCch053847@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3509: bug with command from with two tables
|
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: