unexpected behavior when SELECTing column from a table

Description

I tried to select column year from this table:

SELECT author, title, journal, pmid, year FROM syn16857542

but got the error "Unknown column 'YEAR' in 'field list'"

If I quote ‘year’ (SELECT author, title, journal, pmid, 'year' FROM syn16857542) the query works. This may or may not be a bug, but I certainly didn't expect it.

Environment

None

Assignee

Marco Marasca

Reporter

Robert Allaway

Labels

None

Validator

Xavier Schildwachter

Development Area

Synapse Core Infrastructure

Release Version History

None

Components

Priority

Major
Configure