Make sure SQL functions, including "year", are quoted correctly
Getting error below.
The query is 'select artist, album, year, catalog, cover from syn11219957'. 'Year' is now a function so we should quote the column name.
Master against staging 201.0-x
Thanks Xa! I will rename the ticket so that I can quickly determine what do to here.
The problem was that 'Year' needed to be quoted in the query (else it's parsed as a function name).
The only place where I see this is: synapsePythonClient//synapseclient/table.py.
Note: Integrations test passed OK.
Also, the error return now is "Unknown column 'YEAR' in 'field list'" which is a bit misleading.
, which test failed? Do you have the full stack trace? Or is this a syn.tableQuery failure because of the quotes?