Skip to content

Columns should be displayed in uppercase (at least in UNPIVOT result) #1387

@Vedin

Description

@Vedin

Currently unpivot.slt is not fully functional. Mostly due to lowercase/upercase difference in results.
Even when columns is specified in lowercase, they should be in uppercase in the result.
Example from slt:

SELECT *
  FROM monthly_sales
    UNPIVOT (sales FOR month IN (jan, feb, mar, apr))
  ORDER BY empid
----
1	electronics	JAN	100
1	electronics	FEB	200
1	electronics	MAR	300
1	electronics	APR	100
2	clothes	JAN	100
2	clothes	FEB	300
2	clothes	MAR	150
2	clothes	APR	200
3	cars	JAN	200
3	cars	FEB	400
3	cars	MAR	100
3	cars	APR	50
4	appliances	JAN	100
4	appliances	MAR	100
4	appliances	APR	50

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions