Horton

Thread

  1. General Bug Report: statement.executeUpdate returns the wrong value

    Unprivileged user <nobody> — 1998-12-22T22:24:06Z

    ============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		: Yaoshiang Ho
Your email address	: yaosh@henchmen.com

Category		: runtime: front-end: Java
Severity		: serious

Summary: statement.executeUpdate returns the wrong value

System Configuration
--------------------
  Operating System   : Linux Redhat 2.036

  PostgreSQL version : 6.2

  Compiler used      : jdk 1.1.17

Hardware:
---------
Celeron 233

Versions of other tools:
------------------------
none.

--------------------------------------------------------------------------

Problem Description:
--------------------
On line 742 of Connection.java, you just stick a 1
in for the updateCount paramter, instead of an accurat
count.  

--------------------------------------------------------------------------

Test Case:
----------
Just try executing the string "create table t as (i int)".
the retval of executeUpdate should be 0, but is 1.

--------------------------------------------------------------------------

Solution:
---------
You will have to look at the client-server protocol and
figure out how to get the row count out.  It is possible : 
psql gives accurate counts.

--------------------------------------------------------------------------