[sqlite] How to import TSV table with double quote in it without having to escape double quote

Hi, I got the following error. I don't want to escape the quote charaters in the input. Is there still a way to import quote characters into a sqlite3 table? $ cat my.sql3 create table mytab (var text); .separator "\t" .import /dev/stdin mytab $ cat main.sh #!/usr/bin/env bash # vim: set

Re: [sqlite] Why sqlite fts5 Unicode61 Tokenizer does not support CJK(Chinese Japanese Krean)?

Hi Hideaki, Thanks for your reply which made me figure out why I said icu version does "not" support Chinese: b/c in Chinese '中文' can be tokenize as either '中文' or '中' or '文' so when query '中文' or '中*' I can get the result but no result when query '文'. The same goes to '为什么', which can be be

[sqlite] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

Folks, I cannot seem to find a means of filtering on negated operators, e.g. <>, not null, not like, etc., in the xBestIndex() method for virtual vables. As best as I can tell, I cannot, unless there is something I am missing, hence this inquiry. In a few virtual tables I have implemented, I

Re: [sqlite] weekday time modifier

select strftime('%Y-%m-%d %H:%M', '2018-09-23 8:59', 'localtime','weekday 0'); Also gets a bit confusing. The "weekday" operates on the UTC time. On Sun, Sep 23, 2018 at 11:42 PM, Kevin Martin wrote: > Hi, > > Not sure if this is me misreading it, but the description of the weekday >

[sqlite] Bug report: Window functions in VIEWs broken in 3.25.1

Hi, Using the sqlite-tools-linux-x86-3250100 Linux binaries I find that Window functions in VIEWS behave differently from PostgreSQL 9.6 and from what I expect. DROP TABLE IF EXISTS example; CREATE TABLE example(t INT, total INT); INSERT INTO example VALUES(0,2); INSERT INTO example

[sqlite] More bug with sqlite3_declare_vtab; also comments about ALTER TABLE

There seems a bug with sqlite3_declare_vtab that if you specify both INTEGER PRIMARY KEY and WITHOUT ROWID then it segfaults. It is easily enough to work around, but it shouldn't segfault if the string pointer is a valid pointer to a null-terminated string and the database pointer is a valid

[sqlite] sqlite3_get_table() failed with error "database is locked"

Hi, Multiple applications called sqlite3_get_table() to read data in a same db file at the same time, got error "database is locked"? Why read-only access is locked? How to resolve the issue? Thanks, Liu ___ sqlite-users mailing list

[sqlite] sqlite 3.25.1 windows function. So it should be?

Hi! Maybe I do not understand something, but does it really have to work this way? DROP TABLE IF EXISTS t; CREATE TABLE t (v1,v2,v3,v4); INSERT INTO t (v1,v2,v3,v4) VALUES (1,1,1,0),(1,1,0,1),(2,1,0,10),(3,1,0,100),(3,1,0,1000); SELECT v1,v2,sum(v3+v4) OVER (PARTITION BY v2 ORDER

[sqlite] weekday time modifier

Hi, Not sure if this is me misreading it, but the description of the weekday modifier in the documentation seems a bit ambiguous. It says: > The "weekday" modifier advances the date forward to the next date where the > weekday number is N. Sunday is 0, Monday is 1, and so forth. It is not