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
