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

Re: BUG #2514: (jdbc driver) Multiple inlined statements with

From: Kris Jurka <books(at)ejurka(dot)com>
To: Gilles <gilles(dot)rayrat(at)continuent(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2514: (jdbc driver) Multiple inlined statements with
Date: 2006-07-07 01:22:38
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs

On Wed, 5 Jul 2006, Gilles wrote:

> Bug reference:      2514
> Description:        (jdbc driver) Multiple inlined statements with mixed
> updates and queries return wrong results
> Details:
> When issuing this:
> statement.execute("SELECT 2;UPDATE foo SET d='babar' where i=1; SELECT 3");
> The 2 result returned is wrong. This seems to be a ResultSet containing the
> same values as the first RS (it should be an update count)

Fixed in CVS for 8.0, 8.1 and 8.2dev.  It was mistakenly retaining some 
state from the first SELECT when issuing the update.  I've put up a 
temporary jar file here if you need a fix before the next official 

Kris Jurka

In response to

pgsql-bugs by date

Next:From: Simon, AttilaDate: 2006-07-09 08:15:27
Subject: BUG #2521: pg_restore is hanging
Previous:From: Jean Paul Aguilar RuizDate: 2006-07-06 22:16:08
Subject: BUG #2520: security problem

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