Issue 66012 - list box shows wrong column if datasource is parsed SELECT column1+clomn2
Summary: list box shows wrong column if datasource is parsed SELECT column1+clomn2
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-01 19:28 UTC by Regina Henschel
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

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


Attachments
testbase with embedded HSQL (48.01 KB, application/vnd.sun.xml.base)
2006-06-01 19:30 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Regina Henschel 2006-06-01 19:28:21 UTC
I use OOo2.0.3rc4de.

I want to show the whole record in a list box, but link to the primary key.
Therefore I use a query as datasource, which has the concatenated record in the
first column and the primary key in the second record. I tried this versions
(1) with function CONCAT, parsed SQL
SELECT CONCAT( CONCAT( CONCAT( CONCAT( "ID", ' | ' ), "Lehrer" ), ' | ' ),
"Raum" ) AS "info", "ID" FROM "Klassen" "Klassen"
(2) with + , parsed SQL
SELECT "ID" + ( ' | ' ) + "Lehrer" + ( ' | ' ) + "Raum" AS "info", "ID" FROM
"Klassen" "Klassen"
(3) same as (2), native SQL

Version (2) doesn't show the "info" column in the listbox, although all three
queries show the same table, when you run them as query.
Try the forms in the attached testbase.
Comment 1 Regina Henschel 2006-06-01 19:30:15 UTC
Created attachment 36860 [details]
testbase with embedded HSQL
Comment 2 Frank Schönheit 2006-06-09 09:45:42 UTC
confirming, grabbing, targeting
Comment 3 Marcus 2017-05-20 10:47:53 UTC
Reset assigne to the default "issues@openoffice.apache.org".