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>
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
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'),
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
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);
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
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
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
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
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
10 matches
Mail list logo