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: Pine.BSO.4.63.0607062019410.384@leary2.csoft.net (view raw or flat)
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 
releases.  http://www.ejurka.com/pgsql/jars/gr/

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-2014 The PostgreSQL Global Development Group