sers-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
>
> Would it b
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
x myself, 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
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"
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 wrote:
> 2014-05-27 5:57 GMT+02:00 jose isaias cabrera :
> > "Richa
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 ".help
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 wrote:
> Hello,
> I have
es the 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 wrote:
> On Wed, Jul 11, 2012 at 7:49 P
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
.emclient.com/temp/mail_data.zipthat 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
uot; 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,
Filip Navara
__
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 do
ch 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
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 :
> Dear all,
>
> we are using SQ
On Thu, Nov 10, 2011 at 7:00 PM, Filip Navara wrote:
[snip]
The bug has been present since this check-in on 2011-07-28:
http://sqlite.org/src/info/8a145863d1a8711953ae72d706404fb96f6fec06
F.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
ct
11/10/2011 17:23: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_d
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( tags TEXT);
> INSERT INTO
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
sqlite-u
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-
subquery?
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 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,
F
ueChangeSuggestion
WHERE InvItemChangeSuggestion.iicsID =
InvItemPropValueChangeSuggestion.iicsID
AND propID = -4
AND apprVersion <> 0
ORDER BY registerTime ASC
)
GROUP BY invitemID, propID
)
WHERE (val <> 'AB123987')
));
Best regards,
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
> until recently.when a
On Mon, Sep 5, 2011 at 1:18 PM, Jaco Breitenbach
wrote:
> Dear all,
>
> Any speculation on if and how the new code would affect inserts into an
> indexed table?
>
> Jaco
It doesn't affect them at all. The optimization specifically targets
sorting large amount of data.
Bes
n command.
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
. 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
On Fri, Sep 2, 2011 at 6:04 PM, Dan Kennedy wrote:
> On 09/02/2011 07:32 PM, Filip Navara wrote:
>>
>> On Fri, Sep 2, 2011 at 11:04 AM, Filip Navara
>> wrote:
>> *snip*
>>>
>>> The time to create an index on my 266 Mb experimental database is
On Fri, Sep 2, 2011 at 5:23 PM, Simon Slavin 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 more
>>> than 9 minutes
On Fri, Sep 2, 2011 at 11:04 AM, Filip Navara 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 SQLite versions:
[2869ed2829]
47,75 / 0,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
On Tue, Aug 16, 2011 at 10:39 AM, Filip Navara 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
> the following query:
On Tue, Aug 16, 2011 at 2:19 PM, Richard Hipp wrote:
> On Tue, Aug 16, 2011 at 5:37 AM, Filip Navara wrote:
>
>> Is version 3.7.8 scheduled for September 28 (according to changes.in)
>> or August 28 (bi-monthly schedule)?
>>
>> Current target release date is 2011
On Tue, Aug 16, 2011 at 2:54 PM, Filip Navara wrote:
> On Tue, Aug 16, 2011 at 2:24 PM, Simon Slavin 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);
>>>
>>>
On Tue, Aug 16, 2011 at 2:56 PM, Richard Hipp wrote:
> On Tue, Aug 16, 2011 at 8:54 AM, Filip Navara wrote:
>
>> On Tue, Aug 16, 2011 at 2:24 PM, Simon Slavin
>> wrote:
>> >
>> > On 16 Aug 2011, at 9:39am, Filip Navara wrote:
>> >
>> >>
On Tue, Aug 16, 2011 at 2:24 PM, Simon Slavin 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" can be pretty large. Let
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
.b = b.b the query could actually be rewritten 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
___
rows)
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
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>
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(
What platform is set as target for the VB.NET code (x86 / x64 / Any CPU)?
Which build of the SQLite library and the ADO.NET provider are you using?
On Wed, May 4, 2011 at 9:17 PM, kp2011 wrote:
>
> this is the vb net code I was running
>
> Dim f As New OpenFileDialog
> f.Filter = "SQLi
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) by:
>
> CREATE TABLE Tg (TgConfigId
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 wrote:
> Support just flagged another site. This one has a more "interesting"
> corruption issue in that d
tes instead of less than 4 kilobytes 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
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
On Wed, Apr 6, 2011 at 9:27 AM, Filip Navara wrote:
> On Wed, Apr 6, 2011 at 6:36 AM, Dan Kennedy 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 o
On Wed, Apr 6, 2011 at 6:36 AM, Dan Kennedy 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 database is used in WAL mode with auto_
On Tue, Apr 5, 2011 at 11:49 AM, Filip Navara 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.
>
> When running the "pragma increm
es, in 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
t;
> 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 now reliably corrupt the da
others can
reproduce it using the same script.
Best regards,
Filip Navara
On Fri, Aug 20, 2010 at 5:25 PM, Filip Navara wrote:
> Hello,
>
> is there anybody willing to help analyze corrupted database for
> possible bug in SQLite?
>
> It is a database file taken from one of our
se 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
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 below presents a number of
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 as I know SQLite opens
, 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 wrote:
> I tried to reproduce the issue with the latest versi
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;
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
Btw, the failing application call is DeleteFileW.
F.
On Tue, Jul 13, 2010 at 5:02 PM, Filip Navara wrote:
> Hi,
>
> for a few days we have been running our application with SQLite built from
> the 201007091257 snapshot. The application runs on Windows 7 systems that
> are fu
sue and we 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
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:
> Is it possible in you
gt; 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 Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
on 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
__
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
___
rtoiseSVN/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
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
wrote:
> Do you ever teriminate threads via TerminateThread() or run as a service
> (where the scm will call terminateThread() once y
ds 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-users mail
"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:
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
> engine? I mean, there's no cli
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 wrote:
> Hi !
>
> I really missin
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,
On Sat, May 30, 2009 at 7:43 AM, John Machin 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 have saved the database files. On
to be
created 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
wrote:
> I sometimes get either a SQLITE_IOERR or a SQL
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 any
>> table in the database.
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 wrote:
> Hi again,
>
> the bug was introduced in revision 1.573 of pager.c.
>
> Best regards,
> Filip Navara
>
> On Fri
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 wrote:
>
> Hello,
>
> today I tried to upgrade our software from SQLite version 3.6.3 to version
> 3.6.13 and I am hitting a race condition th
e. I'm 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",
ation 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 wrote:
> Hello,
>
> after seeing the recent change #6413 and ticket #3761 I finally
> decided to write about a corruption issue we have.
>
>
nfortunately 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 Wait
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 wrote:
> [Full text of an example later in the email.]
>
> For a query like this:
>
> SELECT * FROM t_ft WHERE docid = (SELEC
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
ing column 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:
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:
> Ve
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 th
"(*) 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 1
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 Nel
how about actually attaching the patch? :)
- Filip
On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman <[EMAIL PROTECTED]> wrote:
> I've just started using the rtree extension, and have found that the 32-bit
> float for the range keys is not appropriate for me. Please find attached a
> patch for rtr
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 operates
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 thr
persistent 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.
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 de
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 f
> 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
-
[snip]
> if (sqlite3_prepare(db, "SELECT * FROM tbookings", -1, &rs,
> &psz) ==
> SQLITE_OK)
> {
> rc = SQLITE_ROW;
> while (rc == SQLITE_ROW)
>{
>
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
96 matches
Mail list logo