Unknown column 'YEAR' in 'field list'

Description

discovered this error when working with one of the NF tables on Synapse (syn16857542).

We have a column called 'year'.

If the query is written as: `SELECT year FROM syn16857542` we get the error `Unknown column 'YEAR' in 'field list' `

If it is written as `SELECT 'year' FROM syn16857542` the query works fine.

I saw this in SWC, and Andrew observed this in the python client, so we're guessing it has something to do with YEAR being a function that is surfaced in synapse.

edit: From my perspective the bug here is the error, which is not informative to the end user.

Environment

None

Assignee

Nicoletta Gilbertson

Reporter

Robert Allaway

Labels

None

Validator

Robert Allaway

Development Area

None

Release Version History

None

Sprint

Fix versions

Priority

Major
Configure