Horton

BUG #1322: Bug while Insert into TempResult Select cols ..... statement

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

View thread
From: "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>
To: pgsql-bugs@postgresql.org
Date: 2004-11-16T10:38:29Z
Lists: pgsql-bugs 
The following bug has been logged online:

Bug reference:      1322
Logged by:          Bahadur Singh

Email address:      bahadursingh@yahoo.com

PostgreSQL version: 8.0 Beta

Operating system:   Windows 2000 server

Description:        Bug while Insert into TempResult Select cols ..... 
statement 

Details: 

PostgreSQL Version : PostgreSQL 8.0.0 Beta 4 
OS : Windows Server 2000


I found a bug on Beta 4 release for Windows 2000 when inserting a large 
amount of data from Select statement using pgdev-306-JDBC2 driver. 

The Select returns 480,384 rows if executed on pgAdmin III SQL tool.

SQL : 
INSERT INTO TEMPRESULT Select cols ...... with some consitions

When I call 

    stmt.execute() 
it inserts onyl 192 rows to result table.

More problematic ?? 

on calling
int n =   stmt.executeUpdate ()
it inserts 480,384 rows but returns 239,199 as value of n.

Less problematic: Rows in DB are correct.

It is working well, if result amount is less (less means about 10,000). 


Best Wishes
Bahadur