't' and 'f' strings in csv are considered as boolean

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

Mozilla Public License 2.0

4.78k stars 202 forks source link

Open tony-sol opened 4 months ago

tony-sol commented 4 months ago

t and f values in csv cells are considered as boolean values

Version: 0.13.0 System: macos 14.5 Shell: zsh 5.9 (arm-apple-darwin23.0.0)

Steps to reproduce:

echo 'r,t,y,f,g' | octosql "SELECT * FROM stdin.csv?header=false"

Example: