You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Python casts "yes" and "no" both to True. The RDBMS you mention cast one to True and one to False, I assume. Best to not pick a side, IMO. I prefer there being no cast at all and requiring the user to write down themselves (using case statements) how to convert strings to Booleans. For example, you might be interested in yes/no parsing, the next person might be interested in True/False parsing, the next person in Y/N, the next person in non-empty vs empty string, the next person in string vs null, the next person in Ja/Nein.
I can't argue about that because it really depends what DuckDB is aiming for. My recommendation was to aim for H2 or HyperSQL at least and most time you refer to Postgres yourself. (SQLLite and MySQL are less appealing to me.)
We can close this issue immediately. I just write down things I notice while going through all DuckDB functions systematically. Your call please.
What happens?
CAST( 'yes' AS BOOLEAN)
fails, when all other RDBMS support it.Same for
no
of course.To Reproduce
OS:
Linux
DuckDB Version:
0.10.2
DuckDB Client:
Java
Full Name:
Andreas Reichel
Affiliation:
manticore-projects.com
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?
The text was updated successfully, but these errors were encountered: