Skip to content
This repository has been archived by the owner on Jul 11, 2023. It is now read-only.

Zero length string value converts to <NA> #38

Closed
StpMax opened this issue Sep 20, 2021 · 2 comments
Closed

Zero length string value converts to <NA> #38

StpMax opened this issue Sep 20, 2021 · 2 comments
Assignees
Labels
bug Something isn't working

Comments

@StpMax
Copy link
Contributor

StpMax commented Sep 20, 2021

If i do:

df = pd.DataFrame([['a', '']], columns=['a','b'])
dfsql.sql_query('select * from df', df=df)

then i get:

   a     b
0  a  <NA>
@StpMax StpMax added the bug Something isn't working label Sep 20, 2021
@StpMax
Copy link
Contributor Author

StpMax commented Sep 20, 2021

also sql_query returns wrong result if use empty string as filter:

df = pd.DataFrame([['a', '']], columns=['a','b'])
dfsql.sql_query("select * from df where b = ''", df=df)

result is Empty DataFrame

@btseytlin btseytlin self-assigned this Sep 21, 2021
@tomhuds
Copy link

tomhuds commented May 25, 2023

@StpMax can we archive this project? or close issue?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants