Re: [sqlite] How to customize "Bytes of unused 'reserved' spaceat the end of each page" ?

sqlite3_test_control() is an interface for testing. Is it safe to use it in released product? 原始邮件 发件人:Clemens ladischclem...@ladisch.de 收件人:sqlite-userssqlite-us...@mailinglists.sqlite.org 发送时间:2016年8月16日(周二) 18:09 主题:Re: [sqlite] How to customize "Bytes of unused 'reserved' spaceat the end of

Re: [sqlite] page_size on ATTACH-ed databases

On Tue, Aug 16, 2016 at 12:24 PM, Ward WIllats wrote: > Good thought. But no. In fact, I should have included the line where I > deleted it before taking the trace below. > > ~# rm /tmp/RareData.db > ~# /usr/local/bin/sqlite3 /opt/foundation/core_db.db > SQLite version

Re: [sqlite] page_size on ATTACH-ed databases

Good thought. But no. In fact, I should have included the line where I deleted it before taking the trace below. ~# rm /tmp/RareData.db ~# /usr/local/bin/sqlite3 /opt/foundation/core_db.db SQLite version 3.10.1 2016-01-13 21:41:56 > On Aug 16, 2016, at 11:17 AM, Scott Hess

Re: [sqlite] page_size on ATTACH-ed databases

Is there any possibility that the attached db already existed before you ran this? Because once a db exists (contains pages) the page size is fixed until you run vacuum. On Tue, Aug 16, 2016 at 10:53 AM, Ward WIllats wrote: > >>> On Aug 12, 2016, at 11:44 PM, Dan

Re: [sqlite] page_size on ATTACH-ed databases

>> On Aug 12, 2016, at 11:44 PM, Dan Kennedy wrote: >> >> On 08/13/2016 01:14 AM, Ward WIllats wrote: >> >> Can't reproduce this problem here. Are you able to reproduce it with the >> shell tool? >> > > > Yes, if I use the shell on our embedded system

Re: [sqlite] lemon parser bug, %destructors directive not appended into source code

On 8/16/16, xiaobing wrote: > In lemon.c:ReportTable() , when " Combine duplicate destructors into a > single case ", sp2->destructor is set to 0, but later it is used in > tranlate_code to generate destructor. > so if you have grammar like this: > %destructor expr_a {

[sqlite] lemon parser bug, %destructors directive not appended into source code

In lemon.c:ReportTable() , when " Combine duplicate destructors into a single case ", sp2->destructor is set to 0, but later it is used in tranlate_code to generate destructor. so if you have grammar like this: %destructor expr_a { expr_free($$); } %destructor expr_b { expr_free($$); } //

[sqlite] lemon parser bug, %destructors directive not appended into source code

In lemon.c:ReportTable() , when " Combine duplicate destructors into a single case ", sp2->destructor is set to 0, but later it is used in tranlate_code to generate destructor. so if you have grammar like this: %destructor expr_a { expr_free($$); } %destructor expr_b { expr_free($$); } //

Re: [sqlite] performance issue, v.3.10 compared to v.3.14 (inner joins)

On 8/16/16, Raja Kajiev wrote: > > *The output of .fullschema command:* > sqlite> .fullschema -indent > CREATE TABLE 'CLIPPED_UPDATE'( > CREATE TABLE 'DATASET'( > CREATE TABLE 'EXSET'( > CREATE TABLE 'EXSET_DATASET'( > /* No STAT tables available */ No indexes. No

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On Tue, Aug 16, 2016 at 2:29 PM, Simon Slavin wrote: > VACUUM destroys tables (and indexes) and makes new ones, so it frees pages > and allocates new ones. The content of the 'unused' bytes in the > newly-allocated pages would not have anything to do with the content of

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On 16 Aug 2016, at 1:46pm, Dominique Devienne wrote: > On Tue, Aug 16, 2016 at 2:29 PM, Simon Slavin wrote: > >> VACUUM destroys tables (and indexes) and makes new ones, so it frees pages >> and allocates new ones. The content of the 'unused' bytes

Re: [sqlite] UNIQUE Constraint failure better diagnostics

+1 on my part On Sun, Aug 14, 2016 at 9:59 AM, Василий Кудрявцев wrote: > Hi! > > > > I would like to propose an enhancement to SQLite diagnostics in case of > unique constraint failure. > > Currently the message does not contain the name of constraint in question, > only

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On Tue, Aug 16, 2016 at 2:29 PM, Simon Slavin wrote: > > If you're to use some of these bytes for your own values you will > presumably be modifying the pager module of SQLite, as mentioned in the > "Page Cache" section of > The pager is

[sqlite] UNIQUE Constraint failure better diagnostics

Hi! I would like to propose an enhancement to SQLite diagnostics in case of unique constraint failure. Currently the message does not contain the name of constraint in question, only columns. For example: sqlite> CREATE TABLE c_test (c0 INTEGER, c1 INTEGER, c2 INTEGER, CONSTRAINT U_X1

[sqlite] UNIQUE Constraint failure better diagnostics

Hi! I would like to propose an enhancement to SQLite diagnostics in case of unique constraint failure. Currently the message does not contain the name of constraint in question, only columns. For example: sqlite> CREATE TABLE c_test (c0 INTEGER, c1 INTEGER, c2 INTEGER, CONSTRAINT U_X1

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On 16 Aug 2016, at 12:21pm, Dominique Devienne wrote: > What are the guarantees, if any, SQLite makes about preserving what's in > these reserved bytes, > for example during vacuuming, or any operation that moves pages around? > > And if these reserved bytes are not

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

On Tue, Aug 16, 2016 at 12:09 PM, Clemens Ladisch wrote: > sanhua.zh wrote: > > It describles the"Bytes of unused‘reserved' space at the end of each > page”. I think it’s the exact thing what I need. > > But I have no idea how to use it. It seems that there is no interface to

Re: [sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

sanhua.zh wrote: > It describles the"Bytes of unused‘reserved' space at the end of each page”. I > think it’s the exact thing what I need. > But I have no idea how to use it. It seems that there is no interface to do > this. sqlite3_test_control(), or a hex editor:

Re: [sqlite] performance issue, v.3.10 compared to v.3.14 (inner joins)

I can send whatever required else if the following bits are not enough. *The output of .fullschema command:* sqlite> .fullschema -indent CREATE TABLE 'CLIPPED_UPDATE'( 'name' TEXT, 'edition' INTEGER NOT NULL, 'coverage_id' INTEGER NOT NULL, 'update_no' INTEGER NOT NULL, 'data' BLOB

[sqlite] How to customize "Bytes of unused 'reserved' space at the end of each page" ?

Now I want to add my customize data for each page. And I find thatIt describles the"Bytes of unused‘reserved' space at the end of each page”. I think it’s the exact thing what I need. But I have no idea how to use it. It seems that there is no interface to do this. Can any one tell me about the

Re: [sqlite] group_replace

On Mon, Aug 15, 2016 at 10:20 PM, E.Pasma wrote: > 11 aug 2016, Dominique Devienne: > >> From https://www.sqlite.org/c3ref/value_blob.html: >> Please pay particular attention to the fact that the pointer returned from >> [...] sqlite3_value_text(), >> [...] can be