BUG #3250: Different ResultSets btw JDBC Driver and pgAdmin3
От | Simon K |
---|---|
Тема | BUG #3250: Different ResultSets btw JDBC Driver and pgAdmin3 |
Дата | |
Msg-id | 200704240956.l3O9u6cG007976@wwwmaster.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3250 Logged by: Simon K Email address: casikanya@yahoo.com PostgreSQL version: 8.2 Operating system: Windows XP Description: Different ResultSets btw JDBC Driver and pgAdmin3 Details: when i execute this query in pgAdmin3, i get results but when i execute using JDBC (postgresql-8.2-504.jdbc4.jar) it retunrs no results SELECT pp.project_serial, pp.project_name, pp.descriptions, pp.start_date, pp.expected_end_date, pp.task_type, pe.known_name, pp.photo_mimetype, pc.category_name, ps.size_name FROM personnel_employees pe RIGHT OUTER JOIN projects_projects pp ON pe.employee_serial = pp.employee_cordinator LEFT OUTER JOIN projects_sizes ps ON pp.projects_sizes_serial = ps.projects_sizes_serial LEFT OUTER JOIN projects_categories pc ON pp.project_category_serial = pc.project_category_serial LEFT OUTER JOIN projects_permissions_department ppd ON pp.project_serial = ppd.project_serial LEFT OUTER JOIN projects_project_permissions ppp ON pp.project_serial = ppp.project_serial WHERE ((ppp.employee_serial = 1) OR (ppd.department_serial = null) OR (pp.employee_cordinator = 1) OR (pp.added_by=1)) AND ( pp.start_date >='2007-04-24' AND pp.start_date <='2007-04-24') AND (pp.project_name ILIKE '%%' OR pp.descriptions ILIKE '%%' OR pp.task_type ILIKE '%%' ) LIMIT 15 OFFSET 0
В списке pgsql-bugs по дате отправления: