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 where uniqueId IS
.
Best regards,
Filip Navara
On Thu, Jan 29, 2015 at 9:29 PM, Richard Hipp d...@sqlite.org wrote:
On 1/29/15, Filip Navara filip.nav...@gmail.com wrote:
Hello,
I tried really hard to get partial indexes working, but SQLite refuses to
use them:
create table t (id INTEGER NOT NULL
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.comwrote:
2014-05-27 5:57 GMT+02:00 jose isaias cabrera cabr
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 sadhwan...@gmail.comwrote:
Hello,
I
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 11, 2012 at 7:49 PM, Kohji
: 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
.
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
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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
' - that is the
part I'm trying to figure out.
Best Regards,
Mohit.
http://sqlite.org/fts3.html#section_4_1
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
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 a.ne...@atlas.cz:
Dear all,
we are using SQLite in our
: (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_data';] disk I/O error
Also
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 mailing list
sqlite
Reproduced on Windows, SQLite 3.7.8.
F.
On Thu, Oct 13, 2011 at 5:45 PM, Wendland, Michael
michael.wendl...@hp.com 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
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-bin/mailman
. 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-users@sqlite.org
http
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
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 Navara
=
InvItemPropValueChangeSuggestion.iicsID
AND propID = -4
AND apprVersion 0
ORDER BY registerTime ASC
)
GROUP BY invitemID, propID
)
WHERE (val 'AB123987')
));
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
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 dspai...@msn.com wrote:
hello all i am creating a text mud gamibng engine and has been going great up
until
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
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
http
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 Navarafilip.nav...@gmail.com
wrote:
*snip*
The time to create an index on my 266 Mb experimental database is more
than 9 minutes
/ 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 worst case scenario?
Best regards,
Filip Navara
___
sqlite
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 SQLite versions
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 more
than 9 minutes. The database is available at
http
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
the following query:
select a, d from a;
Full-table
a from a where a IS 'test';
0|0|TABLE a
sqlite explain query plan select a from a where a='test' AND a IS NOT NULL;
0|0|TABLE a WITH INDEX aIdx
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
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.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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 can be pretty large. Let's make
the following query:
select a, d from
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.comwrote:
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
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);
create index aIdx on a (a, d);
Now the data in columns b and c
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.comwrote:
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-09-28
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 ATTACH DATABASE 'attached.dat
. 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(v=vs.85).aspx
http://www.sqlite.org/datatype3.html
F.
On Sat, Apr 16, 2011 at 7:40 PM, Tobias Vesterlund
tobias.vesterl...@ericsson.com 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:
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
corruption issue
format.
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 10:57:07.052116400 +0200
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 database is used in WAL mode with auto_vacuum=1 and page_size=1024.
When
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 with database that originated on computer of one
of our customers
? 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 00 SQLite format 3.
010: 04 00 02 02 00 40 20 20 00 00 00
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.
When running the pragma incremental_vacuum(1
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 database file taken from one of our
...@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 database using standard commands. An
SQL script can be downloaded at the address
On Fri, Aug 20, 2010 at 1:47 PM, Tim Romano tim.romano...@gmail.com wrote:
Igor,
Here's the example where a partial index can hide rows.
From the wikipedia article cited by the OP:
wikipedia
It is not necessary that the condition be the same as the index criterion;
Stonebraker's paper
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
On Thu, Jul 22, 2010 at 1:31 PM, Dan Kennedy danielk1...@gmail.com 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
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
Btw, the failing application call is DeleteFileW.
F.
On Tue, Jul 13, 2010 at 5:02 PM, Filip Navara filip.nav...@gmail.comwrote:
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 fully
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:23 PM, Filip Navara filip.nav...@gmail.com
:
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;
Error: disk I/O error
Sorry for the spamming.
Best regards,
Filip Navara
___
sqlite-users
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 latest version
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 paiva...@gmail.com wrote:
Is
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 Sun, Jan 10
.
Best regards,
Filip Navara
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
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
___
sqlite-users
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 mailing list
sqlite-users@sqlite.org
http
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 terminateThread() once your
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
the database privately.
Best regards,
Filip Navara
Main freelist: Bad ptr map entry key=5143 expected=(2,0) got=(3,4467)
Main freelist: freelist leaf count too big on page 5143
Main freelist: Bad ptr map entry key=5449 expected=(2,0) got=(4,5143)
Main freelist: freelist leaf count too big on page 5449
On Sat, Aug 29, 2009 at 9:51 PM, Yves
Goergennospam.l...@unclassified.de 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
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 Eirasjoao.ei...@gmail.com wrote:
Hi !
I really
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
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 have saved the database files. One
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 SQLITE_IOERR or a SQLITE_CANTOPEN when
PRAGMA schema_version ... for the second case.
F.
On Sat, May 23, 2009 at 4:20 PM, Simon Slavin
slav...@hearsay.demon.co.uk 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
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
12:27:55.1394789 PM,eM
Client.vshost.exe,3308,LockFile,C:\Users\Filip\AppData\Roaming\eM
Client
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 and I am hitting a race condition
= 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,
Filip Navara
On Fri, Apr 17, 2009 at 2:26
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 corruption issue we 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.stopEvent, this.wakeupEvent };
System.Diagnostics.Stopwatch stopWatch
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 WHERE docid = (SELECT rowid
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
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,
I am developping
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:
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
(*) 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
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
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
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 CreateFile SUCCESS
SQLiteTest.exe
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 thread
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 device
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
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
92 matches
Mail list logo
