[sqlite] Version 3.19.3 containing an important bug fix

any database inconsistencies that might have been introduced by this bug. If you encounter any problems with this release, please send email to sqlite-users@mailinglists.sqlite.org or directly to me. Thanks. -- D. Richard Hipp d...@sqlite.org

[sqlite] SQLite version 3.7.16.2

email to the SQLite users mailing list, or directly to me, if you encounter any problems with this release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] SQLite Version 3.7.16.1

for details. All users of SQLite versions 3.7.15 and 3.7.16 are encouraged to upgrade. As always, please let me know if you encounter any problems with this or any other release of SQLite. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

[sqlite] SQLite version 3.7.16

to the SQLite Users mailing list (sqlite-users@sqlite.org) or directly to me if you encounter any problems with this new release. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

[sqlite] SQLite Version 3.7.15.1

the unusual SQL construct necessary to tickle this bug (and most applications don't) then you are perfectly safe staying with whatever prior version of SQLite you are currently using. Nevertheless, upgrading to 3.7.15.1 is recommended. D. Richard Hipp d...@hwaci.com

[sqlite] SQLite version 3.7.14.1

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

[sqlite] SQLite version 3.7.12

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

[sqlite] SQLite version 3.7.9

versions is recommended. Additional information about this release can be found at: http://www.sqlite.org/releaselog/3_7_9.html http://www.sqlite.org/news.html As always, please let me know if you encounter any difficulty with this release. D. Richard Hipp d...@sqlite.org

[sqlite] SQLite version 3.7.7 released

mailing list (sqlite-users@sqlite.org) if you encounter any problems with this release. -- D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite version 3.7.6.3

list (sqlite-users@sqlite.org) or directly to me if you encounter any problems. Thanks. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.7.6

On Apr 12, 2011, at 8:49 AM, D. Richard Hipp wrote: > SQLite version 3.7.6 is not available from the website: > http://www.sqlite.org/ The "not" in the sentence above should be "now", of course. Sorry for the typo. > > Version 3.7.6 is a regularly schedule

[sqlite] SQLite version 3.7.6

can be seen at http://www.sqlite.org/releaselog/3_7_6.html Please send email to the sqlite-users@sqlite.org mailing list, or directly to me, if you encounter any problems. Thanks. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list

[sqlite] SQLite version 3.7.0.1

of the possibility of database corruption, upgrading to version 3.7.0.1 is highly recommended. If you encounter any problems, please report them directly to me or to the sqlite-users@sqlite.org mailing list. D. Richard Hipp d...@sqlite.org ___ sqlite

[sqlite] SQLite version 3.7.0

me know at once. Thanks! D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] New 3.7.0 snapshot - release estimated for July 22

will slip the release again if necessary. Your beta testing is *very* important. Thanks! D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Database corruption on Linux ext3

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

[sqlite] Please beta-test SQLite 3.7.0

-testing SQLite 3.7.0 in your application! Report any problems found on this mailing list. You can download daily snapshots from http://www.sqlite.org/draft/download.html and view updated documentation at http://www.sqlite.org/draft/index.html Thanks. D. Richard Hipp d...@hwaci.com

[sqlite] Development snapshots for SQLite 3.7.0 available

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

[sqlite] Fwd: CRITICAL bug in sqlite3VdbeExec() code

quot; I have checked under M$ debugger (not coverable errors in my PHP/PDO-Sqlite script with parameters binding), but possible other cases in massive switch statement, I think ... greetings from Poland, JureKL. --- End forwarded message - D. Richard Hipp d...@hwaci.com ___

[sqlite] Oracle joins the SQLite Consortium

, code generator, and virtual machine from SQLite in its Berkeley DB product. Additional information about Berkeley DB's SQL API is available at http://www.oracle.com/technology/products/berkeley-db/sql.html D. Richard Hipp d...@hwaci.com

Re: [sqlite] [sqlite-announce] HELP : sqlite execute low speed in ARM9+Linux embadded system.

er,tstr); > } > strcat(DataBuffer,"\n"); > > gettimeofday(,NULL); > timeuse=100*(tpend.tv_sec-tpstart.tv_sec)+ > tpend.tv_usec-tpstart.tv_usec; > timeuse/=100; > printf("SQLCallBack Used Time：%f\n",timeuse); // print value : > 0.000280s > > return 0; > } > > //---

[sqlite] SQLite turns 10 years old

birthdays! Thanks, everybody, for helping to make SQLite the most widely deployed SQL database engine in the world. And Happy 10th Birthday to SQLite! D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] How to compile RTREE using eclipse on windows

ndow’s eclipse environment > with Sqlite-3.6.23.1.tar.gz file > Thank you for giving many information. Thank you. > D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposed: drop support for LinuxThreads

On May 19, 2010, at 6:35 PM, Mike Frysinger wrote: > On Wednesday 12 May 2010 11:43:13 D. Richard Hipp wrote: >> If we drop support for (the non-standard, non-compliant) LinuxThreads >> threading library and instead support only standard Posix threads >> implemented

[sqlite] Proposed: drop support for LinuxThreads

If we drop support for (the non-standard, non-compliant) LinuxThreads threading library and instead support only standard Posix threads implemented using NPTL, beginning with SQLite release 3.7.0, what disruptions might this cause? Is anybody still using LinuxThreads? D. Richard Hipp d

[sqlite] Proposed new sqlite3_open_v3() interface

breakage of older applications. Question 1: Are there any objections to this approach? Question 2: Are there other foibles that we could correct using sqlite3_open_v3? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users

Re: [sqlite] page_size

__ >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqli

Re: [sqlite] TEXT storage

string size and 5 for the string itself). A one-billion byte string requires one-billion-and- five bytes of disk (5 bytes for the string size and one billion bytes to hold the string itself.) D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing

Re: [sqlite] Question on the VdbeCursor structure changes

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

Re: [sqlite] Please help test the latest query planner changes

for the report! It is reassuring to know that the recent changes actually did some good! D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug

- > Assertions are politics; backing up assertions with evidence is > science > = > == > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Please help test the latest query planner changes

://www.sqlite.org/src/info/f538d759be Or, you can get a prebuilt amalgamation at http://www.sqlite.org/sqlite3-20100415132938.zip We are looking forward to your feedback, both positive and negative. D. Richard Hipp d...@hwaci.com ___ sqlite

Re: [sqlite] Content filtered message notification

anet4networks.com> > > > > > Hi > I hope you can help every time I start my pc I have this error > message as I am not a programmer I did not put SQL Lite on my > machine for programming. > > Thanks in advance > > Femi Omomo > Email: f...@planet4networ

Re: [sqlite] 'DatabaseError: database disk image is malformed'

Is there a > way to > recover the database? > > Alas, we had a misunderstanding w/ our web host on backup policy; he > turns out to keep multiple versions of the current files, but no > rollback... > > Thanks, > > Rutger Hofman > VU Amsterdam > http://www.rfidgua

Re: [sqlite] Android database corruption

hance to do that. However I do have a channel to the >> android db >> developers, so I will forward this onto them, and hopefully they >> can do >> something with it. >> >> Thanks again for your help. >> >> >> >> D. Richard Hipp wrot

Re: [sqlite] Is it safe to backup an in-use sqlite3 database by copying the underlying database file?

rent database. The backup API is safer. > Thanks, > Josh > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-

Re: [sqlite] Possible bug in 3.6.23?

sCRT > >>> > query="UPDATE tablename SET field=12345;") Line 1335 + 0x27 bytes >> >> >> Does this seem to be a bug? Is there other info that is needed? >> >> -- Kevin >> >> >> >> __

Re: [sqlite] sqlite 3.6.23 may cause memory overrun problem

> the new buffer. http://www.sqlite.org/src/ci/937b931a7c > > Or, this problem is occurs by the line 741, it calculate the wrong > number? > > On Fri, Apr 2, 2010 at 19:52, D. Richard Hipp <d...@hwaci.com> wrote: > > On Apr 2, 2010, at 6:15 AM, Daniel Lin wrote: > &g

Re: [sqlite] sqlite 3.6.23 may cause memory overrun problem

unction, all you have to do is run the test suite. Further discussion to sqlite-users@sqlite.org, please. > > > On Fri, Apr 2, 2010 at 11:34, D. Richard Hipp <d...@hwaci.com> wrote: > > On Apr 1, 2010, at 9:34 PM, Daniel Lin wrote: > > Hi, Richard, > > Stil

Re: [sqlite] dead link on sqlite-announce info page

evelopers have searched and searched and yet we have no idea where in the code that URL is generated. > > -- > mMerlin > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] REQUEST: Implement APDB like PRAGMA for CHS access

eceived this message in error, please advise the sender immediately > by reply e-mail and delete this message. Thank you for your > cooperation. > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.o

[sqlite] A proposed change to SQLITE_STMTSTATUS_FULLSCAN_STEP

, please let me know. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Preserving column size

vide a means to determine the number of bytes of underlying storage used for a value. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

On Mar 29, 2010, at 1:56 PM, Alexey Pechnikov wrote: > Hello! > > On Monday 29 March 2010 20:22:36 D. Richard Hipp wrote: >> SQLite version 1 used gdbm for storage. There were many problems >> with >> that approach: (1) gdbm is a hash-based system so it could not d

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

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

Re: [sqlite] SQLite over NFS

which will allow you to position the database engine on the server so that it can talk to the disk directly and without a network hop. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] sqlite bug with collating sequences?

mmand was originally created for the specific purpose of rebuilding indices when the definition of a collating function changed. That's why REINDEX will accept the name of a collating function as its argument and only rebuild those indices that use the named collating function. D. Richard Hipp d

Re: [sqlite] Will CEROD work with the new BerkleyDB implementation?

ven if you are using the SQLite front end on BDB. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Android database corruption

To amplify what Shane said, the corruption is probably just in the page cache, not in the database file itself. So if you are able to close and reopen the database connection when you run into problems, that might provide a work-around (assuming we are guessing correctly at the root

Re: [sqlite] sqlite3_open16_v2

lite3_open16() interface is considered a mistake. It is maintained for historical compatibility. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Running UPDATE on a large table uses too much RAM

atabase is stored on)? > > Thanks. > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list

Re: [sqlite] Issue "sqlite database locked"

(), , ); >int err1 = tdbhandle.sqlite3_step(stmtHandle); > >return 0; > } > > > This step int err1 = tdbhandle.sqlite3_step(stmtHandle); > in the code returns 5 (sqlite_busy) every time I run the program. > (I don't have any multi threads in my program which can lock the db. ) > > Any help on this is appreciated. > > > Regards > sudha > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Available alternatives to syntax diagrams in documentation

resentations to suite the preferences of individual readers.. And so the syntax diagrams will be all that is available for the foreseeable future. I apologize for whatever inconvenience this may cause you. D. Richard Hipp d...@hwaci.com ___ sqlite-u

Re: [sqlite] hello.. I have some question for sqlite3..

x. Then move the files sqlite3.c and sqlite3.h over to windows and compile them there together with -DSQLITE_ENABLE_RTREE. > > How can I use sqlite3 in windows eclipse environment..? > I have to use eclipse in windows. > I really thank for you it you teach me How to use sqlite's rtree in

Re: [sqlite] sqlite 3.6.23 may cause memory overrun problem

>aSortOrder = (unsigned char*) > >aColl[nField]; > memcpy(pKeyInfo->aSortOrder, aSortOrder, nField); > } > pOp->p4type = P4_KEYINFO; > D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: Sqlite User

Begin forwarded message: > From: Alexis Colon <turbines...@gmail.com> > Date: March 21, 2010 1:00:18 AM EDT > To: d...@hwaci.com > Subject: Sqlite User > > Hello. > > please help > how many user at the same time ken use sqlite > > thanks the any

Re: [sqlite] Question about binding

and sqlite3_bind_parameter_index() calls. If we've learned one thing over the history of computing it is that programmers are notoriously bad at counting parameters and that symbolic names tend to be much better at avoiding bugs. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VACUUM & journal size

e the VACUUM succeeds the resulting DB is only 50 MB. > > Any tips are appreciated. Thanks! PRAGMA journal_mode=OFF; Be warned, though, that if you session crashes or you lose power, your database will go corrupt if there is no journal. D.

Re: [sqlite] FTS3 offsets() function, sorted list?

currently sorted, but that might change in a subsequent release. > > Thanks. > > - Nasron > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user

Re: [sqlite] sqlite3 delete does not delete everything?

lumns in the database? http://www.sqlite.org/lockingv3.html#how_to_corrupt D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 delete does not delete everything?

On Mar 11, 2010, at 11:42 AM, Skand wrote: > > > D. Richard Hipp wrote: >> >> >> On Mar 11, 2010, at 11:13 AM, Skand wrote: >> >> >>> >>> sqlite> select count(*) from ip_domain_table where ttl < >>> 99 ; >>

Re: [sqlite] sqlite3 delete does not delete everything?

ot-delete-everything--tp27865654p27865654.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE

SQLite mailing list. My suggested solution is simple: Get a Mac. > > Regards > Mona > ------Original Message-- > From: D. Richard Hipp > To: Mona Alshaikh > Cc: General Discussion of SQLite Database > Subject: Re: SQLITE > Sent: Mar 11, 2010 4:39 PM > > > On M

Re: [sqlite] SQLITE

r th e problem. > > regards > > -- > Mona Ahmed Al Shaikh, MBA > > Assistant Vice President - Asset Management > D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.23

full configure and make output as an attachment. > > Your help would be appreciated. > > Mel > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hip

Re: [sqlite] SQLite version 3.6.23 - date.c

ntil recently when we were adding some tests that make use of SQLITE_OMIT_DATETIME_FUNCS. > > > Regards , > > Israel Lins Albuquerque > Developer > Polibrás Brasil Software Ltda. > > > __________

Re: [sqlite] Sqlite

nt of the original table into the new table, and (4) drop the original table. > Best regards, > Roberto Luca > -- http://www.dbschema.com D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] JAVA and sqllite.

for "java sqlite" or "jdbc sqlite" to get a list. > > Many thanks. > > //F. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] About Sqlite Virtual Table

Further more, when i debug fts3 with sql -- > 1."select * from virtual_table where a = ''1' and b ='2'" > 2."select * from virtual_table where a = ''1' or b ='2'" > i can not fetch the values of a and b using 1 but fail using 2 in > xFilter. > Can

Re: [sqlite] SQLite files on your computer

e, Firefox, Chrome, and Mcafee Antivirus, as well as countless others. One or more of these other programs is leaving the SQLite files on your computer. SQLite is not a program or application. It is not a virus. D. Richard Hipp d...@hwaci.com ___ sq

Re: [sqlite] SQLite version 3.6.23

On Mar 9, 2010, at 5:07 PM, Roger Binns wrote: > D. Richard Hipp wrote: >> SQLite version 3.6.23 is now available from the SQLite website: >> http://www.sqlite.org/ > > The download page no longer mentions any version of SQLite: > > http://www.sqlite.org/download

Re: [sqlite] SQLite version 3.6.23

On Mar 9, 2010, at 4:40 PM, Terence Martin wrote: > On Tue, 9 Mar 2010 16:00:27 -0500 > "D. Richard Hipp" <d...@hwaci.com> wrote: > >> SQLite version 3.6.23 is now available from the SQLite website: >> http://www.sqlite.org/ >> >> >>

[sqlite] SQLite version 3.6.23

cycle of SQLite, in order to mitigate the perception of excessive "code churn". As always, please let me know if you find any problems in the new release. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Different temp_store_directory settings okay?

On Mar 4, 2010, at 4:30 PM, Brian Dantes wrote: > D. Richard Hipp wrote: > >> It is OK for different processes to use different >> temp_store_directory > >> settings. The temp_store_directory is only used for TEMP tables. It > >> does not play a roll in

Re: [sqlite] Different temp_store_directory settings okay?

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

Re: [sqlite] WIKI login

nable access to the CVSTrac wiki at http://www.sqlite.org/cvstrac/wiki D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WIKI login

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

Re: [sqlite] Sqlite Step Strange Results

ing on how many prepared statements you are holding at once and how complex your schema is. > > > Robert Read > > Lead Software Engineer > > Saltillo Corporation > > > > > > ___ > sqlite-users mailing list > sqli

Re: [sqlite] unexpected behavior with CROSS and LEFT JOIN together

On Feb 24, 2010, at 5:45 PM, Igor Tandetnik wrote: > D. Richard Hipp <d...@hwaci.com> wrote: >> This problem has existed in SQLite forever and has never been seen >> before. So it is obscure. The simple fix is to put the ON clause on >> the CROSS JOIN where it b

Re: [sqlite] unexpected behavior with CROSS and LEFT JOIN together

why '=' and 'LIKE' should behave differently in this >>> example. >>> >>> Tom >> >> They do affect the EXPLAIN QUERY PLAN results: >> >> "=" >> order from detail >> 0 0 TABLE currency AS c1 >> 1 1 TABLE currency

Re: [sqlite] sqlite3_close ==> " library routine called out of sequence"

cate the code in order to work around bugs in LLVM. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in porter stemmer

>> /* Step 1c */ >> - if( z[0]=='y' && hasVowel(z+1) ){ >> + if( z[0]=='y' && isConsonant(z+1) && z[2] ){ >>z[0] = 'i'; >> } >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: Sqlite files in temp folder

; programme(s) that are writing these files. > > Your help in this matter is very much appreciated. > > Kind regards, > > Mark Asken D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.6.22 ATTACH no longer works for files outside the current working directory

e error message text "unable to resolve operation" occurs nowhere in the SQLite source code. And nobody else is able to reproduce this problem. So it seems likely to us that you are using adulterate source code. Please try again with fresh, unaltered SQLite source files. D. R

Re: [sqlite] SQLite 3.6.22 ATTACH no longer works for files outside the current working directory

en I try it. Are you using the sqlite3.exe from the SQLite website or another third-party shell? Might your third-party shell be playing games with the string somehow? D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite

Re: [sqlite] Downloading older version of sqlite

rc/info/a39007d5b1 D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] negative numbers

0.0 > 41264890346700test20.0-120.00.045.00.0 > > --- > I have tried lon= varchar(45) and also as a FLOAT, and both don't seem > to handle negative numbers correctly. FLOAT should work. Are you sure you tried it correctly? > Any help appr

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

ex would be useful, but they are the exception rather than the rule.) On the other hand, SQLite still has to maintain the index on INSERT, UPDATE, and DELETE operations which will slow those operations down. D. Richard Hipp d...@hwaci.com ___ sqlite-users m

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

On Jan 29, 2010, at 6:15 AM, Max Vlasov wrote: > To be sure that there's no > full or almost-full table scan I use VFS monitoring in such cases. The sqlite3_stmt_status() interface was designed for this purpose. http://www.sqlite.org/c3ref/stmt_status.html D. Richard Hipp d...@hwa

Re: [sqlite] Parsing create statements

pts to investigate this have been fruitful. SQLite doesn't really do a parse tree so much. It does a little. Sometimes. But its style of operation is closer to "syntax directed translation", especially for the CREATE TABLE statement. D. Richard Hipp d...@hwaci.com

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

default nocase collation. > ___________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile time warning

appears to be harmless (correct code is generated in spite of the warning). So you should simply ignore it. > > Thanks, > Daniel. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cg

Re: [sqlite] Fossil/SQLite server is down

ly available on the primary server. But hopefully Linode will have the problem resolved soon. A second backup server is provided by a different hosting service (Hurricane Electric) but hopefully that 2nd backup will not be necessary D. Richard Hipp d.

Re: [sqlite] SQL syntax diagrams

aq.html#q25 and http://www.sqlite.org/search?q=syntax+diagrams D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_CANTOPEN Bohrbug

a single big transaction. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sort Alphanumeric, Numeric data in a VARCHAR

A03, A06 at the end of the list? SELECT * FROM mytable ORDER BY CASE WHEN point_number GLOB '*[^0-9.]*' THEN point_number ELSE cast(point_number AS real) END; D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http:/

Re: [sqlite] Reasons for SQLITE_CANTOPEN

>> >> The problem was indeed that I reached the maximum number of fds. >> Thanks >> for the help! > > If SQLite had reported the errno value from the failed system call, > the cause would have been obvious and this entire investigation would > have been unnecess

Re: [sqlite] Speed regression after 3.6.17

On Jan 11, 2010, at 9:28 PM, ve3meo wrote: > Oddly enough, by revising the query to explicitly > use an index, the two later releases are much faster... Did you run ANALYZE before you tried using explicit indices? D. Richard Hipp d...@hwa

Re: [sqlite] INTERSECT optimization, is it possible?

status(db, SQLITE_STMTSTATUS_SORT, 1) returns 0, then the query does not use temporary tables and runs in constant space. But I might be wrong. And in any event, that rule is subject to change in a future release if we decide we can get better performance by doing things differently. D. Ric

Re: [sqlite] [bug+patch] Old lemon bug reintroduced

On Jan 6, 2010, at 7:50 PM, D. Richard Hipp wrote: > > On Jan 6, 2010, at 7:47 PM, Wilson, Ronald wrote: > >> Does check-in [077a6bee2d] resolve the issue below? >> >> http://www.sqlite.org/src/vinfo/077a6bee2d >> > > > Yes. I didn't realize the issue h

  1   2   3   4   5   6   7   8   9   10   >