file name can not be numberic only

[swuecho]

➜   textql --header --sql "count(1) " 1234.csv  
2016/05/07 12:51:21 near "1234": syntax error

rename the 1234.csv to sample.csv works

[dinedal]

https://www.sqlite.org/lang_keywords.html

Try textql --header --sql "count(1) from [1234]" 1234.csv

And yes, I need to support this quoting in the SQL parser :)

[swuecho]

thanks. quote the table name works, although select can not be omitted.

➜  textql --header --sql "count(1) from [1234]" 1234.csv  
2016/05/07 12:59:45 near "count": syntax error
➜  textql --header --sql "select count(1) from [1234]" 1234.csv  
268486

BTW, great work! Thanks.

[David-Guillot]

Thanks @swuecho for reporting this issue, I didn't think of renaming the file ;)

@dinedal don't need to rush on this one, the workarounds work well ;)