Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 321675

Summary: SQL alias doesn't affect for column name in dataset
Product: z_Archived Reporter: Jan Lerby <lerby84>
Component: BIRTAssignee: Birt-ReportEngine-inbox <Birt-ReportEngine-inbox>
Status: CLOSED DUPLICATE QA Contact: Xiaoying Gu <bluesoldier>
Severity: normal    
Priority: P3 CC: bluesoldier
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description Jan Lerby CLA 2010-08-04 03:51:24 EDT 
Build Identifier: 20090619-0625

Hi,

here is short description

when I have in my report a dataset with sql query:
SELECT employeeName AS name, CONCAT(employSurname,'') AS surname FROM employee

causes that first column name is still employeeName, second is surname as I want. It means that without any function sql alias doesn't work for dataset.

It's especially visible when I use "export data" where I have name of columns. 

Reproducible: Always
Comment 1 Xiaoying Gu CLA 2010-08-04 22:55:43 EDT 

*** This bug has been marked as a duplicate of bug 312877 ***