Syntax error when there is a ":" in header

dinedal / textql

Execute SQL against structured text like CSV or TSV

MIT License

9.07k stars 300 forks source link

Syntax error when there is a ":" in header #23

Closed alexstrat closed 10 years ago

alexstrat commented 10 years ago

Probably linked to #21

$ echo 'foo,bar,foobar\n2,3,4' |textql -header -sql "select * from tbl"
2, 3, 4
$ echo 'foo,bar,foo:bar\n2,3,4' |textql -header -sql "select * from tbl"
2014/02/11 16:11:30 near ":bar": syntax error

Thx

dinedal commented 10 years ago

Hah you're right, and I can't even find where ":" is not supported in SQLite table names.

Patch incoming

alexstrat commented 10 years ago

Thanks