Re: [sqlite] [BugReport]Data changes cannot actually flush to disk

1024 20480 0 > SYNC154 > CLOSE -1 > UNLOCK 154 1 was 4(4,1) pid=2289 (unix) > UNLOCK 154 0 was 1(1,1) pid=2289 (unix) > > > > Cordially yours > > LiuXiang > > _______ > sqlite-use

Re: [sqlite] why does gperftools shows sqlite3_memory_used as using the largest amount of memory

gt; ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Putting the journal/WAL on a separate filesystem

r a mode that enabled putting the > journal in a separate directory? > > Thanks, > > - Peter > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Rich

Re: [sqlite] libsqlfs - a file system in a SQLite database

; > At first glance, libsqlfs seems more "complete". But this idea has come up before. See, for example, http://www.sqlite.org/sqlar/ -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Comiple time warning: possible array index out of bound within assert() in an error path

-DSQLITE_DEBUG option is great for testing and debugging work, but for a release build, or for any build where performance is important, it should be omitted. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sq

Re: [sqlite] UTF support

8e b5 20 e0 8e ad e0 8e bd e0 8e b1 20 e0 > 8e bc e0 8e b9 e0 8e ba e0 8f 81 e0 8f 8c 20 à..àŽµ àŽ.àŽ.àŽ± > àŽ.àŽ.àŽºà..à.Œ > 0x0298458D e0 8e b1 e0 8f 81 e0 8e bd e0 8e af 27 2c 30 29 00 fe > ca ef be fe ca ef be cd fd fd fd fd ab ab ab > àŽ±à..àŽ.àŽ¯',0).þÊï.þÊï.Íýýýý«««

Re: [sqlite] UTF support

4-3085a9903449','Μαίρη είχε ένα μικρό αρνί',0); SELECT * FROM option4_values; I suggest that the problem is in your programming language, or in the wrapper that links your programming language to SQLite, not in SQLite itself. Can you tell us what programming language and what operating system you

Re: [sqlite] UTF support

On Tue, Oct 7, 2014 at 8:50 AM, J Decker <d3c...@gmail.com> wrote: > On Tue, Oct 7, 2014 at 5:02 AM, Richard Hipp <d...@sqlite.org> wrote: > > > On Tue, Oct 7, 2014 at 12:06 AM, J Decker <d3c...@gmail.com> wrote: > > > > > I saw a few things go by a

Re: [sqlite] I need to use an earlier version of SQLite

qlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Freelist count after Vacuum

On Thu, Oct 9, 2014 at 12:25 PM, Dave Wellman <dwell...@ward-analytics.com> wrote: > Hi, > > Is it a reasonable assumption that immediately following a VACUUM command > the freelist_count will always be 0, or maybe 1? > I think it should always be 0. -- D. Richard

Re: [sqlite] decoding a bitmask

UNION ALL SELECT 0x04, 'system' UNION ALL SELECT 0x08, 'directory' UNION ALL SELECT 0x10, 'archive') WHERE (x)!=0) FROM all_bit_patterns; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Make a database read-only?

; Change the 18th byte of the file from 1 or 2 to 99. Anyone who downloads the file can always change that byte back to its original value using a binary editor and then write the database. But you have at least then made the problem more difficult for them. -- D. Richard Hi

Re: [sqlite] Performance issue when copying data from one sqlite database to another

on the embedded system, the > copying of data is extremely slow, even though the CPU load is very > moderate. > That sounds like a file-system problem to me. What is your embedded OS? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] UPDATE Help

OM dailyfactors WHERE dailydelete.data > = dailyfactors.Date) > > WHERE EXISTS (select * from dailyfactors WHERE dailydelete.data = > dailyfactors.Date); > > > I get the following error: > Error: near "SET": syntax error > On the syntax diagram (http://www.sqlite.org/lang_updat

Re: [sqlite] Please fix the EBCDIC support

On Thu, Oct 16, 2014 at 9:53 AM, John McKown <john.archie.mck...@gmail.com> wrote: > On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp <d...@sqlite.org> wrote: > > Please try the latest version of SQLite on trunk to see if that works > > better. Specifically, apply th

Re: [sqlite] WHERE expression with operators from text functions?

Tom > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting an unexpected result

y been reformatted for readability. That should perhaps be the first rule of trouble-shooting a query: First reformat the SQL so that the spacing and indentation help to elucidate the intent of the query, not obscure it. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] [sqlite-announce] SQLite version 3.8.7

ou really mean to test if > azArg (of type char**) was greater than 0 rather than not equal to 0? It > throws a warning on Solaris 9 with the SUNPro compiler. > > > On Friday, October 17, 2014 10:00 AM, D. Richard Hipp <d...@hwaci.com> > wrote: > > > > > > >

Re: [sqlite] Any tips on reducing memory requirements for small MCU?

so want to disable LOOKASIDE memory, and set you default pages size to 512 bytes. What does your schema look like? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Full outer joins

we did put them in. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

our are observing. (4) If you are able to send us your complete database file, perhaps by private email, that would be even more helpful, but is not absolutely necessary. > > -- > Tomislav Ljubej > > ___ > sqlite-users mailing list > sqli

Re: [sqlite] [regression] SQLite 3.8.7 causes Evolution to crash

7d26ec error 14 > > Several people have reproduced this [1]. > The problem *might* be an incomplete VFS implementation in Evolution. I put a more detailed comment on the Bugzilla ticket. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Regression with sqlite 3.8.7

igdoc' with 'LEFT JOIN Rigdoc' it takes 0.063 > seconds > > the table Rigdoc have column RdoIdoc as PRIMARY KEY > > > Best regards > Luigi. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite

Re: [sqlite] Any tips on reducing memory requirements for small MCU?

On Thu, Oct 23, 2014 at 2:25 PM, Dennis Field <f...@xibase.com> wrote: > > > Are there any omit/other preprocessor defines that are particularly helpful > for reducing memory usage? > > SQLITE_SMALL_STACK - but that will require regenerating the amalgamation.

Re: [sqlite] Performance regression in Banshee with sqlite 3.8.7 on Arch Linux

occur automatically again for SQLite 3.8.8, at least in your case where it does appear to be valid. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regression with sqlite 3.8.7

On Fri, Oct 24, 2014 at 7:45 AM, Luigi Iemma <iemmalu...@gmail.com> wrote: > Hi, > > if I do an ANALYZE then works, bat because it changes if I use left instead > of inner > > this is the result of .fullschema > Can you send us the ".fullschema" *after* you h

Re: [sqlite] unicode case insensitive

uch is the price of unicode. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [regression] SQLite 3.8.7 causes Evolution to crash

on’t you use semantic > versioning for SQLite? > > The 4th digit increments for bug-fix releases. For example: 3.8.6 to 3.8.6.1. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/c

Re: [sqlite] Performing a SELECT on an enormous database...

use of variable-width encodings, since a change to any field effects the location of all subsequent fields.) So if you have a row with both a BOOLEAN and a 1MB BLOB, you have to write 1MB in order to change the value of the BOOLEAN. -- D. Richard

Re: [sqlite] Performing a SELECT on an enormous database...

On Sat, Oct 25, 2014 at 9:14 AM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > Ahh.. Thanks Richard. So if you were to have blobs live at the front of > the row, it'll have to read through that blob to get that byte in the next > field, correct? > > Correct.

Re: [sqlite] Regression with sqlite 3.8.7

TdoTipo=60 constraint: SELECT TdoIdoc,RdoCart,RdoQuat FROM Tesdoc, Rigdoc WHERE RdoIdoc BETWEEN TdoIdoc*1000 AND TdoIdoc*1000+999 AND likelihood(TdoTipo=60, 0.01) <<< HERE AND TdoAnno BETWEEN 2014 AND 2014 GROUP BY TdoIdoc; -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Inserting a row with all defaults set in table

ketID] INTEGER DEFAULT 0, > [Resolved] BOOL DEFAULT 0); > > > The question is, how would I insert a blank row and rely on the defaults > I've got in the schema? > INSERT INTO tEvents DEFAULT VALUES; -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] unique with icu

ease read https://www.sqlite.org/src/artifact/d9fbbad0c2f and especially the part about ICU collating sequences. "NOCASE" is still the standard ASCII-only collating sequence, even if you enable ICU. -- D. Richard Hipp d...@sqlite.org ___ sqlite-us

Re: [sqlite] problem trigger

BETWEEN. > It does. See https://www.sqlite.org/lang_expr.html However Pablo got the syntax wrong. It should be a NOT BETWEEN b AND c But the statement giving problems has extra parentheses: a NOT BETWEEN (b and c) -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sqlite3.c in a library - api rename

3.c >wards_db.c sed 's/sqlite3/wards_db/g' sqlite3.h >wards_db.h -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] inserted row isn't deleted after rollback?

t;) > VALUES ( 'page_2', 4, 1 ); > ROLLBACK; > SELECT * FROM "order_item_file"; > > I expected, that it should delete the inserted row after rollback, but > it doesn't . What is the reason for that? > The row exists before the sta

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

abase engines (that I know about) will either report the query above as an error, because column b is not in the GROUP BY clause and is not inside an aggregate function, or will return b from an arbitrary row, not necessarily the row on which a is maximal. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Clarification on sqlite handling of mixed aggregate and non-aggregate columns

row you'll get. > > Staffan > > > On Wed, Oct 29, 2014 at 7:43 PM, Richard Hipp <d...@sqlite.org> wrote: > > > On Wed, Oct 29, 2014 at 2:38 PM, Baruch Burstein <bmburst...@gmail.com> > > wrote: > > > > > Hi, > > > > > > If

Re: [sqlite] Index without backing table

mmediately notify the sender > by return e-mail message and delete all copies of the original > communication. Thank you for your cooperation. > > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > --

Re: [sqlite] Index without backing table

erhaps using WITHOUT ROWID. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Index without backing table

, without making any changes to your internal queries. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

qlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fixing time-warp

On Mon, Nov 3, 2014 at 8:46 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Ok, I now see that you intentionally left 2 time-warps in place. It would > be helpful to make that as a note for exporting to git. > Why would I want to export the SQLite history to Git? -- D. Richard Hipp

Re: [sqlite] fixing time-warp

o, it’s a persuasion challenge. > > I’ll propose it in two parts: > > 1. Why is it a good idea for you, E. Timothy Uy, to dump the SQLite code > repo into a Git repo? What does this achieve, that keeping it in Fossil > does not? > > 2. Why is it a good idea for our BDFL

Re: [sqlite] sqlite-3.8.7.1: create table as select with join creates corrupted results

On Wed, Nov 5, 2014 at 4:03 AM, Nissl Reinhard <reinhard.ni...@fee.de> wrote: > > I can provide the 17 kB bug.db if required. > Please do provide the database. Private email to me will be fine. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] LEFT joins affect query plan for semantically equal queries

Maybe you'll fix it in later sqlite versions? :) > > -- > With best regards, > Vitaliy Filippov > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Ri

Re: [sqlite] LEFT joins affect query plan for semantically equal queries

clause requires some column in the right-hand table of a LEFT JOIN to be non-NULL and then promote that join to a normal INNER JOIN. That seems like a reasonable enhancement request which we will take under advisement. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] sqlite-3.8.7.1: create table as select with join creates corrupted results

qlite.org/src/tktview/094d39a4c95ee4abbc417f04214617675ba15c63 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite-3.8.7.1: create table as select with join creates corrupted results

On Wed, Nov 5, 2014 at 9:55 AM, Richard Hipp <d...@sqlite.org> wrote: > > > On Wed, Nov 5, 2014 at 4:03 AM, Nissl Reinhard <reinhard.ni...@fee.de> > wrote: > >> Hi, >> >> I'm just upgrading from 3.8.5 to 3.8.7.1 and experience the follow

Re: [sqlite] Does using e.g. LTRIM function remove collation?

to see the resulting/deduced collation of a SELECT > statement? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] AUTOINCREMENT BIGINT

e details at https://www.sqlite.org/autoinc.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite - 64bit support

On Fri, Nov 7, 2014 at 5:44 AM, Vadiraj V <vvadi...@kodiaknetworks.com> wrote: > I would like to know if sqlite supports 64-bit - if so, from which version > it supports and any supporting documentation exists. Thanks. > All versions of SQLite going back to 3.0.0 support 64-bit.

Re: [sqlite] SQLite where clause tree

|-- ADD | |-- 3 | '-- MUL | |-- 5 | '-- 4 '-- 3 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite where clause tree

On Mon, Nov 10, 2014 at 12:28 PM, Ward Willats <sqlite-us...@wardco.com> wrote: > > > On Nov 10, 2014, at 3:11 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > If you recompile the SQLite command-line shell (sqlite3.exe) using the > > -DSQLITE_ENABLE

Re: [sqlite] Triggers and CTE's

and that is not something we want to do right now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Triggers and CTE's

On Tue, Nov 11, 2014 at 9:01 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 11/11/2014 8:37 PM, Richard Hipp wrote: > >> On Tue, Nov 11, 2014 at 8:22 PM, Igor Tandetnik <i...@tandetnik.org> >> wrote: >> >> On 11/11/2014 6:15 PM, Ben Newber

Re: [sqlite] sqlite bug report

s required, please request a hard-copy > version. This message is provided for information purposes and should not > be construed as a solicitation or offer to buy or sell any securities or > related financial instruments in any jurisdiction. > _____

Re: [sqlite] sqlite bug report

be released? > Next week sometime. Why not just pull the latest code from the source tree? > > > On Thu, Nov 13, 2014 at 1:12 PM, Richard Hipp <d...@sqlite.org> wrote: > > > This is https://www.sqlite.org/src/info/094d39a4c95ee4 which has been > > fixed > >

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

the correct output is in the version 3.8.2 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

t; > on 3.8.2 the error did not occur on Ubuntu, but occured on > Darwin Kernel Version 13.0.0 Thu Sep 19 22:22:27 PDT 2013 x86_64 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/lis

Re: [sqlite] Why is a b-tree sort required for this query?

F ORDER BY" > > Is the temp b-tree redundant here? > I don't think so. What query plan are you thinking might be able to omit the sorting pass in this query? > > $ sqlite3 --version > 3.8.5 2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212 > > ___ >

Re: [sqlite] Insert Hindi Language

lite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA reverse_unordered_selects and CTEs

On Fri, Nov 21, 2014 at 5:58 AM, snowbiwan <snowbiwanjaak...@gmail.com> wrote: > > If this is not a bug, then this behaviour should be mentioned on either the > Pragma, or WITH Clause documentation pages. > Not a bug. https://www.sqlite.org/docsrc/info/3d72482e471 --

Re: [sqlite] Read overflow in CREATE VIRTUAL TABLE query (formerly Corrupting pointers to the lookaside smallacator)

t are not backwards compatible, so it had to have a different name. The ifcapable command in the test harness only understands "fts3". So I believe Dan's test case is correct as written. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Recursive SQL query does not use expected index

PLAN WITH RECURSIVE > tn(o,level,roottag,id,path) AS ( > SELECT o,0,tag,id,printf('%04p',tag&0xff) AS path FROM t1 WHERE > unlikely(p_o=0) AND (tag=0x02 OR tag=0x03) > UNION > SELECT t1.o,tn.level+1,tn.roottag,tn.id > ,printf('%s.%04p',tn.path,t1.tag&0

Re: [sqlite] Much unused space in sqlite3 database when using blobs

of unused space in overflow pages. > As far as I understand it means that there are > some blobs that do not fit into primary pages and these blobs are stored in > overflow pages. But with increasing page size the unused space on overflow > pages are also growth. Even when the page size is greater then max blob > size (page_size = 65536, max blob = 49870) there are 72.5% of unused bytes > on overflow pages. Why? > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report: USBAN failure

mory condition. The correct work-around (it isn't really a bug fix) is to test pParse->nzVar in addition to p->azVar. See https://www.sqlite.org/src/info/0d04f380e1bd17104b3cf76b64d0cfc79a726606 for the change. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report: USBAN failure

On Tue, Dec 2, 2014 at 8:53 AM, Dominique Devienne <ddevie...@gmail.com> wrote: > On Tue, Dec 2, 2014 at 2:47 PM, Richard Hipp <d...@sqlite.org> wrote: > > > On Mon, Dec 1, 2014 at 5:46 PM, Hadley Wickham <h.wick...@gmail.com> > > wrote: > > > [...]

Re: [sqlite] appending the output of a query

__ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "database is locked" for SQLITE_BUSY

d be really helpful if > something like this could be incorporated in an appropriate place. > > https://www.sqlite.org/rescode.html#busy -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trying to store a file as a blob. caught on syntax...

using a recent command-line shell, then you can add that function as a loadable extension (https://www.sqlite.org/loadext.html). The source code is at https://www.sqlite.org/src/artifact/d4171c815d6543a9edef8308aab2951413cd8d0f -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] sqlite bugreport : unique index causes valid updates to fail

ot just at the end of the transaction. Hence, uniqueness might fail, depending on the order in which the individual rows are updated. > > Thank you for considering this issue. > > Cheers, > Gwendal Roué > > _______ >

Re: [sqlite] [SQLite]Ba​sic query

30892 145495 1098859 sqlite3-2.c 32729 144742 1091870 sqlite3-3.c 32481 150359 1198841 sqlite3-4.c 23259 100070 768733 sqlite3-5.c 32 2371518 sqlite3-all.c 151707 706855 5388171 total Include all these files in your project, but compile against just sqlite3-all.c. --

Re: [sqlite] Table names length and content

tic characters. ie. > <>!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name. > > Put the table name in double-quotes. If the table name contains a double-quote mark (ascii 0x22) then double it. The name of the table cannot start with "sqlite" but otherwise,

Re: [sqlite] Table names length and content

gt; > SQLite supports all those, as well as zero length table names, column > types and names. > But just because SQLite supports all of that does not mean that you *should* use it. I'm worried about what you are contemplating, Jose. I think

Re: [sqlite] Bugreport - slowdown in sqlite after the ANALYZE statement

v2 > > iEYEARECAAYFAlSG16wACgkQXbaA6cD3QD38pwCcDiofiIh5jo+E8P5B/DhxLzGF > fGsAn1RJ8SjjEANSjUm4I1j+zReQfj0G > =2QtO > -END PGP SIGNATURE- > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi

Re: [sqlite] sqlar

tories, and I never thought to track > that, and I'm sure it's probably platform defined anyway. > > So does the latest commit fix the problem? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sq

Re: [sqlite] How to speed up database open

And if I skip all the pragmas, > initialization time will be delayed until the first query, so I guess > there is nothing specific about these pragmas. > > Thanks, > Paul > ___ > sqlite-users mailing list > sqlite-users@sqlite.

Re: [sqlite] How to speed up database open

mpiling without SQLITE_ENABLE_STAT4. You will still probably get good query plans, but the startup time should be reduced. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Select count(*)

On Thu, Dec 11, 2014 at 11:27 AM, Dominique Devienne <ddevie...@gmail.com> wrote: > > So why couldn't sqlite using the PK index to reduce the IO when doing a > "select count(*) from t_with_non_int_pk", to avoid scanning the table? > It does. -- D.

Re: [sqlite] Feature Request - RowCount

ut I am not versed well enough in the > SQLite internals to attempt a patch. Also, the solution needn't fall upon > my suggestion, any other suitable means of making row count > fast-determinable would be welcome. > > > Thank you kindly, > Ryan > > >

Re: [sqlite] Feature Request - RowCount

No. The fastest is to do "count(*)". -- D. Richard Hipp Sent from phone - Excuse brevity On Dec 13, 2014 11:13 AM, "Jim Callahan" <jim.callahan.orla...@gmail.com> wrote: > So, if I understand the discussion the fastest way to get a count from the > command

Re: [sqlite] Abnormal memory usage when removing rows within nested transaction from a table, referenced by another table via FK,

sqlite3_close(db); > return 1; > } > > // Reset statement. > sqlite3_reset(statement); > sqlite3_clear_bindings(statement); > } > > sqlite3_finalize(statement); > > // Roll

Re: [sqlite] FTS4 Problem

any suggestion for what might suddenly cause this > behavior after working for moths and months? > > Thanks, and happy holidays! > > > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi

Re: [sqlite] Client/Server Best Practices

ck Kelly > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/Client-Server-Best-Practices-tp79728.html > Sent from the SQLite mailing list archive at Nabble.com. > _______

Re: [sqlite] Bus error with Evolution 3.12.9 and SQLite 3.8.7.4

Lite), that might be helpful. Note that I'm not blaming camel-db.c but it is in a suspicion-arousing position in the stack trace and I'd like to look closer. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bus error with Evolution 3.12.9 and SQLite 3.8.7.4

and some from > GMail. OK, other than the updated SQLite3 library I run on a clean > Jessie. > Our latest theory is that the problem only arises when /var/tmp runs out of space. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing lis

Re: [sqlite] sqlite login password

f SQLite) not sqlite3. (2) SQLite has *never* given a prompt "Pls input your password". That message is coming from third-party software. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org &g

Re: [sqlite] sqlite3_bind_text and strings that look like numbers

imer. If you are not the intended > recipient, please delete this message. > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite problem possible bug

e us more details about how you are invoking SQLite. The problem might be in the interface to your programming language, not in SQLite itself. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation bug: it's ESCAPE not EXCEPT that limit LIKE optimisation

; Thanks for bring that to my attention. Now fixed. See https://www.sqlite.org/docsrc/info/1e0e7c930074 for the check-in. This change will appear in the next release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Index rownum

in 2003) I considered adding the capability to compute the "rownum" in O(logN) time. That would have made things like "count(*)" much faster too. But doing this also increases insertion and deletion cost, so I decided against doing it. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Time Zone Conversions

_____ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] using a hex integer as input to DateTime

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a couple of crashing bugs from a fuzzer

0x0) > at sqlite3.c:81167 > #5 0x00752a7c in spanBinaryExpr (pLeft=, > pLeft=, pRight=, > pRight=, op=, pParse= out>, pOut=) at sqlite3.c:120313 > #6 yy_reduce (yyruleno=, yypParser=) at > sqlite3.c:57482 > #7 sqlite3Parser (yyp=0xa9f368, yymajor=-13916, yyminor=...,

[sqlite] SQLite 3.8.8 expected in January

snapshots and precompiled Windows DLLs can be found at https://www.sqlite.org/download.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.8.8 expected in January

On 1/9/15, Dominique Devienne <ddevie...@gmail.com> wrote: > On Fri, Jan 9, 2015 at 6:23 PM, Richard Hipp <d...@sqlite.org> wrote: > >> We hope to release SQLite version 3.8.8 sometime later this month >> (January). A change-log is available at >> htt

Re: [sqlite] Segfault with Evolution and patched SQLite 3.8.7.4 (was: Bus error with Evolution 3.12.9 and SQLite 3.8.7.4)

b2.0-EvFudu/glib2.0-2.42.1/./glib/gthreadpool.c:307 > task = 0x88843368 > #30 0xb52d73da in g_thread_proxy (data=0x89118ef0) at > /build/glib2.0-EvFudu/glib2.0-2.42.1/./glib/gthread.c:764 > No locals. > #31 0xb7caeefb in start_thread (arg=0x972ffb40

Re: [sqlite] SQLite 3.8.8 expected in January

ming this might be a compile-time omission? > Yes, it was a compile-time omission. I have uploaded a new DLL that includes the loadable extension interface. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] aggregate functions with DISTINCT

REPLACE to get rid of the comma but only to realise that the data being > concatenated also might contain one or more commas. > SELECT group_concat(x,'+') FROM (SELECT DISTINCT a+b AS x FROM tab ORDER BY 1); -- D. Richard Hipp d...@sqlite.org ___ s

  1   2   3   4   5   6   7   8   9   10   >