Synapse 'distinct' is case insensitive

Description

Going to the web client to synapse table with the following query:
```
SELECT distinct sex FROM syn20449214 where isCellLine is NULL OR isCellLine='FALSE'
```
gets me 'Female' and 'Male'

However, when i use the python client (via reticulate in R, because of package dependencies):
> expData<-syn$tableQuery(paste("SELECT * FROM",syn_file,"where isCellLine is NULL OR isCellLine='FALSE'"))$asDataFrame()
> unique(expData$seq)
"Male" "Female" "male" "female"

which is the true table?

Environment

None

Assignee

Ryan Luce

Reporter

Sara Gosline

Labels

None

Validator

Sara Gosline

Development Area

None

Release Version History

None

Components

Priority

Major
Configure