Re: [sqlite] loading extension csv.c

2020-02-07 Thread chiahui chen
SAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -g -O2 -o sqlite3 sqlite3-shell.o sqlite3-sqlit

[sqlite] loading extension csv.c

2020-02-06 Thread chiahui chen
Hi, After few attempts to load csv extension, (already tried gcc -arch x86_64 -g -fPIC -dynamiclib csv.c -o csv.dylib and gcc -g -fPIC -dynamiclib csv.c -o csv.dylib ) Mac terminal returns errors as followings: csv.c:115:3: error: no member named '__builtin___vsnprintf_chk' in

[sqlite] importing data to a table that has generated-columns

2020-01-26 Thread chiahui chen
Hi, After creating a table (total 8 columns including 1 generated column) , I tried to import data from a csv file (each record has values for 7 columns that match the non-generated column names and data types, no headers ). The system issued " error: table has 7 columns but 8 values were