[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

2015-10-08 Thread Filip Navara
e-users-bounces at mailinglists.sqlite.org] Im Auftrag von Filip Navara > Gesendet: Donnerstag, 08. Oktober 2015 15:55 > An: sqlite-dev at mailinglists.sqlite.org > Cc: General Discussion of SQLite Database > Betreff: Re: [sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing > > Wou

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

2015-10-08 Thread Filip Navara
Would it be possible to include FTS5 in the amalgamation? Thanks, Filip Navara On Wed, Oct 7, 2015 at 4:42 PM, Richard Hipp wrote: > The release checklist for version 3.8.12 > (https://www.sqlite.org/checklists/3081200/index) is now active. The > 3.8.12 release will occur when the

Re: [sqlite] Partial indexes not working for me

2015-01-29 Thread Filip Navara
elf, but I was hoping to replace it with the partial indexes and avoid having the complex triggers. The table "t" usually has thousands to millions of rows, while the index itself should cover only few rows in most cases, typically none. Best regards, Filip Navara On Thu, Jan 29, 20

[sqlite] Partial indexes not working for me

2015-01-29 Thread Filip Navara
Hello, I tried really hard to get partial indexes working, but SQLite refuses to use them: > create table "t" ("id" INTEGER NOT NULL PRIMARY KEY, "flags" INTEGER, "uniqueId", "syncFolder" INTEGER); > create index "i1" on "t" ("id") where "uniqueId" IS NULL; > explain query plan select * from "t"

Re: [sqlite] SQLite version 3.8.5 beta

2014-05-27 Thread Filip Navara
Visual Studio 2013 Update 1 and newer allows explicitly to target Windows XP, but it has to be compiled with correct runtime library. Best regards, Filip Navara On Tue, May 27, 2014 at 11:33 AM, Jan Nijtmans <jan.nijtm...@gmail.com>wrote: > 2014-05-27 5:57 GMT+02:00 jose isaias cabr

[sqlite] Unused partial index

2013-10-30 Thread Filip Navara
Hi, I tried to convert our custom tables and triggers into partial indexes. Unfortunately it seems that the query planner is unable to recognize identical terms. Could this be fixed or is there any workaround? Thanks, Filip Navara SQLite version 3.8.1 2013-10-17 12:57:35 Enter "

Re: [sqlite] sqlite DB's disk image getting malformed

2013-06-20 Thread Filip Navara
This sounds very much like bug described in 7.4 in http://www.sqlite.org/howtocorrupt.html, except for the SQLite version. Are you sure that it's version 3.6.14.2 and not newer? Best regards, Filip Navara On Wed, Jun 19, 2013 at 9:09 PM, Dhiraj Sadhwani <sadhwan...@gmail.com>wrote: &

Re: [sqlite] Improving access speed to fetch indexed column.

2012-07-12 Thread Filip Navara
e covering index is actually smaller than the full table and thus it's less data to read. We use a modified version of SQLite with the attached patch to alleviate the issue. Best regards, Filip Navara On Thu, Jul 12, 2012 at 12:59 PM, Richard Hipp <d...@sqlite.org> wrote: > On Wed, Jul

[sqlite] Inconsistent limit checks

2011-12-06 Thread Filip Navara
VALUES (zeroblob(10)); sqlite> SELECT "c" FROM "a"; Error: string or blob too big Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Excessive memory use in SQLite 3.7.9

2011-12-05 Thread Filip Navara
that exhibits the behavior. Is this something that is intended behavior? Is the memory allocation really necessary? Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL file size

2011-11-30 Thread Filip Navara
ified by the "PRAGMA > journal_size_limit" setting, if you have set the journal_size_limit. > > Would it be possible to enhance SQLite to allow resetting the WAL file down to zero bytes? Something like pragma journal_size_limit=0; pragma wal_checkpoint=restart; Best regards, F

Re: [sqlite] FTS3/FTS4 - Finding the term(s) that completes the input

2011-11-21 Thread Filip Navara
;> > I think my examples muddied the waters. I have looked at Section 3 of the > FTS documents and that lets me bring back the "full result" that matches - > so, if I search for 'ling j', it can tell me that the result that matches > is 'james ling, alibaba'. What it does not le

Re: [sqlite] disk I/O error

2011-11-20 Thread Filip Navara
tabase file. I'd be willing to look at it if such an error is reproduced and the log is available. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.7.7.1 database corruption

2011-11-14 Thread Filip Navara
Hi Alexandr, the mailing list doesn't allow attachments. Please send us the output of "pragma integrity_check;" on the corrupted database file. Also, is the database used in WAL mode? Best regards, Filip Navara 2011/11/14 Alexandr Němec <a.ne...@atlas.cz>: > Dear all, >

Re: [sqlite] Critical bug in Windows VFS retry logic

2011-11-10 Thread Filip Navara
On Thu, Nov 10, 2011 at 7:00 PM, Filip Navara <filip.nav...@gmail.com> wrote: [snip] The bug has been present since this check-in on 2011-07-28: http://sqlite.org/src/info/8a145863d1a8711953ae72d706404fb96f6fec06 F. ___ sqlite-users mailin

[sqlite] Critical bug in Windows VFS retry logic

2011-11-10 Thread Filip Navara
3:46 3338 os_win.c:34346: (0) winAccess(C:\Users\Filip Navara\AppData\Roaming\eM Client\event_data.dat-journal) - The operation completed successfully. 11/10/2011 17:23:46 3338 statement aborts at 5: [ATTACH DATABASE 'C:\Users\Filip Navara\AppData\Roaming\eM Client\event_data.dat' AS 'event_

Re: [sqlite] Malformed database error when using FTS3/4

2011-10-13 Thread Filip Navara
Reproduced on Windows, SQLite 3.7.8. F. On Thu, Oct 13, 2011 at 5:45 PM, Wendland, Michael wrote: > Hello, > > I've encountered an error running 3.7.8 and 3.7.7.1 that seems rather > strange.  It's reproducible so far as I know. > > CREATE VIRTUAL TABLE fts USING fts3(

Re: [sqlite] Problem with vacuum when count_changes=1

2011-09-30 Thread Filip Navara
he crash > started happening. I just know for sure that ancient version 3.6.6.1 we were > using before did not crash. It's fixed now, see http://www.sqlite.org/src/info/c48d99d690 Thanks, Dan! Best regards, Filip Navara ___ sqlite-users mailing list

Re: [sqlite] Problem with vacuum when count_changes=1

2011-09-30 Thread Filip Navara
Reproduced with the following steps: > sqlite3 test.db pragma count_changes=1; create table a (a); vacuum; (SQLite 3.7.8 on Windows) Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-

[sqlite] Index not used in subquery

2011-09-22 Thread Filip Navara
in the subquery? Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Internal v. External BLOBs

2011-09-21 Thread Filip Navara
> We did some experiments to try to answer this question, and the results > seemed interesting enough to share with the community at large. Are the test cases available somewhere? I'd be interested in running them on Windows setup with/out SSD. Thanks, Filip

[sqlite] Verified crash with SQLite 3.7.8 and 3.7.7.1

2011-09-15 Thread Filip Navara
uggestion.iicsID = InvItemPropValueChangeSuggestion.iicsID AND propID = -4 AND apprVersion <> 0 ORDER BY registerTime ASC ) GROUP BY invitemID, propID ) WHERE (val <> 'AB123987') )); Best regards, Filip Navara ___ sqlite-use

Re: [sqlite] Double Spaced Blob Text

2011-09-07 Thread Filip Navara
I guess the database is encoded in UTF-16 and you are reading the text using sqlite3_column_blob instead of sqlite3_column_text. F. On Wed, Sep 7, 2011 at 5:15 PM, Daniel Spain wrote: > > > > > hello all i am creating a text mud gamibng engine and has been going great up >

Re: [sqlite] Speeding up index creation

2011-09-05 Thread Filip Navara
ing large amount of data. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Speeding up index creation

2011-09-05 Thread Filip Navara
otal time spent executing a given command. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Speeding up index creation

2011-09-04 Thread Filip Navara
. OP_IdxInsert always seeks for the new Btree row in the resulting tree. Couldn't we exploit the fact that the rows are already sorted to construct the Btree faster? Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Speeding up index creation

2011-09-03 Thread Filip Navara
On Fri, Sep 2, 2011 at 6:04 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 09/02/2011 07:32 PM, Filip Navara wrote: >> >> On Fri, Sep 2, 2011 at 11:04 AM, Filip Navara<filip.nav...@gmail.com> >>  wrote: >> *snip* >>> >>> The time to c

Re: [sqlite] Speeding up index creation

2011-09-02 Thread Filip Navara
On Fri, Sep 2, 2011 at 5:23 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 2 Sep 2011, at 3:24pm, Simon Slavin wrote: > >> On 2 Sep 2011, at 10:04am, Filip Navara wrote: >> >>> The time to create an index on my 266 Mb experimental database is m

Re: [sqlite] Speeding up index creation

2011-09-02 Thread Filip Navara
On Fri, Sep 2, 2011 at 11:04 AM, Filip Navara <filip.nav...@gmail.com> wrote: *snip* > The time to create an index on my 266 Mb experimental database is more > than 9 minutes. *snip* I erroneously measured the time with DEBUG build, so I've rerun the experiment with several SQL

[sqlite] Speeding up index creation

2011-09-02 Thread Filip Navara
,18 sqlite3BtreeMovetoUnpacked / 40,49 / 3,33 .. sqlite3VdbeRecordCompare / 27,04 / 4,69 sqlite3MemCompare / 15,36 / 7,85 I'm wondering if there's any way to speed up the index creation. Is larger cache size supposed to improve the performance? Did I perhaps hit some

Re: [sqlite] Improving the query optimizer

2011-08-23 Thread Filip Navara
On Tue, Aug 16, 2011 at 10:39 AM, Filip Navara <filip.nav...@gmail.com> wrote: > 1) Consider the following schema: > > create table a (a, b, c, d); > create index aIdx on a (a, d); > > Now the data in columns "b" and "c" can be pretty large. Let's make

Re: [sqlite] Version 3.7.8

2011-08-16 Thread Filip Navara
On Tue, Aug 16, 2011 at 2:19 PM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Aug 16, 2011 at 5:37 AM, Filip Navara <filip.nav...@gmail.com>wrote: > >> Is version 3.7.8 scheduled for September 28 (according to changes.in) >> or August 28 (bi-monthly schedule)? >

Re: [sqlite] Improving the query optimizer

2011-08-16 Thread Filip Navara
On Tue, Aug 16, 2011 at 2:54 PM, Filip Navara <filip.nav...@gmail.com> wrote: > On Tue, Aug 16, 2011 at 2:24 PM, Simon Slavin <slav...@bigfraud.org> wrote: >> >> On 16 Aug 2011, at 9:39am, Filip Navara wrote: >> >>> create table a (a, b, c, d); >

Re: [sqlite] Improving the query optimizer

2011-08-16 Thread Filip Navara
On Tue, Aug 16, 2011 at 2:56 PM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Aug 16, 2011 at 8:54 AM, Filip Navara <filip.nav...@gmail.com>wrote: > >> On Tue, Aug 16, 2011 at 2:24 PM, Simon Slavin <slav...@bigfraud.org> >> wrote: >> > >&

Re: [sqlite] Improving the query optimizer

2011-08-16 Thread Filip Navara
On Tue, Aug 16, 2011 at 2:24 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Aug 2011, at 9:39am, Filip Navara wrote: > >> create table a (a, b, c, d); >> create index aIdx on a (a, d); >> >> Now the data in columns "b" and "c&q

[sqlite] Version 3.7.8

2011-08-16 Thread Filip Navara
Is version 3.7.8 scheduled for September 28 (according to changes.in) or August 28 (bi-monthly schedule)? Thanks, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Query optimizer and foreign keys

2011-08-16 Thread Filip Navara
n as: select b from b where c=''; What use cases could you think of that would benefit from use of foreign key information in query planning? What caveats could you think of? Thanks, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Improving the query optimizer

2011-08-16 Thread Filip Navara
) explain query plan select a, d from a where a >= 0 or a < 0; 0|0|0|SEARCH TABLE a USING COVERING INDEX aIdx (a>?) (~25 rows) 0|0|0|SEARCH TABLE a USING COVERING INDEX aIdx (a explain query plan select a from a where a='test' AND a IS NOT NULL; 0|0|TABLE a WITH INDEX aId

[sqlite] Bug: Database with non-loadable schema can be created

2011-07-01 Thread Filip Navara
Hello, I have hit a bug that allows creation of a database that couldn't be loaded. Step to reproduce are listed below. Best regards, Filip Navara >sqlite3.exe SQLite version 3.7.6.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> ATT

[sqlite] Bug: ERROR_DISK_FULL is not handled in Win32 OS layer

2011-06-09 Thread Filip Navara
of the error. Apparently we get the later error on NTFS formatted systems when the disk is out of space. It would greatly help us with diagnostics if the correct error code was returned from SQLite (SQLITE_FULL). Best regards, Filip Navara [1] http://msdn.microsoft.com/en-us/library/ms681382(

Re: [sqlite] 'integer'

2011-04-16 Thread Filip Navara
http://www.sqlite.org/datatype3.html F. On Sat, Apr 16, 2011 at 7:40 PM, Tobias Vesterlund wrote: > Hi, > > I ran into something I don't understand, maybe someone here can shed some > light on it for me. > > I have a table named Tg which is created (with tcl)

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-14 Thread Filip Navara
Just to be sure. Could you run the application under Application Verifier with heap checks enabled? Best regards, Filip Navara On Thu, Apr 14, 2011 at 11:40 AM, James Green <james.mk.gr...@gmail.com> wrote: > Support just flagged another site. This one has a more "interesting"

Re: [sqlite] Problem with incremental_vacuum and WAL

2011-04-07 Thread Filip Navara
obytes in my case. My proposed solution is to move the sqlite3PagerWrite call just before the code that actually modifies the page, as in the patch below. Best regards, Filip Navara --- old\btree.c 2011-01-28 08:15:16.0 +0100 +++ btree.c 2011-04-07 10:57:07.052116400 +0200 @@ -4893,10 +

Re: [sqlite] Problem with incremental_vacuum and WAL

2011-04-07 Thread Filip Navara
n dealing with corrupted databases or when trying to understand the SQLite3 file format. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with incremental_vacuum and WAL

2011-04-06 Thread Filip Navara
On Wed, Apr 6, 2011 at 9:27 AM, Filip Navara <filip.nav...@gmail.com> wrote: > On Wed, Apr 6, 2011 at 6:36 AM, Dan Kennedy <danielk1...@gmail.com> wrote: >> On 04/05/2011 04:49 PM, Filip Navara wrote: >>> Hello, >>> >>> we are having problem

Re: [sqlite] Problem with incremental_vacuum and WAL

2011-04-06 Thread Filip Navara
On Wed, Apr 6, 2011 at 6:36 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 04/05/2011 04:49 PM, Filip Navara wrote: >> Hello, >> >> we are having problem with database that originated on computer of one >> of our customers. >> >> The da

Re: [sqlite] Problem with incremental_vacuum and WAL

2011-04-05 Thread Filip Navara
On Tue, Apr 5, 2011 at 11:49 AM, Filip Navara <filip.nav...@gmail.com> wrote: > Hello, > > we are having problem with database that originated on computer of one > of our customers. > > The database is used in WAL mode with auto_vacuum=1 and page_size=1024. >

[sqlite] Problem with incremental_vacuum and WAL

2011-04-05 Thread Filip Navara
n what circumstances? - Is the free list corrupted? And if it is, how could this happen and should "pragma integrity_check;" verify it? Best regards, Filip Navara -- showdb mail_data.dat dbheader -- Pagesize: 1024 Available pages: 1..1389458 000: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33

Re: [sqlite] Help with database corruption?

2010-08-23 Thread Filip Navara
___ > > From: sqlite-users-boun...@sqlite.org on behalf of Filip Navara > Sent: Mon 8/23/2010 7:43 AM > To: General Discussion of SQLite Database > Cc: d...@hwaci.com > Subject: EXTERNAL:Re: [sqlite] Help with database corruption? > > > > I can

Re: [sqlite] Help with database corruption?

2010-08-23 Thread Filip Navara
that others can reproduce it using the same script. Best regards, Filip Navara On Fri, Aug 20, 2010 at 5:25 PM, Filip Navara <filip.nav...@gmail.com> wrote: > Hello, > > is there anybody willing to help analyze corrupted database for > possible bug in SQLite? > > It is a data

[sqlite] Help with database corruption?

2010-08-20 Thread Filip Navara
tabase file and they definitely were there at some point, but I am not familiar enough with the file format to track the whole freelist and find where the corruption exactly happen. All I know is that page 388 is corrupted and points to a location outside of the database file. Thanks, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] partial index?

2010-08-20 Thread Filip Navara
On Fri, Aug 20, 2010 at 1:47 PM, Tim Romano wrote: > Igor, > Here's the example where a partial index can "hide" rows. > > From the wikipedia article cited by the OP: > > > It is not necessary that the condition be the same as the index criterion; > Stonebraker's paper

Re: [sqlite] SQLite version 3.7.0

2010-07-22 Thread Filip Navara
On Thu, Jul 22, 2010 at 1:31 PM, Dan Kennedy wrote: [snip] > You cannot delete a file while it is open on windows, so > this doesn't come up on win32. Sure you can, except: - The correct sharing rights have to be specified for this to be allowed (FILE_SHARE_DELETE). As far

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
which was supposed to avoid deleting the journal file, but for some reason the new SQLite version tries to do it anyway while the older one didn't. Best regards, Filip Navara On Tue, Jul 13, 2010 at 11:21 PM, Shane Harrelson <sh...@sqlite.org> wrote: > I tried to reproduce the issue with the

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
nal_mode=truncate; truncate The second instance: SQLite version 3.7.0 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma encoding="UTF-8"; sqlite> pragma auto_vacuum=incremental;

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
ng the database file. When I change the code to pragma main.journal_mode=truncate; pragma encoding="UTF-8"; pragma auto_vacuum=incremental; the problem doesn't happen anymore. Even if I use this code sequence SQLite still tries to access the WAL file. F. On Tue, Jul 13, 2010 at 5:

Re: [sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
Btw, the failing application call is DeleteFileW. F. On Tue, Jul 13, 2010 at 5:02 PM, Filip Navara <filip.nav...@gmail.com>wrote: > Hi, > > for a few days we have been running our application with SQLite built from > the 201007091257 snapshot. The application runs on

[sqlite] Regression with sqlite-snapshot-201007091257

2010-07-13 Thread Filip Navara
will provide any additional information requested. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with locked journal file

2010-06-24 Thread Filip Navara
Ok, I'll expand on that suggestion, try PRAGMA journal_mode=truncate; If you are using TortoiseSVN on the machine than the most likely cause is the TSVNCache process. We had countless issues with it. Best regards, F.N. On Wed, Jun 23, 2010 at 8:18 PM, Pavel Ivanov wrote: >

Re: [sqlite] Sqlite 2.1 -> 3 migration

2010-02-22 Thread Filip Navara
> sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Hi, this may be a stupid question, but have you used the BINARY mode when downloading the file from the FTP? Best regards, Filip Nava

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-10 Thread Filip Navara
Hi! Does "pragma journal_mode=truncate;" make any difference? Is this on Windows? Do you have TortoiseSVN installed on the same system? If you answer Yes to all these questions then use Google, I have already explained at least twice why it happens. Best regards, Filip Navara On S

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-10 Thread Filip Navara
rther analysis and hopefully it will give a clue on why it happens. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite bug report - large databases only - 'database or disk is full'

2009-12-08 Thread Filip Navara
production systems. I will post more details soon. Our database files have page size 4Kb and all of the affected systems are running Windows. We use incremental vacuum mode and the file sizes are commonly over 1 Gb large, file system is NTFS (afaik). Best regards, Filip Navara

[sqlite] Broken RSS

2009-12-01 Thread Filip Navara
Hello, the RSS at http://www.sqlite.org/src/timeline.rss is broken. The contents of several elements are not properly escaped (< and > characters), so several readers can't parse it - Google Reader for example. Best regards, Filip Navara ___

Re: [sqlite] Corrupted database

2009-10-14 Thread Filip Navara
ny machine with TortoiseSVN/TortoiseGIT or other programs installed. Now that journal_mode=truncate exists we can try switching to that. Best regards, Filip Navara ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Corrupted database

2009-10-14 Thread Filip Navara
killed few times when exception happened during database manipulation though. Best regards, Filip Navara On Wed, Oct 14, 2009 at 5:45 PM, McClellen, Chris <cmcclel...@weather.com> wrote: > Do you ever teriminate threads via TerminateThread() or run as a service > (where the scm will call

Re: [sqlite] Corrupted database

2009-10-14 Thread Filip Navara
sh, hard killed threads and so on. Previous version of the application frequently forgot to close the databases on exit and did other nasty things that and now fixed, but none of them should cause the database to be corrupted. Best regards, Filip Navara ___

[sqlite] Corrupted database

2009-10-12 Thread Filip Navara
CT "id" FROM mail_fti.LocalMailsIndex3 WHERE content MATCH "...") Anybody has seen something like this? Anybody willing to look at it? I can send the database privately. Best regards, Filip Navara Main freelist: Bad ptr map entry key=5143 expected=(2,0) got=(3,4467) Main freelist:

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-30 Thread Filip Navara
On Sat, Aug 29, 2009 at 9:51 PM, Yves Goergen wrote: > On 01.08.2009 16:19 CE(S)T, Noah Hart wrote: >> This is not a driver, dll, or wrapper.  This is a port of the underlying >> SQLite software. > > Hm, yes, but isn't the other C# SQLite assembly also the entire DB >

Re: [sqlite] Feeds for sqlite releases

2009-06-27 Thread Filip Navara
Hi, there already is an RSS feed - http://www.sqlite.org/cvstrac/timeline.rss - unfortunately it can't be limited to display only the milestones as regular web timeline can. Best regards, Filip Navara On Sun, Jun 28, 2009 at 12:49 AM, João Eiras<joao.ei...@gmail.com> wrote: > Hi ! >

Re: [sqlite] Query regarding downloading 3.2.2 version of Sqlite

2009-06-15 Thread Filip Navara
Heya, search for sqlite-3_2_2.zip or sqlitedll-3_2_2.zip ( http://www.ponx.org/download/CD/Python/sqlitedll-3_2_2.zip) on Google. They're no longer available from the official site. Alternatively you can checkout the correct version from SQLite CVS and compile it yourself. Best regards, Filip

Re: [sqlite] Corruption of incremental_vacuum databases

2009-05-30 Thread Filip Navara
On Sat, May 30, 2009 at 7:43 AM, John Machin <sjmac...@lexicon.net> wrote: > On 17/04/2009 1:39 AM, Filip Navara wrote: >> Hello, >> >> I have expected at least some reply. Oh well, new the corruption has happened >> again (on another different machine) and I h

Re: [sqlite] Question on errors - IOERR and CANTOPEN

2009-05-26 Thread Filip Navara
ated and the old one will disappear as soon as the offending application closes the last handle to it. Anyway... don't want to hick your thread :) Best regards, Filip Navara On Tue, May 26, 2009 at 7:51 AM, Dennis Volodomanov <dennis.volodoma...@conceiva.com> wrote: > I sometimes get either a SQLI

Re: [sqlite] Feature request

2009-05-23 Thread Filip Navara
PRAGMA schema_version ... for the second case. F. On Sat, May 23, 2009 at 4:20 PM, Simon Slavin wrote: > > On 21 May 2009, at 5:59am, Simon Slavin wrote: > >> int sqlite3_change_count(sqlite3*) >> >> Returns an integer which is incremented whenn a change is made to

Re: [sqlite] SQLITE_CANTOPEN error / bug?

2009-04-17 Thread Filip Navara
hareMode = FILE_SHARE_READ | FILE_SHARE_WRITE; }else{ dwShareMode = 0; Best regards, Filip Navara On Fri, Apr 17, 2009 at 3:30 PM, Filip Navara <filip.nav...@gmail.com> wrote: > Hi again, > > the bug was introduced in revision 1.573 of pager.c. > > Best regards, >

Re: [sqlite] SQLITE_CANTOPEN error / bug?

2009-04-17 Thread Filip Navara
Hi again, the bug was introduced in revision 1.573 of pager.c. Best regards, Filip Navara On Fri, Apr 17, 2009 at 2:26 PM, Filip Navara <filip.nav...@gmail.com> wrote: > > Hello, > > today I tried to upgrade our software from SQLite version 3.6.3 to version > 3.6.13 an

[sqlite] SQLITE_CANTOPEN error / bug?

2009-04-17 Thread Filip Navara
not sure what would be the correct solution (setting sharing mode in winOpen?). Anyone can help or offer any insight? Thanks, Filip Navara "Time of Day","Process Name","PID","Operation","Path","Result","Detail","TID"

Re: [sqlite] Corruption of incremental_vacuum databases

2009-04-16 Thread Filip Navara
that it could be related to the issues in the tickets listed below. Thanks, Filip Navara On Tue, Mar 31, 2009 at 11:05 AM, Filip Navara <xnav...@volny.cz> wrote: > Hello, > > after seeing the recent change #6413 and ticket #3761 I finally > decided to write about a corrup

[sqlite] Corruption of incremental_vacuum databases

2009-03-31 Thread Filip Navara
ly I don't have any of the corrupted databases at hand and I have no deterministic way to create them. My question is if these could be related to the just fixed problem (in ticket 3761) or if it could be another issue? Best regards, Filip Navara WaitHandle[] handles = new WaitHandle[] { this

Re: [sqlite] Unexpected interaction between virtual tables and the IN operator.

2008-12-19 Thread Filip Navara
Any update on this? It's seriously affecting performance in our application. Best regards, Filip Navara On Tue, Aug 12, 2008 at 6:33 PM, Scott Hess <sh...@google.com> wrote: > [Full text of an example later in the email.] > > For a query like this: > > SELECT * FROM t_ft

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-26 Thread Filip Navara
That'd happen if you use the 32bit DLL with 64bit application... F. On Tue, Nov 25, 2008 at 1:59 PM, Ti Ny <[EMAIL PROTECTED]> wrote: > > I am getting an exception: An attempt was made to load a program with a > incorrect format. (HRESULT: 0x8007000B) when I am trying to use > sqlite3_open16 on

Re: [sqlite] Can I use sqlite3_bind for colmun name or ASC/DESC selector?

2008-10-25 Thread Filip Navara
names, ASC/DESC, etc. would change the meaning of the query and the compiled code wouldn't be reusable (eg. using ASC or DESC could result in use of different index and so on). Best regards, Filip NAvara On Sat, Oct 25, 2008 at 6:54 PM, mfujisaw <[EMAIL PROTECTED]> wrote: > Hi, guys,

Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows

2008-10-15 Thread Filip Navara
Hmm, it didn't help. I can still easily reproduce the TortoiseSVN bug. The only reliable workaround is to use different journal_mode (or implementing renaming of the journal file before deleting it). Best regards, F. On Wed, Oct 15, 2008 at 2:33 PM, Shane Harrelson <[EMAIL PROTECTED]> wrote: >

Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows

2008-10-14 Thread Filip Navara
http://www.mail-archive.com/sqlite-users@sqlite.org/msg34453.html On Mon, Oct 13, 2008 at 6:52 PM, Doug <[EMAIL PROTECTED]> wrote: > I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN > when doing an insert. When that fails, I can use the debugger to go back up > and step

Re: [sqlite] Vista frustrations

2008-09-17 Thread Filip Navara
"(*) Sun's ZFS can even detect strided sequential access - ie reading X amount of data every Y kilobytes." ... and so can the NT cache manager since the very first Windows NT release ;-) It's good to see that people are finally adapting these features 15 years later. F. On Wed, Sep 17, 2008 at

Re: [sqlite] database file size isn't really very small

2008-07-18 Thread Filip Navara
Not really two copies as the integer could be primary key ... something along the lines of CREATE TABLE StockName (date INTEGER PRIMARY KEY, price REAL); Regards, F. On Fri, Jul 18, 2008 at 10:03 PM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey

Re: [sqlite] SQlite 3.5.9 and Vista 64

2008-06-11 Thread Filip Navara
http://www.nabble.com/CANTOPEN-error-on-Windows-systems-running-TortoiseSVN-to17656998.html - Filip On Thu, Jun 12, 2008 at 12:46 AM, derek walters <[EMAIL PROTECTED]> wrote: > I have a program that uses sqlite_exec in a loop of about a thousand > queries. In windows XP (32), the program

Re: [sqlite] CANTOPEN error on Windows systems running TortoiseSVN

2008-06-04 Thread Filip Navara
On Wed, Jun 4, 2008 at 11:41 PM, Eric Minbiole <[EMAIL PROTECTED]> wrote: > It looks like you can configure TortoiseSVN to include / exclude > specific paths during its searches. Though I've not tried it, I would > think you could simply exclude any paths that contain SQLite databases. > This

[sqlite] CANTOPEN error on Windows systems running TortoiseSVN

2008-06-04 Thread Filip Navara
ersistent journals (unfortunately the version of SQLite we use doesn't support them). Best regards, Filip Navara The relevant part of the log is TSVNCache.exe QueryOpen FAST IO DISALLOWED SQLiteTest.exe CloseFile SUCCESS TSVNCache.exe CreateFile SUCCESS SQLiteTest.exe Creat

Re: [sqlite] nVARCHAR as unique index

2008-05-14 Thread Filip Navara
CREATE INDEX BrandKey2 ON Brand(BrandDescription); On Wed, May 14, 2008 at 7:32 AM, Farzana <[EMAIL PROTECTED]> wrote: > > Thanks for your reply Igor. > > When we checked with the provided query we found that the duplicate values > are present in the BrandDescription. We are working with the

Re: [sqlite] delimiting text with embedded quotes

2008-05-08 Thread Filip Navara
You don't want to use double quotes for strings actually, they can refer to column names. The correct way is to use single quotes (') and escape the quotes in actual text by using two single quotes (''). F. On Thu, May 8, 2008 at 12:47 PM, <[EMAIL PROTECTED]> wrote: > I am converting text data

Re[2]: [sqlite] Regarding aborting a query

2006-10-03 Thread Filip Navara
> At the present time, sqlite hadn't implemented syntax such as LIMIT 0,5. So > you have to do it manually. It's fairly easy if you use prepared statements. > The steps are as follows: Actually it implements such syntax. See LIMIT and OFFSET at http://www.sqlite.org/lang_select.html Filip

Re: [sqlite] Where to look in the code for this ?

2006-10-02 Thread Filip Navara
[snip] > if (sqlite3_prepare(db, "SELECT * FROM tbookings", -1, , > ) == > SQLITE_OK) > { > rc = SQLITE_ROW; > while (rc == SQLITE_ROW) >{ >

[sqlite] Full-text searching

2006-10-01 Thread Filip Navara
tokenizer for dissecting text/html documents. Is some such feature planned to be implemented? (Currently the tokenizer is set per virtual table which is unusable for us) Alternatively, will there be any flag to not store content in the fulltext engine tables? Best regards, Filip Navara www.emclient.com