vollt icon indicating copy to clipboard operation
vollt copied to clipboard

Column aliases are simplified when prefixed with a table name

Open ManonMarchand opened this issue 1 year ago • 2 comments

Hi Greg,

The following query

SELECT TOP 1 qual AS "flux.qual" FROM flux

Returns a column qual where flux. is removed. This is an unexpected behaviour as this alias is not incorrect.

Looks like this comes from the rule for simplificationNeeded here:

https://github.com/gmantele/vollt/blob/1481ccb5e7a573725d1ed38b620a466221b171ce/src/tap/metadata/TAPColumn.java#L194

Where the regexp could be something along "[^"]+" ?

ManonMarchand avatar Feb 09 '24 10:02 ManonMarchand