[sqlite] Broken database after experiments with fts.

2016-03-26 Thread John Found
On Sat, 26 Mar 2016 16:08:33 +0100 Eduardo Morras wrote: > On Sat, 26 Mar 2016 16:37:18 +0200 > John Found wrote: > > > Why cannot drop the table test? > > > > sqlite> begin transaction; > > sqlite> create virtual table test using fts5; > > Error: vtable constructor failed: test > > sqlite>

[sqlite] Index Selection

2016-03-26 Thread Igor Tandetnik
On 3/26/2016 6:12 PM, Denis Burke wrote: > CREATE INDEX [IndxT1C3] > ON [T1]( > [C3] COLLATE [NOCASE]); > -- > after doing this: > explain query plan > select C1 from T1 > where C3='2016-01-02' You are requesting a case sensitive comparison; a case insensitive index cannot be used

[sqlite] Index Selection

2016-03-26 Thread Denis Burke
I apologize if I am missing something elementary here. I cannot understand why this index is not helpful. CREATE TABLE [T1]( [C1] TEXT, [C2] TEXT, [C3] DATE); CREATE INDEX [IndxT1C3] ON [T1]( [C3] COLLATE [NOCASE]); insert into t1 values ('aa','bb','2016-01-01'),

[sqlite] Broken database after experiments with fts.

2016-03-26 Thread John Found
Why cannot drop the table test? sqlite> begin transaction; sqlite> create virtual table test using fts5; Error: vtable constructor failed: test sqlite> commit; sqlite> sqlite> drop table test; Error: vtable constructor failed: test sqlite> .tables test test_content test_docsize

[sqlite] Index Selection

2016-03-26 Thread Keith Medcalf
No, it is working perfectly. The index cannot be used because the equal (=) operator is collate BINARY. If you want the column C3 to be not case sensitive you declare the table thusly: .eqp on create table t1 ( c1 text, c2 text, c3 text collate nocase ); create index IndxT1C3 on T1(C3);

[sqlite] Broken database after experiments with fts.

2016-03-26 Thread Eduardo Morras
On Sat, 26 Mar 2016 16:37:18 +0200 John Found wrote: > Why cannot drop the table test? > > sqlite> begin transaction; > sqlite> create virtual table test using fts5; > Error: vtable constructor failed: test > sqlite> commit; > sqlite> > sqlite> drop table test; > Error: vtable constructor

[sqlite] Broken database after experiments with fts.

2016-03-26 Thread Keith Medcalf
And only when commit is used to end the transaction, an explicit rollback works properly. > On Saturday, 26 March, 2016 09:09, Eduardo Morras > wrote: > > Clearly the tables were created, however (see the output from .tables). > > This *only* occurs if you wrap the "create virtual table" in

[sqlite] Broken database after experiments with fts.

2016-03-26 Thread Keith Medcalf
On Saturday, 26 March, 2016 09:09, Eduardo Morras wrote: Clearly the tables were created, however (see the output from .tables). This *only* occurs if you wrap the "create virtual table" in an explicit transaction but does not occur if an implicit transaction is used. The tables are

[sqlite] sqlite in vba7.1 and windows 8.1

2016-03-26 Thread Bart Smissaert
Did you figure this out? I have just come across the same problem in a 64 bit Office (Excel) installation. RBS On Fri, Feb 19, 2016 at 1:31 PM, Montes C?mara, < victor.montes at alicante-ayto.es> wrote: > Hello, > > I've been using sqlite in vba6 for some years using RichClient3 framework > of

[sqlite] Help needed for COPY Command.

2016-03-26 Thread Domingo Alvarez Duarte
Hello ! Have you ever heard about user friendly "alias/shortcut" ? Cheers ! > Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden" > Subject: Re: [sqlite] Help needed for COPY >Command. > > On Fri, 25 Mar 2016 17:18:16 +0100 > "Domingo Alvarez Duarte" wrote: > > >>Why not have