Issue 12748

Summary: re-fetch of every row in a DB-Table
Product: Base Reporter: hermann
Component: codeAssignee: Frank Schönheit <frank.schoenheit>
Status: CLOSED DUPLICATE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P2 CC: issues
Version: 644   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description hermann 2003-03-27 19:37:53 UTC 
Hi Frank,*,
I have made some tracing with hsqldb, so their are some strange things:

if I select a table in the DB-Explorer, OOo does first a:
select <ColumnName> from <Tablename> where 0=1 , and this for every Column
and than for every row of the resultset a:
SELECT * FROM "OOTable1" WHERE "OOTable1"."OOID" = 9

where 9 is only a single primaryKey. For me it seems that OOo builds the
resultsets by iterate thru this by singele sql-statements. 
If I go with basic to the db, all works fine.

BTW:
If anybody is looking as this, perhaps someone can point me to the steps what
OOo does by clicking on a table in the db-explorer
Comment 1 Frank Schönheit 2003-03-28 06:47:29 UTC 
submitted twice

*** This issue has been marked as a duplicate of 12747 ***
Comment 2 Frank Schönheit 2003-03-28 06:48:07 UTC 
closing duplicate
Comment 3 hans_werner67 2004-02-02 12:57:46 UTC 
change subcomponent to 'none'