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

Not recognizable column in query result

Description

This change in PLFM added a new field in the SelectColumn object: https://github.com/Sage-Bionetworks/Synapse-Repository-Services/pull/3348/files#diff-3391b309663d046c639a8b5ad69aa0d1
The Python client code does not recognize the new field. This cause error running table query against staging in both R and Python client. My test against staging:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 >>> import synapseclient >>> syn = synapseclient.login() Welcome, Kimyen Truong! >>> syn.repoEndpoint 'https://repo-staging.prod.sagebase.org/repo/v1' >>> qr = syn.tableQuery("select * from syn11213698 limit 1") [####################]100.00% 1/1 Done... Downloading [####################]100.00% 50.0bytes/50.0bytes (19.1kB/s) Job-67571347474773473790060892.csv Done... Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/client.py", line 2876, in tableQuery return CsvFileTable.from_table_query(self, query, **kwargs) File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/table.py", line 1558, in from_table_query headers=[SelectColumn(**header) for header in download_from_table_result['headers']]) File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/table.py", line 1558, in <listcomp> headers=[SelectColumn(**header) for header in download_from_table_result['headers']]) TypeError: __init__() got an unexpected keyword argument 'columnSQL' >>>

If we release staging without a fix, all table queries in the Python client and synapser client will be broken.

Environment

Status

Assignee

Kimyen Truong

Reporter

Kimyen Truong

Validator

Ziming Dong

Fix versions

Priority

Critical