On 03/23/2016 12:06 AM, Domingo Alvarez Duarte wrote:
> Hello !
>
> After seeing several times work/commits on fts5 I decided to try it on a
> table shown bellow, and when trying to populate it I get this error message:
>
>
> sqlite> INSERT INTO fts_idx_items(fts_idx_items) VALUES('rebuild');
>
I want to report a bug.
I write a tokenizer named thai?which is working according to the rule of thai
vowel,not by space.
I build a table using fts5,like this,
CREATE VIRTUAL TABLE tbl_tha using fts5( key1, key2,TOKENIZE="thai");
and then insert a record:
insert into tbl_tha
On 03/23/2016 10:48 AM, ? wrote:
> I want to report a bug.
>
>
> I write a tokenizer named thai?which is working according to the rule of thai
> vowel,not by space.
>
>
> I build a table using fts5,like this,
> CREATE VIRTUAL TABLE tbl_tha using fts5( key1, key2,TOKENIZE="thai");
>
>
> and
Hi all,
I've a few hundreds sqlite3 database files, all almost equals except
for some constraint that has changed during time.
As I know, there is no way to alter constraint (e.g., unique indexes),
and therefore I have to migrate data to a new schema version.
That is possible because data will fit
On Wed, Mar 23, 2016 at 10:50 AM, Luca Ferrari
wrote:
> ...The problem is that .dump provides data and schema, while I'd like to
> have data only.
> Other commands like .clone and .backup works pretty much the same, as
> far as I understand.
>
> This leads me to either use awk/sed to manipulate
Hello,
On 2016-03-23 07:32, Dan Kennedy wrote:
> On 03/23/2016 10:48 AM, ? wrote:
>> I build a table using fts5,like this,
>> CREATE VIRTUAL TABLE tbl_tha using fts5( key1, key2,TOKENIZE="thai");
>>
>> and then insert a record:
>> insert into tbl_tha values('??','??');
>> [...]
>>
Do you mean something like this, perchance? This sets .mode insert
then does a select ..., which outputs the selected data in the form of INSERT
statements into a table called . The .mode list just allows other
commands to be added to the file ...
.output aesodata.sql
.mode list
select
On Wed, Mar 23, 2016 at 1:02 PM, Keith Medcalf wrote:
>
> Do you mean something like this, perchance? This sets .mode insert
> then does a select ..., which outputs the selected data in the
> form of INSERT statements into a table called . The .mode list
> just allows other commands to be
Hello !
I had this problem before and asked to add this option to sqlite but somehow
it was not added so now I'm submitting here a patch that adds this
functionality to shell.c updated to today repository.
Please consider add this to sqlite !
Cheers !
?
---
Hey,
SQLite has a brilliant facility for creating custom collations for columns with
character affinity. And it won't stop you from creating a custom collation for
a column with numeric affinity, but your comparison function will never be
called, it seems.
I wonder if you would ever consider
Hi MM,
Sorry for the late replay - I usually manage to check the list only once
a day :-(.
On 2016-03-22 16:05, MM wrote:
...
>> If, by chance, you are on something Fedora based, I could give you some
>> hints how to help our lead maintainer - Jan Stanek with the package
>> enhancement myself.
Hello !
The sqlite rbu extension concept is interesting but it's missing the
generation of the diff files on the fly, we need something like
sqlite3_trace, sqlite3_update_hook or better yet a pragma:
PRAGMA generate_rbu=ON;
And with that all insert/update/delete operation would generate
On 23 Mar 2016, at 6:45pm, Domingo Alvarez Duarte wrote:
> The sqlite rbu extension concept is interesting but it's missing the
> generation of the diff files on the fly, we need something like
> sqlite3_trace, sqlite3_update_hook or better yet a pragma
sqlite_trace() and sqlite_profile()
Hello !
Thanks for reply !
It seems that I didn't explained myself properly because your answer doesn't
seem to address the problem !
Cheers !
> Wed Mar 23 2016 07:48:47 PM CET from "Simon Slavin"
> Subject: Re: [sqlite] SQLite RBU the missing piece !
>
> On 23 Mar 2016, at 6:45pm,
> For obvious security reasons all allocations from the Operating System are
> pre-initialized to 0x00.
Time to bash Windows, but according to the docs for HeapAlloc, memory is not
automatically initialized to 0
https://msdn.microsoft.com/en-us/library/windows/desktop/aa366597(v=vs.85).aspx
15 matches
Mail list logo