On Thu, May 31, 2018 at 4:03 AM Trent W. Buck <trentb...@gmail.com> wrote: > Peter van Dijk wrote: > > I can reproduce this ‘hang’ (actually it’s a very busy read() loop). A > > simpler ‘echo 1,2,3 > test2.csv’ does work, so this is just exposing a bug > > in the CSV implementation. > > You're right --- it looks like ext/misc/csv.c is broken for one-column CSV > tables. > I can reproduce the problem with a minimal test.csv of "1\n". > I can prevent the problem with a minimal test.csv of "1,\n". > I guess that's a separate upstream bug! :-) Please report SQLite3 bugs directly to upstream[1].
> László, based on the sqliteodbc version numbers, I think "it hasn't > even gotten a version 1.0 yet" is a deliberate versioning scheme by > the author, not a reflection on its code quality: > http://www.ch-werner.de/sqliteodbc/ > The latest release is from Feb 2018 and speaks of SQLite 3.22.0; > the previous release (in Debian) is from Dec 2016 an speaks of SQLite 3.15.2. OK. Please ask its maintainer to update the package which might fix your issue and/or report it to that upstream as well. You know the details, that would help a lot to find the root cause and fix the bug. Thanks, Laszlo/GCS [1] http://www3.sqlite.org/cgi/src/wiki?name=Bug+Reports