Issue 113724 - Base-SQL with join and multiple records, returns copies of first record
Summary: Base-SQL with join and multiple records, returns copies of first record
Status: CLOSED DUPLICATE of issue 113631
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m84
Hardware: PC Windows XP
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-07 18:57 UTC by eremmel
Modified: 2010-10-04 08:48 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
More details about the issue via screenshots (25.02 KB, application/vnd.oasis.opendocument.text)
2010-08-07 18:59 UTC, eremmel 		no flags Details
Test database with two queries to show that join in base mode shows 'duplicate' values (8.96 KB, application/vnd.sun.xml.base)
2010-10-04 08:48 UTC, eremmel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eremmel 2010-08-07 18:57:39 UTC 
Dev300m86 build 9518

I've a two table inner join and when running the query in BASE-SQL mode I get
the right number of records, but the data is a copy of the first record
returned. This does not happen when running the query in Native-SQL mode.

This behavior is when I run the query from SQL and when I use the query in a form. 

I experienced this with DB Access, but copying the tables and query to HSQLDB
showed the same issue. I attach a document with screen shots, because the
database contains sensitive data. On request I'll put effort in making a
reproduction database.
Comment 1 eremmel 2010-08-07 18:59:36 UTC 
Created attachment 71004 [details]
More details about the issue via screenshots
Comment 2 r4zoli 2010-08-08 07:49:23 UTC 
It seems to me, as duplicate to issue: 113631 .

*** This issue has been marked as a duplicate of 113631 ***
Comment 3 Mechtilde 2010-08-15 10:17:11 UTC 
duplicate -> closed
Comment 4 eremmel 2010-10-04 08:48:49 UTC 
Created attachment 71929 [details]
Test database with two queries  to show that join in base mode shows 'duplicate' values