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
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
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
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
>
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
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
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
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
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
9 matches
Mail list logo