[Please CC me in replies, as I am not subscribed to this mailing list.] The ext/misc/csv.c loadable extension handles single-column CSVs incorrectly. Note that this is *not* the same code as ".mode csv" + ".import 1.csv t1". Ref. https://sqlite.org/csv.html
A minimal reproduction follows. A full build transcript is attached. Note that RFC4180 specifies CRLF, but this issue is reproducible in CSVs with Unix-style LF EOLs. # gcc -g -fPIC -shared ext/misc/csv.c -o csv.so # printf '1\r\n' >1.csv # printf '1,\r\n' >2.csv # ./sqlite3 SQLite version 3.23.1 2018-04-10 17:39:29 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .load ./csv sqlite> CREATE VIRTUAL TABLE temp.t2 USING csv(filename='2.csv'); sqlite> select * from t2; 1| sqlite> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='1.csv'); sqlite> select * from t1 limit 5; 1 sqlite> select count(*) from t2; 1 sqlite> select count(*) from t1; C-c C-cError: interrupted sqlite>
# wget -nv https://sqlite.org/2018/sqlite-src-3230100.zip 2018-06-01 02:30:58 URL:https://sqlite.org/2018/sqlite-src-3230100.zip [10849436/10849436] -> "sqlite-src-3230100.zip" [1] # unzip sqlite-src-3230100.zip # cd sqlite-src-3230100 # ./configure --enable-silent-rules && make configure: WARNING: unrecognized options: --enable-silent-rules checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for a sed that does not truncate output... /bin/sed checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for fgrep... /bin/grep -F checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B checking the name lister (/usr/bin/nm -B) interface... BSD nm checking whether ln -s works... yes checking the maximum length of command line arguments... 1572864 checking whether the shell understands some XSI constructs... yes checking whether the shell understands "+="... yes checking for /usr/bin/ld option to reload object files... -r checking for objdump... objdump checking how to recognize dependent libraries... pass_all checking for ar... ar checking for strip... strip checking for ranlib... ranlib checking command to parse /usr/bin/nm -B output from gcc object... ok checking how to run the C preprocessor... gcc -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking for dlfcn.h... yes checking for objdir... .libs checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC -DPIC checking if gcc PIC flag -fPIC -DPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.o... (cached) yes checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for a BSD-compatible install... /usr/bin/install -c checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for int8_t... yes checking for int16_t... yes checking for int32_t... yes checking for int64_t... yes checking for intptr_t... yes checking for uint8_t... yes checking for uint16_t... yes checking for uint32_t... yes checking for uint64_t... yes checking for uintptr_t... yes checking for sys/types.h... (cached) yes checking for stdlib.h... (cached) yes checking for stdint.h... (cached) yes checking for inttypes.h... (cached) yes checking malloc.h usability... yes checking malloc.h presence... yes checking for malloc.h... yes checking for fdatasync... yes checking for gmtime_r... yes checking for isnan... yes checking for localtime_r... yes checking for localtime_s... no checking for malloc_usable_size... yes checking for strchrnul... yes checking for usleep... yes checking for utime... yes checking for pread... yes checking for pread64... yes checking for pwrite... yes checking for pwrite64... yes checking for tclsh8.7... no checking for tclsh8.6... tclsh8.6 configure: Version set to 3.23 configure: Release set to 3.23.1 configure: Version number set to 3023001 checking whether to support threadsafe operation... yes checking for library containing pthread_create... -lpthread checking for library containing pthread_mutexattr_init... none required checking whether to support shared library linked as release mode or not... no checking whether to use an in-ram database for temporary tables... no checking if executables have the .exe suffix... unknown checking for Tcl configuration... found /usr/lib/tcl8.6/tclConfig.sh checking for existence of /usr/lib/tcl8.6/tclConfig.sh... loading checking for library containing readline... no checking for library containing tgetent... -ltermcap checking for readline in -lreadline... yes checking readline.h usability... no checking readline.h presence... no checking for readline.h... no checking for /usr/include/readline.h... no checking for /usr/include/readline/readline.h... yes checking for library containing fdatasync... none required checking zlib.h usability... yes checking zlib.h presence... yes checking for zlib.h... yes checking for library containing deflate... -lz checking for library containing dlopen... -ldl checking whether to support MEMSYS5... no checking whether to support MEMSYS3... no configure: creating ./config.status config.status: creating Makefile config.status: creating sqlite3.pc config.status: creating config.h config.status: executing libtool commands configure: WARNING: unrecognized options: --enable-silent-rules gcc -g -O2 -o mksourceid /Y/sqlite-src-3230100/tool/mksourceid.c tclsh8.6 /Y/sqlite-src-3230100/tool/mksqlite3h.tcl /Y/sqlite-src-3230100 >sqlite3.h gcc -g -O2 -o mkkeywordhash /Y/sqlite-src-3230100/tool/mkkeywordhash.c ./mkkeywordhash >keywordhash.h gcc -g -O2 -o lemon /Y/sqlite-src-3230100/tool/lemon.c cp /Y/sqlite-src-3230100/tool/lempar.c . cp /Y/sqlite-src-3230100/src/parse.y . rm -f parse.h ./lemon parse.y mv parse.h parse.h.temp tclsh8.6 /Y/sqlite-src-3230100/tool/addopcodes.tcl parse.h.temp >parse.h cat parse.h /Y/sqlite-src-3230100/src/vdbe.c | tclsh8.6 /Y/sqlite-src-3230100/tool/mkopcodeh.tcl >opcodes.h tclsh8.6 /Y/sqlite-src-3230100/tool/mkopcodec.tcl opcodes.h >opcodes.c tclsh8.6 /Y/sqlite-src-3230100/tool/mkshellc.tcl >shell.c cp /Y/sqlite-src-3230100/ext/fts5/fts5parse.y . rm -f fts5parse.h ./lemon fts5parse.y tclsh8.6 /Y/sqlite-src-3230100/ext/fts5/tool/mkfts5c.tcl cp /Y/sqlite-src-3230100/ext/fts5/fts5.h . rm -rf tsrc mkdir tsrc cp -f /Y/sqlite-src-3230100/src/alter.c /Y/sqlite-src-3230100/src/analyze.c /Y/sqlite-src-3230100/src/attach.c /Y/sqlite-src-3230100/src/auth.c /Y/sqlite-src-3230100/src/backup.c /Y/sqlite-src-3230100/src/bitvec.c /Y/sqlite-src-3230100/src/btmutex.c /Y/sqlite-src-3230100/src/btree.c /Y/sqlite-src-3230100/src/btree.h /Y/sqlite-src-3230100/src/btreeInt.h /Y/sqlite-src-3230100/src/build.c /Y/sqlite-src-3230100/src/callback.c /Y/sqlite-src-3230100/src/complete.c /Y/sqlite-src-3230100/src/ctime.c /Y/sqlite-src-3230100/src/date.c /Y/sqlite-src-3230100/src/dbpage.c /Y/sqlite-src-3230100/src/dbstat.c /Y/sqlite-src-3230100/src/delete.c /Y/sqlite-src-3230100/src/expr.c /Y/sqlite-src-3230100/src/fault.c /Y/sqlite-src-3230100/src/fkey.c /Y/sqlite-src-3230100/src/func.c /Y/sqlite-src-3230100/src/global.c /Y/sqlite-src-3230100/src/hash.c /Y/sqlite-src-3230100/src/hash.h /Y/sqlite-src-3230100/src/hwtime.h /Y/sqlite-src-3230100/src/insert.c /Y/sqlite-src-3230100/src/legacy.c /Y/sqlite-src-3230100/src/loadext.c /Y/sqlite-src-3230100/src/main.c /Y/sqlite-src-3230100/src/malloc.c /Y/sqlite-src-3230100/src/mem0.c /Y/sqlite-src-3230100/src/mem1.c /Y/sqlite-src-3230100/src/mem2.c /Y/sqlite-src-3230100/src/mem3.c /Y/sqlite-src-3230100/src/mem5.c /Y/sqlite-src-3230100/src/memdb.c /Y/sqlite-src-3230100/src/memjournal.c /Y/sqlite-src-3230100/src/msvc.h /Y/sqlite-src-3230100/src/mutex.c /Y/sqlite-src-3230100/src/mutex.h /Y/sqlite-src-3230100/src/mutex_noop.c /Y/sqlite-src-3230100/src/mutex_unix.c /Y/sqlite-src-3230100/src/mutex_w32.c /Y/sqlite-src-3230100/src/notify.c /Y/sqlite-src-3230100/src/os.c /Y/sqlite-src-3230100/src/os.h /Y/sqlite-src-3230100/src/os_common.h /Y/sqlite-src-3230100/src/os_setup.h /Y/sqlite-src-3230100/src/os_unix.c /Y/sqlite-src-3230100/src/os_win.c /Y/sqlite-src-3230100/src/os_win.h /Y/sqlite-src-3230100/src/pager.c /Y/sqlite-src-3230100/src/pager.h /Y/sqlite-src-3230100/src/parse.y /Y/sqlite-src-3230100/src/pcache.c /Y/sqlite-src-3230100/src/pcache.h /Y/sqlite-src-3230100/src/pcache1.c /Y/sqlite-src-3230100/src/pragma.c /Y/sqlite-src-3230100/src/pragma.h /Y/sqlite-src-3230100/src/prepare.c /Y/sqlite-src-3230100/src/printf.c /Y/sqlite-src-3230100/src/random.c /Y/sqlite-src-3230100/src/resolve.c /Y/sqlite-src-3230100/src/rowset.c /Y/sqlite-src-3230100/src/select.c /Y/sqlite-src-3230100/src/status.c /Y/sqlite-src-3230100/src/shell.c.in /Y/sqlite-src-3230100/src/sqlite.h.in /Y/sqlite-src-3230100/src/sqlite3ext.h /Y/sqlite-src-3230100/src/sqliteInt.h /Y/sqlite-src-3230100/src/sqliteLimit.h /Y/sqlite-src-3230100/src/table.c /Y/sqlite-src-3230100/src/tclsqlite.c /Y/sqlite-src-3230100/src/threads.c /Y/sqlite-src-3230100/src/tokenize.c /Y/sqlite-src-3230100/src/treeview.c /Y/sqlite-src-3230100/src/trigger.c /Y/sqlite-src-3230100/src/utf.c /Y/sqlite-src-3230100/src/update.c /Y/sqlite-src-3230100/src/util.c /Y/sqlite-src-3230100/src/vacuum.c /Y/sqlite-src-3230100/src/vdbe.c /Y/sqlite-src-3230100/src/vdbe.h /Y/sqlite-src-3230100/src/vdbeapi.c /Y/sqlite-src-3230100/src/vdbeaux.c /Y/sqlite-src-3230100/src/vdbeblob.c /Y/sqlite-src-3230100/src/vdbemem.c /Y/sqlite-src-3230100/src/vdbesort.c /Y/sqlite-src-3230100/src/vdbetrace.c /Y/sqlite-src-3230100/src/vdbeInt.h /Y/sqlite-src-3230100/src/vtab.c /Y/sqlite-src-3230100/src/vxworks.h /Y/sqlite-src-3230100/src/wal.c /Y/sqlite-src-3230100/src/wal.h /Y/sqlite-src-3230100/src/walker.c /Y/sqlite-src-3230100/src/where.c /Y/sqlite-src-3230100/src/wherecode.c /Y/sqlite-src-3230100/src/whereexpr.c /Y/sqlite-src-3230100/src/whereInt.h /Y/sqlite-src-3230100/ext/fts1/fts1.c /Y/sqlite-src-3230100/ext/fts1/fts1.h /Y/sqlite-src-3230100/ext/fts1/fts1_hash.c /Y/sqlite-src-3230100/ext/fts1/fts1_hash.h /Y/sqlite-src-3230100/ext/fts1/fts1_porter.c /Y/sqlite-src-3230100/ext/fts1/fts1_tokenizer.h /Y/sqlite-src-3230100/ext/fts1/fts1_tokenizer1.c /Y/sqlite-src-3230100/ext/fts2/fts2.c /Y/sqlite-src-3230100/ext/fts2/fts2.h /Y/sqlite-src-3230100/ext/fts2/fts2_hash.c /Y/sqlite-src-3230100/ext/fts2/fts2_hash.h /Y/sqlite-src-3230100/ext/fts2/fts2_icu.c /Y/sqlite-src-3230100/ext/fts2/fts2_porter.c /Y/sqlite-src-3230100/ext/fts2/fts2_tokenizer.h /Y/sqlite-src-3230100/ext/fts2/fts2_tokenizer.c /Y/sqlite-src-3230100/ext/fts2/fts2_tokenizer1.c /Y/sqlite-src-3230100/ext/fts3/fts3.c /Y/sqlite-src-3230100/ext/fts3/fts3.h /Y/sqlite-src-3230100/ext/fts3/fts3Int.h /Y/sqlite-src-3230100/ext/fts3/fts3_aux.c /Y/sqlite-src-3230100/ext/fts3/fts3_expr.c /Y/sqlite-src-3230100/ext/fts3/fts3_hash.c /Y/sqlite-src-3230100/ext/fts3/fts3_hash.h /Y/sqlite-src-3230100/ext/fts3/fts3_icu.c /Y/sqlite-src-3230100/ext/fts3/fts3_porter.c /Y/sqlite-src-3230100/ext/fts3/fts3_snippet.c /Y/sqlite-src-3230100/ext/fts3/fts3_tokenizer.h /Y/sqlite-src-3230100/ext/fts3/fts3_tokenizer.c /Y/sqlite-src-3230100/ext/fts3/fts3_tokenizer1.c /Y/sqlite-src-3230100/ext/fts3/fts3_tokenize_vtab.c /Y/sqlite-src-3230100/ext/fts3/fts3_unicode.c /Y/sqlite-src-3230100/ext/fts3/fts3_unicode2.c /Y/sqlite-src-3230100/ext/fts3/fts3_write.c /Y/sqlite-src-3230100/ext/icu/sqliteicu.h /Y/sqlite-src-3230100/ext/icu/icu.c /Y/sqlite-src-3230100/ext/rtree/rtree.h /Y/sqlite-src-3230100/ext/rtree/rtree.c /Y/sqlite-src-3230100/ext/session/sqlite3session.c /Y/sqlite-src-3230100/ext/session/sqlite3session.h /Y/sqlite-src-3230100/ext/rbu/sqlite3rbu.h /Y/sqlite-src-3230100/ext/rbu/sqlite3rbu.c /Y/sqlite-src-3230100/ext/misc/json1.c /Y/sqlite-src-3230100/ext/misc/stmt.c keywordhash.h opcodes.c opcodes.h parse.c parse.h config.h shell.c sqlite3.h tsrc rm tsrc/sqlite.h.in tsrc/parse.y tclsh8.6 /Y/sqlite-src-3230100/tool/vdbe-compress.tcl <tsrc/vdbe.c >vdbe.new mv vdbe.new tsrc/vdbe.c cp fts5.c fts5.h tsrc touch .target_source tclsh8.6 /Y/sqlite-src-3230100/tool/mksqlite3c.tcl cp tsrc/sqlite3ext.h . cp /Y/sqlite-src-3230100/ext/session/sqlite3session.h . ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DSQLITE_TEMP_STORE=1 -c sqlite3.c -o sqlite3.o >/dev/null 2>&1 ./libtool --mode=link gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -no-undefined -o libsqlite3.la sqlite3.lo -ldl -lz -lpthread \ -rpath "/usr/local/lib" -version-info "8:6:8" libtool: link: gcc -shared .libs/sqlite3.o -ldl -lz -lpthread -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6 libtool: link: (cd ".libs" && rm -f "libsqlite3.so.0" && ln -s "libsqlite3.so.0.8.6" "libsqlite3.so.0") libtool: link: (cd ".libs" && rm -f "libsqlite3.so" && ln -s "libsqlite3.so.0.8.6" "libsqlite3.so") libtool: link: ar cru .libs/libsqlite3.a sqlite3.o ar: `u' modifier ignored since `D' is the default (see `U') libtool: link: ranlib .libs/libsqlite3.a libtool: link: ( cd ".libs" && rm -f "libsqlite3.la" && ln -s "../libsqlite3.la" "libsqlite3.la" ) ./libtool --mode=link gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DHAVE_READLINE=1 -I/usr/include/readline -DHAVE_EDITLINE=0 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_OFFSET_SQL_FUNC -DSQLITE_INTROSPECTION_PRAGMAS -o sqlite3 \ shell.c sqlite3.c \ -lreadline -ltermcap -ldl -lz -lpthread -rpath "/usr/local/lib" libtool: link: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DHAVE_READLINE=1 -I/usr/include/readline -DHAVE_EDITLINE=0 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTION -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_OFFSET_SQL_FUNC -DSQLITE_INTROSPECTION_PRAGMAS -o sqlite3 shell.c sqlite3.c -lreadline -ltermcap -ldl -lz -lpthread -Wl,-rpath -Wl,/usr/local/lib ./libtool --mode=compile --tag=CC gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DUSE_TCL_STUBS=1 -c /Y/sqlite-src-3230100/src/tclsqlite.c libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DUSE_TCL_STUBS=1 -c /Y/sqlite-src-3230100/src/tclsqlite.c -fPIC -DPIC -o .libs/tclsqlite.o libtool: compile: gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -DUSE_TCL_STUBS=1 -c /Y/sqlite-src-3230100/src/tclsqlite.c -o tclsqlite.o >/dev/null 2>&1 ./libtool --mode=link gcc -g -O2 -DSQLITE_OS_UNIX=1 -I. -I/Y/sqlite-src-3230100/src -I/Y/sqlite-src-3230100/ext/rtree -I/Y/sqlite-src-3230100/ext/icu -I/Y/sqlite-src-3230100/ext/fts3 -I/Y/sqlite-src-3230100/ext/async -I/Y/sqlite-src-3230100/ext/session -D_HAVE_SQLITE_CONFIG_H -DBUILD_sqlite -DNDEBUG -I/usr/include/tcl8.6 -DSQLITE_THREADSAFE=1 -DSQLITE_HAVE_ZLIB=1 -no-undefined -o libtclsqlite3.la tclsqlite.lo \ libsqlite3.la -L/usr/lib/x86_64-linux-gnu -ltclstub8.6 -ldl -lz -lpthread \ -rpath "/usr/share/tcltk/tcl8.6/sqlite3" \ -version-info "8:6:8" \ -avoid-version libtool: link: gcc -shared .libs/tclsqlite.o -Wl,-rpath -Wl,/Y/sqlite-src-3230100/.libs ./.libs/libsqlite3.so -L/usr/lib/x86_64-linux-gnu -ltclstub8.6 -ldl -lz -lpthread -Wl,-soname -Wl,libtclsqlite3.so -o .libs/libtclsqlite3.so libtool: link: ar cru .libs/libtclsqlite3.a tclsqlite.o ar: `u' modifier ignored since `D' is the default (see `U') libtool: link: ranlib .libs/libtclsqlite3.a libtool: link: ( cd ".libs" && rm -f "libtclsqlite3.la" && ln -s "../libtclsqlite3.la" "libtclsqlite3.la" ) # gcc -g -fPIC -shared ext/misc/csv.c -o csv.so # printf '1\r\n' >1.csv # printf '1,\r\n' >2.csv # ./sqlite3 SQLite version 3.23.1 2018-04-10 17:39:29 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .load ./csv sqlite> CREATE VIRTUAL TABLE temp.t2 USING csv(filename='2.csv'); sqlite> select * from t2; 1| sqlite> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='1.csv'); sqlite> select * from t1 limit 5; 1 sqlite> select count(*) from t2; 1 sqlite> select count(*) from t1; C-c C-cError: interrupted sqlite>
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users