[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
