Issue 66012

Summary:

list box shows wrong column if datasource is parsed SELECT column1+clomn2

Product:

Base

Reporter:

Regina Henschel <rb.henschel>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 2.0.3

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
testbase with embedded HSQL	none

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".