-
Notifications
You must be signed in to change notification settings - Fork 165
Open
Description
I want to use dsq in the interactive mode -i, however, when I open the same file more than once with interactive mode dsq always fails to start interactive mode. It fails with the following error message: table "t_0" already exists.
- I'm able to produce this consistently with any valid csv file I pass to it.
- I have not tried other file types.
- I'm using whatever version of
dsqis available on brew - I've also validated that this behavior exists on
mainby building the source locally
Here's an example file I created and saved as test.csv
$ cat test.csv
column1, column2, column3
a,b,c
d,e,f
The first invocation of dsq -i is usually successful, however, it emits this log line: Cache invalid, re-import required. even if I've never run -i before.
$ dsq -i test.csv
Cache invalid, re-import required.
dsq> exit
EOF
All subsequent invocations of dsq -i test.csv fail with:
$ dsq -i test.csv
table "t_0" already exists
$ echo $?
1
Removing the sqlite DB for that file allows me to run -i, however, with the same Cache invalid... log error as before:
$ rm $(dsq -D test.csv)
Zhen3r and neiled
Metadata
Metadata
Assignees
Labels
No labels