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

Cannot query from current version of table if using '.' notation

Description

Repro:

  • create table

  • add some rows

  • create version

  • add row

  • show versions

  • select version 1 (in my case https://staging.synapse.org/#!Synapse:syn20551475.1) ==> OK

  • select version in progress (in my case https://staging.synapse.org/#!Synapse:syn20551475.2/tables/) ==> no results (same when changing the query itself)

The query is '{sql: "SELECT * FROM syn20551475.2", includeEntityEtag: true, isConsistent: true, offset: 0, limit: 25}'.

The response is:

1 {"concreteType":"org.sagebionetworks.repo.model.table.QueryResultBundle","queryResult":{"concreteType":"org.sagebionetworks.repo.model.table.QueryResult","queryResults":{"headers":[],"concreteType":"org.sagebionetworks.repo.model.table.RowSet","tableId":"syn20551475.2","rows":[]}},"selectColumns":[],"columnModels":[]}

Is it not because technically there is no '.2' yet? The version in progress should have no version.

Environment

None

Status

Assignee

Jay Hodgson

Reporter

Xavier Schildwachter

Labels

None

Validator

Xavier Schildwachter

Release Version History

None

Fix versions

Priority

Major