Duplicate column names/aliases in Flex Report

EASOL / easol

EASOL - A New Way to Open Learning with Ed-Tech

http://easol.org

GNU Affero General Public License v3.0

1 stars 4 forks source link

Duplicate column names/aliases in Flex Report #263

Open jamessun opened 8 years ago

jamessun commented 8 years ago

The following Flex Report CommandText:

SELECT 
'X' AS XAxis
, 1 AS YAxis
, 2 AS YAxis

causes a JavaScript error to be returned from EASOL.

chrome_2016-02-12_10-07-12

See this http://easol-dev.azurewebsites.net/reports/view/53

edgarf commented 8 years ago

Thank you James, are the results after you close this error popup correct in the table?

jamessun commented 8 years ago

No, I don't think the results are correct.

When I run this query in SQL Server Management Studio, the result has three columns with two columns having the same name. In EASOL, I don't see a value in the last column.