BUG #1322: Bug while Insert into TempResult Select cols ..... statement - Mailing list pgsql-bugs

From PostgreSQL Bugs List
Subject BUG #1322: Bug while Insert into TempResult Select cols ..... statement
Date
Msg-id 20041116103829.53399738890@www.postgresql.com
Whole thread Raw
Responses Re: BUG #1322: Bug while Insert into TempResult Select cols ..... statement
List 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

pgsql-bugs by date:

Previous
From: "John Kennedy"
Date:
Subject: Beta4 postgres.exe crash "...terminated by signal 5"
Next
From: Devrim GUNDUZ
Date:
Subject: Re: BUG #1320: 7.3.8 server RPM has file error