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

BUG #3250: Different ResultSets btw JDBC Driver and pgAdmin3

From: "Simon K" <casikanya(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3250: Different ResultSets btw JDBC Driver and pgAdmin3
Date: 2007-04-24 09:56:06
Message-ID: 200704240956.l3O9u6cG007976@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3250
Logged by:          Simon K
Email address:      casikanya(at)yahoo(dot)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 by date

Next:From: Heikki LinnakangasDate: 2007-04-24 11:51:34
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect
Previous:From: Michael MeskesDate: 2007-04-24 07:44:57
Subject: Re: [HACKERS] BUG #3244: problem with PREPARE

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