We're updating the issue view to help you get more done. 

Python test failure

Description

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.

1 2 3 4 5 6 7 8 9 >>>>>> Request <<<<<< https://repo-staging.prod.sagebase.org/repo/v1/entity/syn11219957/table/query/async/start POST >>> Headers: {'Accept': 'application/json; charset=UTF-8', 'content-type': 'application/json; charset=UTF-8', 'signature': b'm/P3CJOkkjisnhDiXlA+zvG86iw=', 'Accept-Encoding': 'gzip, deflate', 'signatureTimestamp': '2017-10-13T18:26:10.000Z', 'Connection': 'keep-alive', 'User-Agent': 'synapseclient/1.7.3 python-requests/2.18.4', 'userId': 'synapse-test', 'Content-Length': '178'} >>> Body: {"query": {"isConsistent": true, "sql": "select artist, album, year, catalog, cover from syn11219957"}, "concreteType": "org.sagebionetworks.repo.model.table.QueryBundleRequest"} >>>>>> Response <<<<<< <Response [400]> >>> Headers: {'Connection': 'keep-alive', 'Server': 'Apache-Coyote/1.1', 'Content-Encoding': 'gzip', 'Vary': 'Accept-Encoding,User-Agent', 'Content-Type': 'application/json;charset=UTF-8', 'Date': 'Fri, 13 Oct 2017 18:26:55 GMT', 'Content-Length': '301', 'Access-Control-Allow-Origin': '*'} >>> Body: {"reason":"org.sagebionetworks.table.query.ParseException: Encountered \" \"YEAR\" \"year \"\" at line 1, column 23.\nWas expecting one of:\n \"\\\"\" ...\n \"\\'\" ...\n <unsigned_integer> ...\n <exact_numeric_literal> ...\n <approximate_numeric_literal> ...\n <count_asterisk> ...\n \"AVG\" ...\n \"COUNT\" ...\n \"INTERVAL\" ...\n \"MAX\" ...\n \"MIN\" ...\n \"SUM\" ...\n <date_time_function_name> ...\n <string_function_name> ...\n <regular_identifier> ...\n \"(\" ...\n \"-\" ...\n \"+\" ...\n "}

Environment

Master against staging 201.0-x

Status

Assignee

Larsson Omberg

Reporter

Xavier Schildwachter

Validator

Bruce Hoff

Components

Fix versions

Affects versions

py-1.7

Priority

Major